Assignment 2 is to convert the conceptual data models to the relational models. As covered in the lectures, the relational models consist of relations (tables), and the associations among the relations are represented with their key fields (primary and foreign keys). In this assignment, you need to develop relational models from the ER diagram attached below, which was the answer to Q2 of Assignment 1. For the grading purpose, you must use the TEXT notation, not the graphical notation. In the text notation, a table name is followed by attribute names in parentheses, primary keys are underlined, and foreign keys are dashed-underlined. An example of the ARTIST entity in the ER diagram would be ARTIST (Artist ID, Artist Name, Debut Date).

CUSTOMER ORDER Customer ID Customer Name Address (City, State, Postal Code) Phone Number Birthday Registration Date Order ID Order Date Payment Method Total Pricel Order Type Places ARTIST DIGITAL ORDER PHYSICAL ORDER Artist ID Artist Name Debut Date Subscription Option Delivery Option WRITES PLAY HISTORY Order Line Play Date Quantities Ordered Play Count ALBUM BELONGS TC SONG Album ID Album Title Album Price Release Date Contains Song ID Song Title Play Time GENRE Genre ID Genre Name