Video/game rental - table help

ratchet

New member
Local time
Today, 06:11
Joined
Mar 7, 2013
Messages
4
So I'm a beginner and am struggling with the tables. I need to have at least 7 and based on what the client wants i.e as much Customer info, keep track on what movies and games(also their genre) were rented, quantities hired on what dates,and sales income on each date. Also determine how many copies of a title are still available. Also movie and game are meant to have a unique id starting with GH followed by 10 characters.

This is what I've come up with

Customer:CUSTOMERID,Surname,Firstname,Gender,Address,Email adress, phone,D.O.B,date joined,
Area code:ADDRESS, suburb, area code
Item:ITEMID,Title,stock
Movie:TITLE,type( Has to be either - DVD,VHS,Bluray),Genre
Game:TITLE,platform(Has to be either - ps3,xbox360,nintendo),Genre
Hire: ITEMID, hire type ($3 overnight or $ 6weekly), date
Inventory: CUSTOMERID, ITEMID, Quantity

Is this efficient ? Words in caps lock is the PK. It seems wrong, with a lot of redundant data and am just lost, need help
 
Last edited:
Yes, no anyone? Just really wanting to know If I'm in the right direction, and if not point out the flaws in my tables - the unnecessary stuff.
 
Last edited:

Users who are viewing this thread

Back
Top Bottom