CS 486/586 Introduction to DBMS Spring 2022 Assignment 4 – ER Diagram (All Answers are Correct)

Document Content and Description Below

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: ● En... couraged 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]

Last updated: 1 year ago

Preview 1 out of 6 pages