By using database Trigger, how to answer this question? (given dreamhome tables) ii. Base on the Dreamhome

 By using database Trigger, how to answer this question? (given dreamhome tables)

 

 

Transcribed Image Text:

ii. Base on the Dreamhome database (refer appendix), implement the following data integrity rules: i. A property must be assigned to a staff working at the branch that controls the property. In addition, the property and the branch that controls it must be in the same city. 841Nut new The number of properties assigned to each staff must be maintained at all times. In the event of a assignment or re-distribution of the assignment, the number must be immediately updated for the staff involved. In addition, the number of properties assigned to a staff cannot Afth insut exceed 10 units of property. ii. Base on the Dreamhome database (refer appendix), implement the following data integrity rules: i. A property must be assigned to a staff working at the branch that controls the property. In addition, the property and the branch that controls it must be in the same city. 841Nut new The number of properties assigned to each staff must be maintained at all times. In the event of a assignment or re-distribution of the assignment, the number must be immediately updated for the staff involved. In addition, the number of properties assigned to a staff cannot Afth insut exceed 10 units of property.