User Account

All Pages

data dictionary, Database Management System

Assignment Help:
The database is to record information about artists for a (music) production company. An artist is the name of a singer or band; the name of the artist, the year the artist started recording, the number of members of the artist and the genre of music it plays are to be recorded. For example, the artist Queen was formed in 1970, had four members and played rock.
In addition to the information about artists the database will also record information about the members of an artist (referred to as musicians). The (unique) SIN, first name, last name, instrument, and email address of musicians is to be recorded. An artist must be associated with at least one musician, although may be associated with more. Musicians that are not associated with artists will not be maintained in the database; a musician may be associated with more than one artist. The database should also record the share of the revenue that a musician receives from songs recorded by an artist that the musician is associated with. If a musician is associated with more than one artist, they may have different shares from each artist. For example, Ian Gillan might receive 30% of the revenue from songs recorded by Deep Purple, and 80% of the revenue from songs recorded by Gillan.
The following information is to be recorded for songs, the unique ISRC (International Standard Recording Code), the song''s title, its duration, the year that it was recorded and the name of the song''s album. Songs are recorded by artists, an artist can record more than one song, and each song must be recorded by just one artist. Since the database may record artists that are just starting out an artist does not have to have recorded any songs.
Monthly sales of songs will also be recorded. For each month, year, vendor, and country the number of songs sold, and the total sale amount are to be recorded. For example, the song "Further Away" might be sold by iTunes Canada, iTunes UK, and Amazon Canada in September 2017, so would require three sales entries that record the number of songs sold and the total amounts for those vendors and countries in that month. A song may be sold many times (or, sadly, not at all).
The record labels assign each musician associated with an artist a representative (rep). A musician is assigned at most one rep for each artist that they are a part of (and may not be assigned any reps at all). A rep must be assigned to at least one musician and can be assigned to multiple musicians or even the same musician more than once if that musician is associated with multiple artists. A label representative has a (unique) SIN, first name, last name, label name and phone number. For example, Paul Rodgers might be associated with rep Bob for Free (who recorded the classic All Right Now) and rep Kate for Bad Company.
Finally, the writers of songs are to be recorded. A song may have more than one writer but must have at least one. Writers of songs not in the database (or prospective writers) will not be recorded. A song writer may write many songs. In addition to the writers'' SINs, first names and last names the percentage royalty that they earn for each song should be recorded. These royalty percentages may vary from song to song.

Related Discussions:- data dictionary

Describe participation constraints, Describe Participation Constraints? ...

Describe Participation Constraints? Participation Constraints - The participation constraint exacts whether the existence of an entity depends on its being related to another

ER Diagram, Hi I have got an assignment for making an er diagram for market...

Hi I have got an assignment for making an er diagram for market management software can any budy help me?

How does query tree represent relational algebra expression, How does a que...

How does a query tree represent a relational algebra expression?  Discuss any three rules for query optimisation, giving example as to when should each rule be applied.     Ans

What is the use of raid, What is the use of RAID? A variety of disk-org...

What is the use of RAID? A variety of disk-organization methods, collectively called redundant arrays of independent disks are used to better the performance and reliability.

Task partitioning, Task Partitioning, Sequencing and Project Planning T...

Task Partitioning, Sequencing and Project Planning The tasks required for the service might be broadly partitioned into: 0.      Set up database tables and account file

Give detail description on transactions, Give detail description on Transac...

Give detail description on Transactions. - Using transactions we can group all SQL commands into a single unit. - Transaction begins with some task and finishes only when a

Explain the cascadeless schedule, Explain the Cascadeless Schedule A ca...

Explain the Cascadeless Schedule A cascadeless schedule is one in which for every pair of transactions Ti and Tj like that Tj reads a data item before written by Ti, the commit

Find a 3nf decomposition , Find a 3NF decomposition of the following relati...

Find a 3NF decomposition of the following relation scheme: University (Faculty, Dean, Department, Chair, Professor, Rank, Student}. The University relation satisfies the following

What are the several forms of identity, What are the several forms of ident...

What are the several forms of identity? a) Value b) Name c) Built-in

Describe the composite key, Describe the Composite Key Composite Key: ...

Describe the Composite Key Composite Key: Sometimes one key is not enough to uniquely recognize a row. E.g. in a single class Roll is enough to search a student, but in the w

Write Your Message!

Captcha
Order Assignment

Featured Services

Order Now

Popular Subjects

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +91-977-207-8620

Phone: +91-977-207-8620

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd