Question: 3) Draw a conceptual ER diagram for the below case of electronic shop website. The ER diagram should show the entities (strong, associative, and weak

3) Draw a conceptual ER diagram for the below
3) Draw a conceptual ER diagram for the below case of electronic shop website. The ER diagram should show the entities (strong, associative, and weak entities when applicable), their attributes, the primary key for each entity, the relationships between entities, and cardinalities (minimum and maximum). (70 points) An electronic shop has a website for selling online electronic products. The website consists of different web pages to represent the different categories of electronic products. Each page can be described by its unique URL address and by additional information such as page description. Each page may contain a list of several products, where a product cannot be listed in different web pages of the website. Each product has its own unique Product code and other features like name, quantity, and Unit Price. Customers normally need to visit the website's pages to view the listed products before making the order. Customers may or may not place orders at any time. On the other hand, an order is placed by one customer only. Each order has a unique order number. It has also other information like order date. An order may have up to twenty-five products, where a product can be listed in different orders. Relevant customer information includes customer_id, Full Name: First_Name, Last Name, address, email, and phone number. The website allows each customer to provide up to three phone numbers. Moreover, one order can have multiple transactions since customers may add products, change the quantity of products, or even return products after purchase, if they want to. Relevant transaction information includes transaction's type and date

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!