Create trigger on update of chairid

Assignment Help Computer Engineering

Reference no: EM132174901

Using SQL Developer ONLY!

Lab

Create a lab report file (MS Word compatible) and name it as "IT4153_Lab 5_ Your D2L ID".

a. Create two tables: Employee: empID (PK), empFname, empLname, deptID(FK) and Department: deptID(PK), deptName, chairID chairID is empID from Employee table

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

c. 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.

Note: Check what happens with department when you delete it's chair from the table

Reference no: EM132174901

Questions Cloud

Genetic variation among offspring from a given pair : If no crossing over took place, would the genetic variation among offspring from a given pair of parents be greater for fruit flies or grasshoppers?

Design your own clock : Take the challenge: design your own clock. You are not limited in any way - the hands don't have to move clockwise, or even in a circle.

Compare the current status of ebola and leishmaniasis : Compare the current status of Ebola and Leishmaniasis, and compare them to the disease AIDS.

Research Paper - Description of the emerging issue : The paper could include: The events leading up to the issue and/or any institutional background of the issue. The description of the emerging issue

Create trigger on update of chairid : Insert at least 3 rows in the Department table and at least 6 rows in the Employee table.

Lack of can influence brain development : TOPIC: The Effects of Life Experiences on the Brain - How the experience and the lack of can influence brain development

Choose one of the seven movies listed below : Choose one of the seven movies listed below and watch it. While the cloning processes presented in each of these movies is science fiction

Describe allelic exclusion : Describe allelic exclusion. Describe isotype switching at the gene level

Explain how the process of transcription and translation : Explain how the process of transcription and translation makes proteins from DNA. Use the following terms in your explanation:

User Account

All Pages