Need to create a database for music


Need to create a database for music. These are the entities that I will use for the music database, with their respective attributes. Label - Attributes will be Name and Decades, Genre - Attributes will be Name and Summary, Style - Attributes will be Name and Summary, Album - Attributes will be Release Date, Id, Title, Duration, Rating, User's Review, Tones and Type. Other entities will be Artist/Group - Attributes will be Name, Year Founded, Origin, Tones and Biography, Track - Attributes will be Number and User's Recommendation and finally Song - Attributes will be Name, ID and Debut Date.

Your design should include an ER diagram, a set of relational schemas, and a list of constraints, including primary-key and foreign-key constraints.
(it wont be mentioned in software, the database design will be expressed in terms of a relational database design, it will consist only diagram, mentioned schemas in the question and constraints.)

Request for Solution File

Ask an Expert for Answer!!
Basic Computer Science: Need to create a database for music
Reference No:- TGS087449

Expected delivery within 24 Hours