N
newbie2db66
Hi
I'm very new to Access databases and I'm trying to set up a system for a DVD
rental shop. At the moment I have my tables set up as below, but I've been
told that this is not normalised and won't work properly. Apparently I need
to add another table. I'm also not sure what type of relationships I should
have.
tblCustomer
Customer ID PK
Title
Surname
Forename
Address
Town
Postcode
Contact Number
Film Genre
Payment Method
Join Date
Paid Membership?
tblRental
Rental Number PK
Customer ID FK
DVD ID FK
Nights Rented
Date Rented
Date of Return
Cost Per Night
Normalisation
tblDVD
DVD ID PK
Film Genre
DVD Title
Main Actor
Film Length
Rating
5 Star Rating
Any help would be much appreciated.
Thanks
I'm very new to Access databases and I'm trying to set up a system for a DVD
rental shop. At the moment I have my tables set up as below, but I've been
told that this is not normalised and won't work properly. Apparently I need
to add another table. I'm also not sure what type of relationships I should
have.
tblCustomer
Customer ID PK
Title
Surname
Forename
Address
Town
Postcode
Contact Number
Film Genre
Payment Method
Join Date
Paid Membership?
tblRental
Rental Number PK
Customer ID FK
DVD ID FK
Nights Rented
Date Rented
Date of Return
Cost Per Night
Normalisation
tblDVD
DVD ID PK
Film Genre
DVD Title
Main Actor
Film Length
Rating
5 Star Rating
Any help would be much appreciated.
Thanks