ER Diagram - Database

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
if necessary).

asked by Mike
  1. We do not do your homework for you. Although it might take more effort to do the work on your own, you will profit more from your effort. We will be happy to evaluate your work though.

    Cannot diagram on these posts.

    posted by PsyDAG
  2. yuyutg

    posted by Mou

Respond to this Question

First Name

Your Response

Similar Questions

  1. maths-urgently needed

    A manufacture of furniture sells a sofa set to a retailer for Rs 23000.the retailer, in turn, sells the sofa set to a customer for Rs 29000.find the VAT rate as percent,if the retailer pays Rs 520 as VAT.
  2. maths

    A manufacture of furniture sells a sofa set to a retailer for Rs 23000.the retailer, inturn, sells the sofa set to a customer for Rs 29000.find the VAT rate as percent,if the retailer pays Rs 520 as VAT.
  3. maths

    A manufacture of furniture sells a sofa set to a retailer for Rs 23000.the retailer, inturn, sells the sofa set to a customer for Rs 29000.find the VAT rate as percent,if the retailer pays Rs520 as VAT.
  4. maths

    A manufacture of furniture sells a sofa set to a retailer for Rs 23000.the retailer, inturn, sells the sofa set to a customer for Rs 29000.find the VAT rate as percent,if the retailer pays Rs520 as VAT
  5. music

    for school im making a presentation saying whos sold what kind of music and how many albums. i was wondering has any one ever reached diamond (10 million albums sold) status and if so who? thanks Which two bands have sold the most
  6. algera 1

    lucy makes and sells photo albums her monthly expenses are 600$ plus 2$ for each album she sells. her income for each album sold is 10$ the inequality belowcan be used to find the least number of albums lucy should see so that her
  7. business studies II

    Jojo sells newspapers on a busy street corner near the bank. Identify the type of retailer referred to here. Mention any two characteristics of this retailer.
  8. Computer Tech

    I am doing a powerpoint/photoshop project in my computer tech class about a singer that has recently become famous in the world of music. The artist I am researching is Ariana Grande. When I was looking for her albums I found two:
  9. school

    1) What are four suggested steps to becoming familiar with early music standards? I. Implement the music standards. II. Consult with a music specialist. III. Check to make sure the music standards are satisfied. IV. Read the music
  10. Information Technology Infrastructure.

    Identify at least three difficulties that a DBMS overcomes for the business enterprise. Name two additional problems that are caused by relational DBMS technology. Justify your choices.

More Similar Questions