Create five sample data records for each table you create

Assignment Help Computer Engineering

Reference no: EM131853420

Problem

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.

Reference no: EM131853420

Questions Cloud

Design group of database table for st charles riding academy : Design a group of database tables for the St. Charles Riding Academy. The academy teaches students to ride by starting them on horses that have been ranked.

What is the rhetorical purpose of the essay shooting : Question: What is the rhetorical purpose of the essay shooting an elephant by George Orwell?

How was the role of drawing during the renaissance : How was the role of drawing during the Renaissance similar or different than it is today? What is the importance of drawing to artists

Animals and basic common nouns : Historical linguists have noted that certain plants, animals and basic common nouns can help reveal Indo-European history. From your reading/research

Create five sample data records for each table you create : Address of the recording company Design tables you would need so they are all in third normal form. Create five sample data records for each table you create.

Develop a fragrance line of products : Avon refused to provide the fragrances and when Claiborne was unable to obtain the fragrances on their own, Claiborne sued Avon?

What was president grant peace policy : What was President Grant's "Peace Policy"? In what ways was it a departure from the previous policy? How did it change thinking about the place of Indians

What are 2 historical events in american history : What are 2 historical events in American history (can be from any time period) where geographic location was important in understanding the event.

How many boxes of lettuce should the supermarket purchase : How many boxes of lettuce should the supermarket purchase tomorrow? (Use Excel's NORMSINV() function to find the correct critical value for the given a-level.

User Account

All Pages