Question: 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

 Use the following attributes to create tables that meet all of

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!