Answer to Question #227543 in Databases | SQL | Oracle | MS Access for Ernest

Question

Question 4

a.

Attribute Name

Material_ID

Material_ Name

Unit_of_Measure

Standard_Cost

Vendor_ID

Vendor_name

Unit_price

Terms_Code

Terms

Sample Value

3792

Hinges 3” locking

Each

GHC 5.00

V300

Apex Hardware

GHC 4.75

1

COD

a. Identify the functional dependencies for this data. You may assume the

following:6

· Each material has one or more suppliers. Each supplier may have supply

one or more items or may not supply any items.

· The unit price for a material may vary from one vendor to another

· The terms of a code for a supplier uniquely identifies the terms of a sale

(e.g. code 2 means 10% net 30 days, etc.). The terms for a supplier are the

same for all material items ordered from that supplier.

b. Convert your data into a set of 3NF relations, identifying all the primary and

foreign keys 

Answer 1

Dear Ernest, your question requires a lot of work, which neither of our experts is ready to perform for free. We advise you to convert it to a fully qualified order and we will try to help you. Please click the link below to proceed: Submit order