Answer to Question #228549 in Databases | SQL | Oracle | MS Access for Teddy

Question

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. 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.). b. Convert your data into a set of 3NF relations, identifying all the primary and foreign keys

Answer 1

The fuctional dependances are:

  1. Material_ID and Material_ Name

  2. Vendor_ID and Vendor_name




Table 1

Material_ID 3792

Material_ Name Hinges 3” locking

Unit_of_Measure Each

Standard_Cost GHC 5.00




Table 1

Vendor_ID V300

Vendor_name Apex Hardware

Unit_price GHC 4.75

Terms_Code 1

Terms COD