(a) Identify entity types and their attributes, including the primary keys. (20 Marks) (b) Compile the E-R of the system in third normal form. (state all assumptions that you have made) (10 Marks)...

(a) Identify entity types and their attributes, including the primary keys. (20 Marks) (b) Compile the E-R of the system in third normal form. (state all assumptions that you have made) (10 Marks) Note: If you make any assumptions, they should be explained clearly. Submit your list of entities and their attributes, including the primary keys, your E-R diagram and all assumptions you have made