(a) Identify the primary key of the below dependency diagram. What is the name given to this type of primary key?
(b) What type of dependency is D-->E and A-->B,C?
(c) Can (A,D,G) determine F in the above diagram? Justify your answer.
(d) Name two key attributes other than "A".
(e) Normalise the above dependency table to 3rd normal form. You must show the progress from 1NF to 2NF, and then to 3NF. Indicate all the primary keys and foreign keys in the normalised tables.
(f) Write the DDL to create the final 3NF tables. For primary keys use 'Integer' data type, and for non-key attributes use 'Text' data type. Use TABLE1, TABLE2, and TABLE3 etc. for the table name.