Question: DRAW IT PLS . Assignment 5 . 1 ( 5 0 marks ) Design an ER diagram for an e - commerce platform. Your ER

DRAW IT PLS. Assignment 5.1(50 marks)
Design an ER diagram for an e-commerce platform. Your ER diagram has to model the following requirements:
- Sellers have an sid (as key) and a name. Sellers sell products at a certain price.
- Products have a pid (as key), and a type. A product is either a music album or a book.
- Products of type music album have a name, genre, tracks, and are produced by an artist. Tracks have a name.
- Products of type book have name, and a release date.
- Artists have an aid (as key) and a name.
- Orders have an oid (as key), a customer, a date, a credit card number and contain one or more order-items.
- Order-items consist of a product, a seller, and a quantity.
- Customers have a cid (as key), name and address.
Follow the design principles, i.e. faithfulness, avoiding redundancy, simplicity, and formulating constraints as far as possible.
DRAW IT PLS . Assignment 5 . 1 ( 5 0 marks )

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 Programming Questions!