The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | May 2017 |
| Last Sign in: | 398 Weeks Ago, 6 Days Ago |
| Questions Answered: | 66690 |
| Tutorials Posted: | 66688 |
MCS,PHD
Argosy University/ Phoniex University/
Nov-2005 - Oct-2011
Professor
Phoniex University
Oct-2001 - Nov-2016
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.
Hel-----------lo -----------Sir-----------/Ma-----------dam-----------Tha-----------nk -----------You----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------and----------- ac-----------qui-----------sit-----------ion----------- of----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n.P-----------lea-----------se -----------pin-----------g m-----------e o-----------n c-----------hat----------- I -----------am -----------onl-----------ine----------- or----------- in-----------box----------- me----------- a -----------mes-----------sag-----------e I----------- wi-----------ll