Customers place orders to purchase at least one album or more albums. The customer membership information includes Customer ID, Customer Name, Address (consisting of City, State, Postal Code), Phone Number, Birthday, Registration Date. Each customer must sign up as a member to make a purchase on the platform. Artists have Artist Name and Debut Date attributes. All artists included in the database must have written at least one song or multiple songs. A song is written by at least one artist or by multiple artists. Also, each song belongs to at least one genre or multiple genres. Songs have Song Title and Play Time attributes. Each song, identified by Song ID, can be contained in more than one album or not contained in any of them at all. An album contains at least one song or more songs. 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 online music retail platform, S record, is planning to implement a database to enhance its data management practice and ultimately advance its business operations.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |