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.
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 recordedYear acquired as part of your collectionRecording companyAddress of the recording companyDesign 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 |
|
|
|
|