question archive Assume you want to create a database to store information about your music collection

Assume you want to create a database to store information about your music collection

Subject:Computer SciencePrice: Bought3

Assume you want to create a database to store information about your music collection. You want to be able to query the database for each of the following attributes:

§  A particular title (for example, Tapestry or Beethoven’s Fifth Symphony)

§  Artist (for example, Carole King or the Chicago Symphony Orchestra)

§  Format of the recording (for example, CD or tape)

§  Style of music (for example, rock or classical)

§  Year recorded

§  Year acquired as part of your collection

§  Recording company

§  Address of the recording company

Design the tables you would need so they are all in third normal form. Create at least five sample data records for each table you create.

pur-new-sol

Purchase A New Answer

Custom new solution created by our subject matter experts

GET A QUOTE