Exercise 7

A:
Let F consist of the the following eight dependencies

    AB ® C         D ® EG
    C ® A            BE ® C
    BC ® D         CG ® BD
    ACD ® B      CE ® AG

Compute the minimal cover of F.

B:
Exercise 6.9 from the book "Database System Concepts".

C:
Alter the table definitions (the schema) of the Company database (from Exercise 1) to include primary keys, foreign keys, unique constraints, and not null constraints. Implement these changes on the Oracle system.

(Hint. In an Oracle session write SET PAUSE ON <return> HELP ALTER <return>)

Best regards,
Kristian Torp