Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
Note: (1) The ERD must have Customer (Customer ID as the PK), Manufacturer (Manufacturer Name as the PK), Sales Order, Product and many other entities. (2) Assume that there is only one customer and one sales manager for each order. (3) No need to create a Recipient entity; recipient information must be attributes of SalesOrder. (4) The database must include unit price change history of products. (Hint: a ProductPrice entity to record all prices of products) The ERD must include not only entities and relationships with cardinalities but also all attributes. Underline the primary key. There must be no many-to-many relationships and no multi-valued attributes. Enter all foreign keys in the ERD. Download Attachments

Note: (1) The ERD must have Customer (Customer ID as the PK), Manufacturer (Manufacturer Name as the PK), Sales Order, Product and many other entities. (2) Assume that there is only one customer and one sales manager for each order. (3) No need to create a Recipient entity; recipient information must be attributes of SalesOrder. (4) The database must include unit price change history of products. (Hint: a ProductPrice entity to record all prices of products) The ERD must include not only entities and relationships with cardinalities but also all attributes. Underline the primary key. There must be no many-to-many relationships and no multi-valued attributes. Enter all foreign keys in the ERD. Download Attachments

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

The following figure shows a shipping ticket sent to a customer. Draw an ERD reflecting the data contained in the shipping ticket.

Note: (1) The ERD must have Customer (Customer ID as the PK), Manufacturer (Manufacturer Name as the PK), SalesOrder, Product and many other entities. (2) Assume that there is only one customer and one sales manager for each order. (3) No need to create a Recipient entity; recipient information must be attributes of SalesOrder. (4) The database must include unit price change history of products. (Hint: a ProductPrice entity to record all prices of products) The ERD must include not only entities and relationships with cardinalities but also all attributes. Underline the primary key. There must be no many-to-many relationships and no multi-valued attributes. Enter all foreign keys in the ERD. Download Attachments
Transcribed Image Text:Note: (1) The ERD must have Customer (Customer ID as the PK), Manufacturer (Manufacturer Name as the PK), SalesOrder, Product and many other entities. (2) Assume that there is only one customer and one sales manager for each order. (3) No need to create a Recipient entity; recipient information must be attributes of SalesOrder. (4) The database must include unit price change history of products. (Hint: a ProductPrice entity to record all prices of products) The ERD must include not only entities and relationships with cardinalities but also all attributes. Underline the primary key. There must be no many-to-many relationships and no multi-valued attributes. Enter all foreign keys in the ERD. Download Attachments
Sold to: Customer Name: Customer Street Address: Customer City, State, Zip: Customer Phone Number: Customer ID: T&TA Telecommunications Direct Shipping Ticket Shipped to: Recipient Name: Shipping Street Address: Shipping City, State, Zip: Recipient's Phone Number: SS8723 HC0762 HC07C1 Order ID: Sales Manager: Peter Peterson Product No Manufacturer Description 2012F0899 S-Sung H-C H-C John Johnson 1234 Longview Ct. Richardson, TX 75000 972-000-1234 2011C07 Tom Thompson 4321 Shortview St. Garland, TX 75200 214-999-4321 Order Date: Shipping Date: Sales Manager ID: Galaxy 3 Android Phone EOV LTE Phone Bluetooth Headset for EOV Family Feb. 12, 2013 Feb. 14, 2013 2010SM12 Unit Price $299.95 $249.95 $25.99 Total: $575.88 Quantity 1 1 2
Transcribed Image Text:Sold to: Customer Name: Customer Street Address: Customer City, State, Zip: Customer Phone Number: Customer ID: T&TA Telecommunications Direct Shipping Ticket Shipped to: Recipient Name: Shipping Street Address: Shipping City, State, Zip: Recipient's Phone Number: SS8723 HC0762 HC07C1 Order ID: Sales Manager: Peter Peterson Product No Manufacturer Description 2012F0899 S-Sung H-C H-C John Johnson 1234 Longview Ct. Richardson, TX 75000 972-000-1234 2011C07 Tom Thompson 4321 Shortview St. Garland, TX 75200 214-999-4321 Order Date: Shipping Date: Sales Manager ID: Galaxy 3 Android Phone EOV LTE Phone Bluetooth Headset for EOV Family Feb. 12, 2013 Feb. 14, 2013 2010SM12 Unit Price $299.95 $249.95 $25.99 Total: $575.88 Quantity 1 1 2
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
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