Answered: Draw an ER diagram for online shopping…

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

Related questions

Question

100%

Please this question

$4. Draw an ER diagram for online shopping Database that captures given below requirements. Specify key attribute(s) of each entity set: Assume any relationship among entities, and specify cardinality ratios assuming N: M is a default cardinality. Note..Subject: Database > For PRODUCT entity, the system maintains PID, Product Name, Brand, Type, Price, and CID.The PID has a unique value for each product. > The CATEGORY entity records the product information as a relation: CID, prdtype, company, and Instock. The value for category ID is unique for each product. > The CUSTOMER entity details maintained by the system as Cust_ID, {Name (Fname, MIDname, Lname)}, Address and email. Every customer has a unique ID assigned to it.$

Transcribed Image Text:4. Draw an ER diagram for online shopping Database that captures given below requirements. Specify key attribute(s) of each entity set: Assume any relationship among entities, and specify cardinality ratios assuming N: M is a default cardinality. Note..Subject: Database > For PRODUCT entity, the system maintains PID, Product Name, Brand, Type, Price, and CID.The PID has a unique value for each product. > The CATEGORY entity records the product information as a relation: CID, prdtype, company, and Instock. The value for category ID is unique for each product. > The CUSTOMER entity details maintained by the system as Cust_ID, {Name (Fname, MIDname, Lname)}, Address and email. Every customer has a unique ID assigned to it.

Expert Solution