How to create a database for music

Assignment Help Computer Engineering

Reference no: EM132347

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.)

Reference no: EM132347

Questions Cloud

The ways to depict constraint graph : The ways to depict constraint graph? illustrate how splitting a domain can be used to solve this problem.

Prepare a compelling argument to convince companys partner : Prepare a compelling argument to convince a company's partners

How to classify emerging technologies : How to classify emerging technologies Inscribe obviously and succinctly about information management systems using proper writing mechanics.

Determine the operating income for the olive oil division : Determine the operating income for the olive oil division using your recommendation.

How to create a database for music : How to create a database for music? 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, ..

Evaluate the average markup percentage for setting prices : Evaluate the average markup percentage for setting prices as a percentage of the full cost of the product.

Write program that generates casual number between 1 and 100 : Write program that generates casual number between 1 and 100?

How would you go about measuring the level of radiation : What do you understand by the term external and internal radiation? List down the health effects associated with each of them How would you go about measuring the level of radiation

How to write a program to find a traffic violation number : How to write a program to find a traffic violation number?

User Account

All Pages