ZuoTi.Pro
Question

Problem Statement An online music platform, S record, is planning to implement a database to enhance...

Problem Statement

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

engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

If you have any problem with the diagram feel free to comment, I will make the necessary changes.

ER Diagram

0 0
Add a comment
Know the answer?
Add Answer to:
Problem Statement An online music platform, S record, is planning to implement a database to enhance...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • 4. Consider the following schema for an online streaming service, where users are allowed to play...

    4. Consider the following schema for an online streaming service, where users are allowed to play (stream) songs performed by different artists. Primary and foreign key constraints are also listed for the schema of each table. User (ID, Password, Name, Location) Primary key = ID Artist (ID, Name, Birthyear) Primary key = ID Song (ID, Title, Album, ArtistID) Primary key = ID Song(ArtistID) references Artist(ID) Play (ID, UserID, SongID, Timestamp) Primary key = ID Play(UserID) references User(ID) Play(SongID) references Song(ID)...

  • Many of us have large digital music collections that are not always very well organized. It...

    Many of us have large digital music collections that are not always very well organized. It would be nice to have a program that would manipulate our music collection based on attributes such as artist, album title, song title, genre, song length, number times played, and rating. For this assignment you will write a basic digital music manager (DMM). Your DMM program must have a text-based interface which allows the user to select from a main menu of options including:...

  • Entity relationship diagram (ERD) question: An online food delivery company hires you to design a small...

    Entity relationship diagram (ERD) question: An online food delivery company hires you to design a small database to store information about the online orders. You’re given the following requirements: ⚫ A customer is uniquely identified by his/her email. For each customer, we also record his/her name, phone number and address. The address is composed of suburb and street. ⚫ A rider is uniquely identified by his/her ID. We will keep record of the rider’s age, gender, phone number and available...

  • Platform: ssh server PHP and mySQL database Transaction Input: Transaction Name Transaction Type: Purchase, Income, Tax...

    Platform: ssh server PHP and mySQL database Transaction Input: Transaction Name Transaction Type: Purchase, Income, Tax Payment Overall Amount Number of unit and price for Purchase Beneficiaries:(multiple choice of persons in the family) Database record for each order: All input information as above (multiple choices can be combined into one string and be stored in one field) Transaction id Basic functions on webpage Create a new transaction List all transactions Search Transaction by id Bonus Functions Show the overall balance...

  • Identify the Entities and Attributes and Draw the ER diagram. 1. Consider a mail order database...

    Identify the Entities and Attributes and Draw the ER diagram. 1. Consider a mail order database in which employees take orders for parts from customers. The data requirements are summarized as follows: The mail order company has employees identified by a unique employee number, their first and last names, and a zip code where they are located Customers of the company are uniquely identified by a customer number. In addition, their first and last names and a zip code where...

  • Project Steps: 1. Database Design 1.1. Design and create a database in third normal form based...

    Project Steps: 1. Database Design 1.1. Design and create a database in third normal form based on the following requirements: • Each Job is for a specific customer and there can be more than one job per customer. • The name and address must be tracked for each customer. • Each job is described by up to 2000 characters. • Each job has a status of ‘open, ‘in process’, or ‘complete’. • Each job has a start date and end...

  • First, draw an EER that models the given requirements. You will play with the Bank Database...

    First, draw an EER that models the given requirements. You will play with the Bank Database in this homework. Please download and execute the bank.sql from Canvas to create this database in your MySQL system. Please submit the results as a zip file with a name <yourname>-bank.zip. Consider modeling a bank: . The bank keeps personal information of each customer including name, sex, address, phone number, social security number, and date of birth. . Each customer owns one or more...

  • Design a database through an E/R diagram to store information about a flight mission planning system....

    Design a database through an E/R diagram to store information about a flight mission planning system. The aircrafts in the system have a unique id, model, width, height, maximum velocity and fuel capacity information. The aircrafts may be in two types: cargo plane or fighter. In addition to aircrafts information, cargo planes have extra information named load capacity and fighter planes have bomb capacity. The pilots in the system have name information, which consists of forename and surname. In addition,...

  • this is database course please draw the ER by this way We have been asked to...

    this is database course please draw the ER by this way We have been asked to analyze the data requirements and develop a database system to keep information for equipment hiring companies in the country The aim of this system is to monitor the hiring of equipment to dients. There are many companies in the country, and each company has at least three branches across the country. Where each branch has staff including the branch manager who is responsible for...

  • This is extra information about the shopping database given to answer this question: For many query...

    This is extra information about the shopping database given to answer this question: For many query questions we refer to the following database schema for a website that keeps track of what people like to buy or actually buy in different on-line supermarkets. (Think of something like a cross-store loyalty card system.) customer(cID, cName, street, city) Customers with unique cID and other attributes store(sID, sName, street, city) Stores with a unique ID and other attributes. Stores with the same name...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT