Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 Other Topics
 Help With A Homework Assignment

Author  Topic 

ksweeper21
Starting Member

1 Post

Posted - 2009-12-01 : 23:40:52
I am taking an entry level programming class and we were assigned one last assignment before the Holidays. However, I have been sick for two weeks and I am completely lost on how to even start on the assignment, or what to do. I am not sure this is the right place to ask for help but maybe someone could help me, or at least point me in the right direction. This class focuses on concepts and we have never done any actual programming. We have only worked with pseudocode and flowcharts. But I assume we would use Access to complete this assignment?

The Assignment is on Using Relational Databases, from the book Programming Logic and Design 5th edition by Joyce Farrell.

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.


Please, any help would be very appreciated. Thank you and Happy Holidays
   

- Advertisement -