The last employee in a department to human resources

Assignment Help Business Management

Reference no: EM13543987

For some reason, I am just having trouble with the concept of triggers, and advice would be greatly appreciated. Use that the relationship between the following tables is M-M, and use the tables as the basis for answering questions 10B.53 through 10B.55. Also assume code is for Oracle 11g version 2.

DEPARTMENT (DepartmentName(PK), BudgetCode, OfficeNumber, Phone)
EMPLOYEE (EmployeeNumber(PK), FirstName, LastName, Department, Phone, Email)

10B.53 Code an Oracle trigger to enforce the constraint that an employee can never change his or her department.

10B.54 Code an Oracle trigger to allow the deletion of a department if it only has one employee. Assign the last employee to the Human Resources department.

10B.55 Design a system of triggers to enforce the M-M relationship. Use Figure 10B-59 as an example, but assume that departments with only one employee can be deleted.
Assign the last employee in a department to Human Resources.

Reference no: EM13543987

Questions Cloud

Find the energy stored in the inductor : A 24-V battery is connected in series with a resistor and an inductor, with R = 4.4 ? and L = 7.6 H, respectively. (a) Find the energy stored in the inductor when the current reaches its maximum value. J (b) Find the energy stored in the inductor one..

Estimate what difference would it make to his balance : A man walking on a tightrope carries a long a pole which has heavy items attached to the two ends. If he were to walk the tight-rope with just a pole, what difference would it make to his balance

Evaluate the ph of the solution prepared by mixing : Calculate the pH of the solution prepared by mixing 10.0mL of 1.00 M acetic acid and 24.0 mL of 1.00 M sodium acetate

A capacitor is constructed with plates of area : A capacitor is constructed with plates of area A and separation s. The area between the plates is ?lled with a weakly ionized gas — a very poor conductive medium with resistivity = 10^8 ohms * cm. The density of the gas is so low that it has no e?e..

The last employee in a department to human resources : For some reason, I am just having trouble with the concept of triggers, and advice would be greatly appreciated. Use that the relationship between the following tables is M-M, and use the tables as the basis for answering questions 10B.53 thro..

A certain substance has a dielectric constant : A certain substance has a dielectric constant of 2.8 and a dielectric strength of 18.0 MV/m. If it is used as the dielectric material in a parallel-plate capacitor, what minimum area should the plates of the capacitor have to obtain a capacitance of ..

Evaluate the work done on the object by the force : An object that is moving rightward is acted upon by the force shown. what is the work done on the object by the force

Explain what is the purpose of adding phosphoric acid : What is the purpose of adding phosphoric acid before titration of the iron (III) with potassium dichromate

A low-voltage device like an electric bell obtains : A low-voltage device like an electric bell obtains its electricity from a 120 V source, but requires only 4–8 V. Thus,it requires a small transformer. This often takes the form of an autotransformer, which has only one winding around a single core..

User Account

All Pages