Music Collection

You want to create a database to store information about your music collection. When you think about the information you will want to be able to access it includes:

• Name of CD or tape etc
• Format
• Name of particular recording
• Artist
• Style
• Year recorded
• Recording company

When you design your database, add other information that you think is valuable.

I want you to design the tables for this database and submit it to me comments. Because design is best done with a group I recommend that you form groups.

The design should include the layout of each table that you would need to set up in Access as well as the primary key for each table.