Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Survey of Accounting

Authors: Edmonds, old, Mcnair, Tsay

2nd edition

9780077392659, 978-0-07-73417, 77392655, 0-07-734177-5, 73379557, 978-0073379555

More Books

Students also viewed these Accounting questions

Question

5. Give some examples of hidden knowledge.

Answered: 1 week ago