Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
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 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)     Using the dependency diagram, 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 many 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

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 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)     Using the dependency diagram, 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 many 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

Database Systems: Design, Implementation, & Management
Database Systems: Design, Implementation, & Management
12th Edition
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Carlos Coronel, Steven Morris
Chapter11: Database Performance Tuning And Query Optimization
Section: Chapter Questions
Problem 21P: Problems 1721 are based on the following query: SELECT V_CODE, V_NAME, V_CONTACT, V_STATE FROM...
See similar textbooks
icon
Related questions
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

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)     Using the dependency diagram, identify the functional dependencies for this data. You may assume the following:

 

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

  one or more items or may not supply many items.

  1. 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 

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
SQL Query
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
MIS
MIS
Computer Science
ISBN:
9781337681919
Author:
BIDGOLI
Publisher:
Cengage
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
SEE MORE TEXTBOOKS