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

  1. PsyDAG

    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.

  2. Mou


Respond to this Question

First Name

Your Answer

Similar Questions

  1. IT Information Systems Technology

    Why are database management systems important in the business community?
  2. Buiness

    The Excel file contains a WBS for a proposal to implement a PMO. Convert the WBS into a project plan. WBS for PMO Quick Start-Up Effort and Schedule (Estimates and Actual) Tasks to be Performed Actual Hours Estimated Hours Actual (Week-wise) …
  3. systems analysis design

    Task: Draw an ERD that shows cardinality relationships among the entities. When you create your ERD, you'll need to consider the training courses, trainers, corporate clients, students, test results, class schedules, and probably a …
  4. Database Decision

    When deciding whether to store data in a database or in a spreadsheet, what are some of the questions you should consider?
  5. computers

    Derive what you believe is the underlying structure of either iTunes or the Walden University Library database. Sketch the result as an ER diagram. Alternate: Identify at least three difficulties that a DBMS overcomes for the business …
  6. Database application

    Define database elements: field, record, table
  7. databases

    Fernando Cilebra has always ben facinated by skateboards. Fernando has won several contests, both locally and nationally. His interest in skateboards led him to open Fernando's Shop in Denton, Maine. Fernando sells street, trick, and …
  8. Educational Technology and Online Learning

    The field names in a database are also known as_____?
  9. Business Management

    What kinds of queries would be useful to Woodcraft, assuming that it wants to improve its sales, relationship with its customers, or other aspects of its business?
  10. Educational Technology and Online Learning

    If any of you are from Connections Academy, I would love your help :) 1: All of this information is part of a ___ in a database. (1 point) A: Record*** B: row C: column D: field 2: What other information do you need to add to complete …

More Similar Questions