questionrequire to create a database for music


Question

Require to create a database for music. These are entities that I will use for music database, with their own 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 plan have to include an ER diagram, a set of relational schemas, and a list of constraints, including primary-key and foreign-key constraints (it won't be mentioned in software, database design will be expressed in terms of a relational database design, it will consist only diagram, mentioned schemas in question and constraints.)

 

Request for Solution File

Ask an Expert for Answer!!
Computer Engineering: questionrequire to create a database for music
Reference No:- TGS0443914

Expected delivery within 24 Hours