Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
TABLE 4-7 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 Аpех Нardware Unit Price $4.75 Terms Code 1 Terms COD

TABLE 4-7 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 Аpех Нardware Unit Price $4.75 Terms Code 1 Terms COD

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
See similar textbooks
icon
Related questions
Question
100%

The ma terials manager at Pine Valley Furniture Company ma intains a list of suppliers for each of the material
items purchased by the company from outside vendors.
Table 4-7 shows the essential d ata required for this application.
a. Draw a dependency d iagram for this data. You may
assume the following:
• Each material item has one or more suppliers. Each
supplier may supply one or more items or may not
supply any items.
• The unit price for a ma terial item may vary from one
vendor to another.
• The tem1s cod e for a supplier uniquely identifies the
terms of the sale (e.g., code 2 means 10 percent net
30 days). The terms for a supplier are the same for
all ma terial items ordered from that supplier.
b. Decompose this d iagram into a set of d iagrams in 3NF.
c. Draw an E-R d iagram for this situation.

TABLE 4-7 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 Аpех Нardware Unit Price $4.75 Terms Code 1 Terms COD
Transcribed Image Text:TABLE 4-7 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 Аpех Нardware Unit Price $4.75 Terms Code 1 Terms COD
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps with 7 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

JUST THE ONE IN RED PLEASE.

THANK YOU SIR

The materials manager at Tricky Pee Furniture Company maintains a list of suppliers for each of the material items purchased by the company from outside vendors. Table 4-7 shows the essential data required for this application. Tricky Pee Furniture Company 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 a. Draw a dependency diagram for this data. You may assume the following: Each material item has one or more suppliers. Each supplier may supply one or more items or may not supply any items. • The unit price for a material item may vary from one vendor to another. The terms code for a supplier uniquely identifies the terms of the • sale (e.g., code 2 means 10 percent net. b. Decompose this diagram into a set of diagrams in 3NF. c. Draw an ERD diagram of the above situation. d. Create the tables and populate the tables with sample data. [PLEASE I WANT THE ANSWER IN RED ONLY]
Transcribed Image Text:The materials manager at Tricky Pee Furniture Company maintains a list of suppliers for each of the material items purchased by the company from outside vendors. Table 4-7 shows the essential data required for this application. Tricky Pee Furniture Company 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 a. Draw a dependency diagram for this data. You may assume the following: Each material item has one or more suppliers. Each supplier may supply one or more items or may not supply any items. • The unit price for a material item may vary from one vendor to another. The terms code for a supplier uniquely identifies the terms of the • sale (e.g., code 2 means 10 percent net. b. Decompose this diagram into a set of diagrams in 3NF. c. Draw an ERD diagram of the above situation. d. Create the tables and populate the tables with sample data. [PLEASE I WANT THE ANSWER IN RED ONLY]
Solution
Bartleby Expert
SEE SOLUTION
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS