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

  • Overview: You will be writing classes that implement a playlist simulation for a music streaming app.The...

    Overview: You will be writing classes that implement a playlist simulation for a music streaming app.The Playlist class will contain a dynamic array of Song objects, and the Song class contains several pieces of information about a song. You will need to: 1) Finish the writing of two classes: Song and Playlist. The full header file for the Song class has been provided in a file called Song.h. 2) Write a main program (filename menu.cpp) that creates a single Playlist...

  • 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,...

  • a. Suppose that a model of a music library does not model ‘artist’ as an entity...

    a. Suppose that a model of a music library does not model ‘artist’ as an entity set, but instead models it as an attribute of a track. This could lead to what the authors of our text call ‘incompleteness’. Why would the they call this model incomplete? Is it because a) not all artist information could be contained as an attribute of a track, b) it would not be possible to model an artist before that artist released any tracks,...

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