$7$: E$-$commerce Marketplace

Create an ERM diagram for an e$-$commerce marketplace. Entities should include products, sellers,

buyers, orders, and reviews. Products have attributes like product ID and description. Sellers have

attributes like seller ID and name. Buyers have attributes like buyer ID and username. Orders should

include order ID and date. Use multivalued attributes to represent product ratings. Show the

relationship between sellers and the products they offer.

$8$: Flight Reservation System

Design an ERM diagram for a flight reservation system. Entities should include flights, passengers, seats,

and airlines. Flights have attributes like flight number and departure$/$arrival times. Passengers have

attributes like passenger ID and name. Seats should include seat number and class $($economy$,$ business,

etc.$).$ Use derived attributes to calculate the total number of seats on a flight. Show how passengers are

associated with their booked seats.

$9$: Music Streaming Service

Create an ERM diagram for a music streaming service. Entities should include users, playlists, songs, and

artists. Users have attributes like username and email. Playlists have attributes like playlist ID and title.

Songs should include song ID and title. Artists have attributes like name and genre. Use composite

attributes to represent user addresses. Show how users can create multiple playlists and add multiple

songs to their playlists.

Can you help me with the ERM diagram