Pine Valley Furniture Company Purchasing Data Attribute Name Sample Value Material ID 3792 Material Name Hinges 3" locking Unit of Measure each Standard Cost $5.00 Vendor ID V300 Vendor Name Apex Hardware Unit Price $4.75 Terms Code 1 Terms COD

Systems Architecture
7th Edition
ISBN:9781305080195
Author:Stephen D. Burd
Publisher:Stephen D. Burd
Chapter10: Application Development
Section: Chapter Questions
Problem 14VE
icon
Related questions
Question

Decompose this diagram into a set of diagrams in 3NF.

Pine Valley Furniture Company Purchasing Data
Attribute Name
Sample Value
Material ID
3792
Material Name
Hinges 3" locking
Unit of Measure
each
Standard Cost
$5.00
Vendor ID
V300
Vendor Name
Apex Hardware
Unit Price
$4.75
Terms Code
1
Terms
COD
Transcribed Image Text:Pine Valley Furniture Company Purchasing Data Attribute Name Sample Value Material ID 3792 Material Name Hinges 3" locking Unit of Measure each Standard Cost $5.00 Vendor ID V300 Vendor Name Apex Hardware Unit Price $4.75 Terms Code 1 Terms COD
Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Requirement Analysis
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Systems Architecture
Systems Architecture
Computer Science
ISBN:
9781305080195
Author:
Stephen D. Burd
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage