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

Question

Hillar Furniture Enterprise is a furniture store owned by Dr. Hillar Addo of AIT.

The following table shows the essential data required for this application.

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. Identify the functional dependencies for this data. You may assume the following

• 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

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