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 ProductAddressOrderOrderCustomerCustomerProductGrossDollarNetQuantity PriceDescription1 Smart St 94012 7 Up1 Smart St 95410 Ice Coffee1 Smart St 95940 |FantaAmount 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.00NoDateNoNameNo1/03/2224690Vincent PangVincent PangVincent Pang24690 Vincent Pang24692 Alex LimAlex Lim24694 Dylan Duan24694 Dylan Duan39500395001/03/22246902$ 9.00395001/03/222469041 Smart St 95950 Chocolate2 Smart St 94013 |Lipton Ice2 Smart St 96722 Coca-Cola3 Smart St 95410 Ice Coffee3 Smart St 95950 Chocolate24696 Matthew Perry 4 Smart St 94013 Lipton Ice24696 Matthew Perry 4 Smart St 96722 Coca-Cola5 Smart St 94013 Lipton Ice6 Smart St 94013 |Lipton Ice6 Smart St 95410 Ice Coffee$ 25.00$ 16.50$ 47.50$ 9.00$ 15.00$ 11.00$ 19.00$ 5.50395001/03/225395061/03/223395061/03/22246925395122/03/2239512 2/03/2239516 2/03/2232395173/03/2224697 Larry Stalis24698 Lucy Sun24698 Lucy Sun39518 4/03/221$ 5.50$ 9.00395194/03/221395194/03/222

One table should be order table(order no,order date,customer no), Customer table(Customer no,…

Answered: Using the above table structure, create…

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