Assume that you want to create a database to store information

QUESTION

. Assume that 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 MP3 file) • 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.

ANSWER:

REQUEST HELP FROM A TUTOR