Convert the ERD into a relational model. You need to provide the relations in the notation. ALL Primary Keys and Foreign Keys MUST be identified.

 

Order Type is the attribute of the subtype discriminator Having it here is not a must but it helps in the relational model Quantity_Ordered SHIPPED ORDER Shipping Method ALBUM Album ID Alubm_Title Album Price Release Date Contains Assuming that Album_Title is the Primary key is also OK B ORDER Order ID Order Date Payment Method [Total Price] Order Type d Contains SUBSCRIPTION Subscription Type 8 Played by Assuming that customers place one or more orders. will also be a valid solution. ^ SONG Song ID Song Title Play Time Genre ID Genre Name Belongs to GENRE Places K Play Count Play Date +H Written by CUSTOMER Customer ID First Name Last Name Address (City, State, Zip Code) Phone Number Birthdate Registration Date Replacing the attributes on the relationship with associative entities is also a valid solution ARTIST Artist ID Artist Name Debut Date