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
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: