I want to create a database to store information about my music collection. I 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
Can you help me to design the tables that I need so that they are all in third normal form.I also want to create at least five sample data records for each table I create.
Can someone help me here please!.I'm novice when it comes to databases.
Eager Student