Compact Disc Database

[Slate]

Ive got this coursework, which i have sorta left to the last minute because i have done loads of access before for loads of different courseworks. But what i didnt realise was that i had forgotten how to do most things.....

I've gotta build a database for a cd stock management system. It has to store artist & then all the cd information. But each artist can have many cd's and many compilation cd's (obviously) im just having trouble working out the best way to store the information in the database.

One way i thought of doing it was a simple subform which stores whether or not the cd is compilation/album, and the rest of the details. Its is linked to the artist in the main form using a query. Does this seem reasonable?

oh and its all gotta be fully normalised if i can :s
and track listing do not have to be stored.

If anyone could give me some pointers i would be really really greatful.

 

[yippie_ky_yay]

Hey Slate,

To normalize - keep artist and cd seperate and then use another table to join the two:

tblArtist
artistID
artistName
...

tblCD
cdID
cdName
cdYear
...

tblMain
artistID (foreign key)
cdID (foreign key)

Good luck!

-Sean