Musica Case Study Musica is a store owned by Fringe Dweller. Ms Dweller is intending to to set up a Website that will sell streaming music. She wants you to begin the task of building a database that will support her site. Eventually, the database will need to keep track of downloads and payments, but at this early stage of development the tracking part of the system is being ignored. For now, Ms Dweller would simply like you to build a database that stores details about all the songs in her collection.

This is what you know:

• The database will store information about songs and artists

• The owner has instructed you to keep track of 2 types of artists for each song - singers and writers.

• You have noted that you will need to account for these facts: o Some songs are sung by duets or a larger collection of singers o A song can be written by more than one person o Different versions of the same song can appear over the years. Ms Dweller calls each version a "release".

• Ms Dweller said it's important to store information about each release's Recording Label too. The Label is often the copyright owner and the song distributor. At this stage, you will store the Label's name and contact details and will keep track of all songs in your database that it has released

• Ms Dweller wants to keep track of each artist's name, date of birth, gender, and nationality. She wants it to be possible to search for details about each release's title, writer(s), singer(s), length, release date, and Label. ITDA1001 - Database Fundamentals Copyright © 2018 VIT, All Rights Reserved. VIT and its logo are trademarks of Victorian Institute of Technolog 2 Task 1 1. Create an MS Word document named "Your Name - Your Student Number - Musica.docx" 2. Create an ER Diagram from the above scenario, being sure to: a) Use Crow's Foot Notation b) Mark cardinality, existence, primary keys (with an underline), and foreign keys (with the letters "FK" in brackets). c) Ensure the entites are in a normalised state d) Write any assumptions you make if you think it important to clarify the reasons for building particular relationships, creating particular attributes, or leaving something out. e) Place your name and student number within the drawing f) Insert that ER Diagram into your Word document. If you use LucidChart or similar you could take a screenshot.