Create trigger on update of chairid that enforces

Assignment Help Database Management System

Reference no: EM132087290

Do only in Oracle SQL.

Make sure to test code before submitting.

Create two tables:

Employee: empID (PK), empFname, empLname, deptID(FK) and

Department: deptID(PK), deptName, chairID

chairID is empID from Employee table

Insert at least 3 rows in the Department table and at least 6 rows in the Employee table.

Create trigger on update of chairID that enforces the following business rules

One employee can chair no more than one department.

Each department has exactly one chair.

Reference no: EM132087290

Questions Cloud

Established with an equilibrium constant value : 1) Among the following equilibrium expressions for the dissolution of calcium fluoride (CaF2) in water... the correct expression is?

The concept of the time value of money : Most techniques used to determine economic feasibility encompass the concept of the time value of money (TVM) and break-even analysis (BEA).

Calculate the rate constant k : In a university laboratory experiment the rate of disappearance of ozone (O3) was measured to be 9 x 10-3 M/s. Simultaneously, the concentration of ozone

List the isbn and title of books published by the publisher : Display the title and publisher of the most expensive book based on the retail price.

Create trigger on update of chairid that enforces : Create trigger on update of chairID that enforces the following business rules One employee can chair no more than one department.

Causes the rate of formation of a : Tripling the initial concentration of X causes the rate of formation of A to be increased by a factor of 9.

Design the appropriate er-schema diagram : Design the appropriate ER-schema diagram for the given data requirements Specify all key attributes and all structural constraints.

Calculate the amount concentration of the original silver : Based on your observations, what substance is the excess reagent? Identify the evidence that supports this.

Determine the unknown voltages for each circuit : Determine the unknown voltages for each circuit - calculate the voltage gain for each stage and the overall voltage gain. Assume the op-amps to be ideal

User Account

All Pages