Table Normalisation 2 (10 marks)

Use the following attributes to create tables that meet all of the normalisation rules. Note: you do not need to create any new attributes. This is only a portion of a database. The database stores the data for heat pump installations.

Part#, Part Description, Part Quantity on Hand, Part Quantity Used for Each Installation, Installation#, Date of Installation, Address of the Installation, Work Hours of each employee for the Installation, Price Charged for the Installation, Employee#, Employee Name, Employee Contact Number.

Note: each Installation# needs at least two employees, and it is required to record the employees who made the (specific) installation; each Installation# can use multiple parts, and each Part# can be used in multiple Installations.

Required:

Clearly indicate all primary and foreign keys in your tables. Use the following notation:

Tables in ( )

Primary keys Bold

Foreign keys in Italics