ER Diagram - Database
posted by Mike
An online retailer, S record, which sells physical music albums, plans to implement a DBMS to enhance its data management practice and ultimately advance business operations. The requirements collection
and analysis phase of the database design process has provided the following data requirements:
Each album has a unique album ID and the following attributes: album title, label company, album price, stock, release date, and genre. A music album belongs to at least one or more genres. Each genre has a
name and description. An album can be made by an artist or a group of artists. Each artist has a unique artist ID, and they can release multiple albums. Data held on each artist includes artist name and debut
date. The company is also interested in tracking news and magazine articles about the artists. Each article is recorded with attributes such as article ID, date, title, source, and URL. An article has to refer to at least one or more artists.
Each customer must sign up as a member to purchase albums. The membership information includes
name, customer ID, password, address, phone number, birthday, occupation, the default payment method, registration date, and e-mail address. Customers can purchase one or more albums and multiple quantities
for each album. Each order is identified by an order ID. In addition, orders are described by order date, total price, payment method, discount (promotions), and delivery option.
Q1. Draw an ER diagram for the requirements (Explain additional assumptions for your diagram