Question: It is required to develop a database system that tracks the compact discs andthe musical pieces that are recorded, as well as the authors and

It is required to develop a database system that tracks the compact discs andthe musical pieces that are recorded, as well as the authors and those whoplay the piece of music. The requirements are as follows: For each disk, we want to store the disk identifier, the title and theyear of production. A piece of music is recorded on a disc. This has a title and a numberthat indicates which track is recorded on the disc. For each disc, apiece is uniquely identified by its track number. For each person who may be the author or who touches the piece, it isnecessary to store their identifier, name and nationality. The identifieris unique. Each piece of music has at least one author who is a person. There aredifferent types of authorship, for example, composer, writer, arranger.For each author of a piece, it is required to store the type of authorship. Each musical piece has at least one person who is an instrumentalist.There are different instruments such as voice, piano, violin. You wantto store for each instrumentalist the instrument that you play duringthe recording. There may be a piece of music where the same personplays different instruments and performs various types of authorship.A person can be the author and instrumentalist of the same piece ofmusic, together with other authors and instrumentalists for the samepiece.1. As part of the conceptual design, create the entity relationship diagramfrom the above requirements.2. Reduce the ER diagram into a relational model.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!