Figure 1 COMPANY relational database schema
Suppose each of the following update operations is applied directly to the COMPANY relational
database schema. Discuss all integrity constraints violated by each operation, if any, and the different
ways of enforcing these constraints:
Insert < 'Flora', 7, 'Taipei', '3'> into PROJECT
Insert < 'Marketing', null, '333666999', '1988-06-30' > into DEPARTMENT
Insert <'Eason', 'E', 'Chan', '777777777', '1974-07-27', '220 New Taipei, TW', M, 53000, '888665555',
1> into EMPLOYEE.
Delete the DEPENDENT tuple with ESSN= '987654321'.
Modify the SALARY attribute of the EMPLOYEE tuple with SSN= ‘123456789' to ‘50000’
Consider the relation
Find out the attributes that can be candidate keys with related assumptions you defined.