Figure 5.6

Consider again the COMPANY database with the database state as given in Figure 5.6on page 162. For the following update operations, list and explain (1) all constraints that are violated and (2) for each violation suggest ways to enforce the violated constraint. EXAMPLE: Insert into EMPLOYEE; NSWER: This Inser format. We may enforce this constraint by rejecting the Insert operation or automatically converting to appropriate format (if our DBMS is capable of such conversion) a. Insert into DEPARTMENT; b. Insert677678989, ,null, '40. O> into WORKS ON