Write a trigger for total percentage of all appointments

Assignment Help Programming Languages

Reference no: EM1360494

Emp(eid: numeric, ename: varchar, age: numeric, salary: numeric) Works(eid: numeric, did: numeric, pct_time: numeric)
Dept(did: numeric, budget: numeric, managerid: numeric)

have to create Emp, Works and Dept tables, populate with given data below.gotta write integrity constraints (domain, key, foreign key, or CHECK constraints) to ensure each of the following:

a. Employees must make a minimum salary of $1000.

b. The pct time field of the Works relation shows the percentage of time that a given employee works in a given department and this value cannot be greater than 100.

c. An employee can work in more than one department.

d. Every manager must also be an employee.

Also gotta write triggers to ensure each of the following requirements, considered independently. (I should handle the errors that may occur in your triggers and give at least one insertion (or update) example per question, which will be blocked by the triggers.

a. Write a trigger on Works department to ensure the following requirement; the total percentage of all appointments for an employee must be fewer than 100%.
b. Write a trigger on Emp table to ensure the following requirement; when a new employee enters the company his/her salary should be lower than the department manager otherwise do not insert its record into tables and give an error message

Reference no: EM1360494

Questions Cloud

Strategies for testing internal controls : Discuss and explain three strategies for testing internal controls when information technology is used for significant accounting processing.

Show standards of living in the u.s. : How does the standard of living differ for the average American versus for the average person living in India

Explain how the negotiation experience actually happened : Explain how the negotiation experience actually happened and then consider the negotiating techniques

Heritage influencing-religious and political beliefs : Our cultural heritage can have a significant impact on our lives. Our heritage influences our religious and political beliefs, interests and hobbies, and even the food we eat.

Write a trigger for total percentage of all appointments : Write a trigger on Works department to ensure the following requirement; the total percentage of all appointments for an employee must be fewer than 100%.

Why manufacturer guarantees the computer for one year only : Why manufacturer guarantees the computer for one year only. The cost of the extended warranty is $150. Analyze this proposition using the concepts you learned in the module on risk analysis.

Federal role in regulating nfps : Show your views on whether or not the federal government should play a much larger role in regulating nonprofits and especially how nonprofits identify donors, collect funds, and spend fundraising dollars.

Important multiple choice questions : Owen is a holder of a promissory note obtain from Purchase Money Corporation Regarding the defenses against payment of the note to which Purchase Money is subject,

What is the work done on the gas : An antelope moving with constant acceleration covers the distance 77 m between two points in time 7.4 s. Its speed as it passes the second point is 15.5 m/s. What is its speed at first point.

User Account

All Pages