Answer to Question #228401 in Databases | SQL | Oracle | MS Access for Enam

Question

QUESTION 2

Hillar Furniture Enterprise is a furniture store owned by Dr. Hillar Addo of AIT. The materials manager of this company maintains a list of suppliers for each of the materials items purchased by the company from outside vendors. The following table shows the essential data required for this application.

Hillar Furniture Company Purchasing Data is shown below:

Attribute Name Sample Value

Material_ID 3792

Material_ Name Hinges 3” locking

Unit_of_Measure Each

Standard_Cost GHC 5.00

Vendor_ID V300

Vendor_name Apex Hardware

Unit_price GHC 4.75

Terms_Code 1

Terms COD

a) Using the dependency diagram, identify the functional dependencies for this data. You may assume the following:

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

one or more items or may not supply many items.

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

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

Answer 1

Dear Enam, 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