Using the above table structure, create a normalized Entity-Relationship Model (ERM). Identify Primary Key(s) and Foreign Key(s) for all the entities, connectivities and/or cardinalities, and relationships between the entities. As for Chen's ERM notation and the normalization, the level should be in Third Normal Form (3NF) and above. [Note: you do notneed to show the normalization process such as the functional dependency diagram.]
Using the above table structure, create a normalized Entity-Relationship Model (ERM). Identify Primary Key(s) and Foreign Key(s) for all the entities, connectivities and/or cardinalities, and relationships between the entities. As for Chen's ERM notation and the normalization, the level should be in Third Normal Form (3NF) and above. [Note: you do notneed to show the normalization process such as the functional dependency diagram.]
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...
Related questions
Question
- Using the above table structure, create a normalized Entity-Relationship Model (ERM). Identify Primary Key(s) and Foreign Key(s) for all the entities, connectivities and/or cardinalities, and relationships between the entities. As for Chen's ERM notation and the normalization, the level should be in Third Normal Form (3NF) and above. [Note: you do notneed to show the normalization process such as the functional dependency diagram.]
![A sample report:
Delivery Product
Address
Order
Order
Customer
Customer
Product
Gross
Dollar
Net
Quantity Price
Description
1 Smart St 94012 7 Up
1 Smart St 95410 Ice Coffee
1 Smart St 95940 |Fanta
Amount Discount Amount
$ 9.95 $ 49.75 $ 5.00 $ 44.75
$ 4.50 $ 9.00
$ 8.00 $ 32.00 $ 4.00 $ 28.00
$ 5.00 $ 25.00
$ 5.50 $ 16.50
$ 9.50 $ 47.50
$ 4.50 $ 9.00
$ 5.00 $ 15.00
$ 5.50 $ 11.00
$ 9.50 $ 19.00
$ 5.50 $ 5.50
$ 5.50 $ 5.50
$ 4.50 $ 9.00
No
Date
No
Name
No
1/03/22
24690
Vincent Pang
Vincent Pang
Vincent Pang
24690 Vincent Pang
24692 Alex Lim
Alex Lim
24694 Dylan Duan
24694 Dylan Duan
39500
39500
1/03/22
24690
2
$ 9.00
39500
1/03/22
24690
4
1 Smart St 95950 Chocolate
2 Smart St 94013 |Lipton Ice
2 Smart St 96722 Coca-Cola
3 Smart St 95410 Ice Coffee
3 Smart St 95950 Chocolate
24696 Matthew Perry 4 Smart St 94013 Lipton Ice
24696 Matthew Perry 4 Smart St 96722 Coca-Cola
5 Smart St 94013 Lipton Ice
6 Smart St 94013 |Lipton Ice
6 Smart St 95410 Ice Coffee
$ 25.00
$ 16.50
$ 47.50
$ 9.00
$ 15.00
$ 11.00
$ 19.00
$ 5.50
39500
1/03/22
5
39506
1/03/22
3
39506
1/03/22
24692
5
39512
2/03/22
39512 2/03/22
39516 2/03/22
3
2
39517
3/03/22
24697 Larry Stalis
24698 Lucy Sun
24698 Lucy Sun
39518 4/03/22
1
$ 5.50
$ 9.00
39519
4/03/22
1
39519
4/03/22
2](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fd96f75d9-9b4e-46bc-96c5-891d1c9cb354%2Ff5fe0a26-ecc3-4bda-848a-b9d5d98f8ef2%2F012dtmm_processed.png&w=3840&q=75)
Transcribed Image Text:A sample report:
Delivery Product
Address
Order
Order
Customer
Customer
Product
Gross
Dollar
Net
Quantity Price
Description
1 Smart St 94012 7 Up
1 Smart St 95410 Ice Coffee
1 Smart St 95940 |Fanta
Amount Discount Amount
$ 9.95 $ 49.75 $ 5.00 $ 44.75
$ 4.50 $ 9.00
$ 8.00 $ 32.00 $ 4.00 $ 28.00
$ 5.00 $ 25.00
$ 5.50 $ 16.50
$ 9.50 $ 47.50
$ 4.50 $ 9.00
$ 5.00 $ 15.00
$ 5.50 $ 11.00
$ 9.50 $ 19.00
$ 5.50 $ 5.50
$ 5.50 $ 5.50
$ 4.50 $ 9.00
No
Date
No
Name
No
1/03/22
24690
Vincent Pang
Vincent Pang
Vincent Pang
24690 Vincent Pang
24692 Alex Lim
Alex Lim
24694 Dylan Duan
24694 Dylan Duan
39500
39500
1/03/22
24690
2
$ 9.00
39500
1/03/22
24690
4
1 Smart St 95950 Chocolate
2 Smart St 94013 |Lipton Ice
2 Smart St 96722 Coca-Cola
3 Smart St 95410 Ice Coffee
3 Smart St 95950 Chocolate
24696 Matthew Perry 4 Smart St 94013 Lipton Ice
24696 Matthew Perry 4 Smart St 96722 Coca-Cola
5 Smart St 94013 Lipton Ice
6 Smart St 94013 |Lipton Ice
6 Smart St 95410 Ice Coffee
$ 25.00
$ 16.50
$ 47.50
$ 9.00
$ 15.00
$ 11.00
$ 19.00
$ 5.50
39500
1/03/22
5
39506
1/03/22
3
39506
1/03/22
24692
5
39512
2/03/22
39512 2/03/22
39516 2/03/22
3
2
39517
3/03/22
24697 Larry Stalis
24698 Lucy Sun
24698 Lucy Sun
39518 4/03/22
1
$ 5.50
$ 9.00
39519
4/03/22
1
39519
4/03/22
2
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
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…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
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)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
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…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
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)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
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](https://www.bartleby.com/isbn_cover_images/9781337093422/9781337093422_smallCoverImage.gif)
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
![Prelude to Programming](https://www.bartleby.com/isbn_cover_images/9780133750423/9780133750423_smallCoverImage.jpg)
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
![Sc Business Data Communications and Networking, T…](https://www.bartleby.com/isbn_cover_images/9781119368830/9781119368830_smallCoverImage.gif)
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY