a. Represent the User View as a collection of Tables as given in the example. Determine the Primary key for each table (underline). Eg. Musician(MID:integer, Mname…) (10 Marks) b. Determine the...

a.    Represent the User View as a collection of Tables as given in the example. Determine the Primary key for each table (underline).
Eg. Musician(MID:integer, Mname…)


 (10 Marks)


b.    Determine the relationships between entities.
Eg.  Each musician may play several instruments – relationship is one to many


(5 Marks)




c.    Then normalise the tables.