CS 486/586 Introduction to DBMS
Spring 2022
Assignment 4 – ER Diagram
Due: Friday, April 29, 11:59PM on Canvas
Submitted by: - Parth Parashar and Kirtan Patel
Please note the following:
● Encouraged to do this assi
...
CS 486/586 Introduction to DBMS
Spring 2022
Assignment 4 – ER Diagram
Due: Friday, April 29, 11:59PM on Canvas
Submitted by: - Parth Parashar and Kirtan Patel
Please note the following:
● Encouraged to do this assignment in groups of 2.
● Ensure that each group member’s name is listed on the assignment to ensure
credit
● Submit your assignment in PDF format
● Turn in your completed assignment on Canvas
● 100 points total
Part I - ER Diagrams and ER->Relations (100 pts)
You may use erdplus.com (free version) or LucidChart for completing these exercises.
Notes on erdplus.
● The erdplus GUI sometimes applies the cardinality symbol on the opposite entity
than expected. Enter the data in erdplus so that the resulting diagram is correct.
● Regularly save your diagrams locally as a backup in case the website loses
your account. It happens, I learned the hard way.
In this homework assignment, you're designing the database for an online fan-of-music
database. You won't be building the entire online application, or accounting for all possible
user interactions.
Background
There are many online sources for information about music, but much of the data isn't well
structured, and you often have to go to multiple sites to get answers to your questions
regarding musicians, bands, songs, albums, sales and concerts. When did Aerosmith form?
Look in Wikipedia. When did Roger Waters leave Pink Floyd? Look on a different page on
Wikipedia. What songs are on Drake's album "Take Care"? Another page in Wikipedia, or
Amazon, or iTunes. How many certified album sales does Beyonce have in the US? Yet
another page in Wikipedia, or RIAA. When is Alicia Keys next giving a concert in Oregon or
Washington? (September 1st at the Moda…)
[Show More]