DRAW IT PLS$.$ Assignment $5\mathrm{.}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.