Problem Statement 1

An online music platform, S record, is planning to implement a database to enhance its data management practice and ultimately advance its business operations. The initial planning analysis phases have revealed the following system requirements: Each album has a unique Album ID as well as the following attributes: Album Title, Album Price, and Release Date. An album contains at least one song or more songs. Songs are identified by Song ID. Each song can be contained in more than one album or not contained in any of them at all and has a Song Title and Play Time. Each song belongs to at least one genre or multiple genres. Songs are written by at least an artist or multiple artists. Each artist has a unique Artist ID, and an artist writes at least one song or multiple songs, to be recorded in the database. Data held by each artist includes Artist Name and Debut Date. Each customer must sign up as a member to make a purchase on the platform. The customer membership information includes Customer ID, Customer Name, Address (consisting of City, State, Postal Code), Phone Number, Birthday, Registration Date. Customers place orders to purchase at least one album or more albums. They can purchase multiple quantities of the same album, which should be recorded as Quantities Ordered. Each order is identified by an Order ID and has Order Date, Total Price, Payment Method, and Delivery Option. Q1. Draw an ER diagram for Statement 1 (You can add notes to your diagram to explain additional assumptions, if necessary). File format: asgmt1_q1_ lastname_firstname.pdf Problem

Statement 2

To capture growing online demands, S record has decided to lunch an online music streaming service. Using the streaming service, customers can listen to individual songs, rather than an entire album. Customers now can choose either to buy a physical album(s) (physical order) or subscribe to a plan which grants unlimited access to all songs (digital order). Every order is either a physical order or digital order, and cannot be both. Both types of order share most of the order attributes, except that only physical orders have Delivery Option, and only digital orders have Subscription Option. For digital order, it is important to track play history Play Date and Play Count. In other words, the company should be able to track how many times song A has been played on date B under order C. Q2. Update your ER diagram from Q1 to reflect the new features (You can add notes to your diagram to explain additional assumptions, if necessary). File format: asgmt1_q2_ lastname_firstname.pdf