benji_styler06
New member
- Local time
- Yesterday, 21:21
- Joined
- Mar 20, 2006
- Messages
- 5
Hi,
I did some access work back in college and am now trying to construct a database for which i will use the xml output. Im trying to set up my ERD.
These are the tables i have:
ARTIST, ALBUM, TRACK, RECORD LABEL, GENRE.
The attached file shows my tables set up in access. Im pretty sure it makes sense but need it checking before i start constructing the database and queries etc.
I beleive Album should be many to one artist
Track should be many to one album
Record label should be one to many albums
Many albums to one genre
I know how to add pimary keys but not sure how to add foreign keys and complete the inital structure, showing the above relationships (one-to-many etc).
Any help/advice would be much appriciated,
Cheers
Ben.
I did some access work back in college and am now trying to construct a database for which i will use the xml output. Im trying to set up my ERD.
These are the tables i have:
ARTIST, ALBUM, TRACK, RECORD LABEL, GENRE.
The attached file shows my tables set up in access. Im pretty sure it makes sense but need it checking before i start constructing the database and queries etc.
I beleive Album should be many to one artist
Track should be many to one album
Record label should be one to many albums
Many albums to one genre
I know how to add pimary keys but not sure how to add foreign keys and complete the inital structure, showing the above relationships (one-to-many etc).
Any help/advice would be much appriciated,
Cheers
Ben.