Hi, This is my first posting and hope that you guys can help me. My knowledge of Database designing is reasonable but not at a professional level - I think!
I am building a database for multi location Theatre booking service providind printable booking vouchers to recognised users. The database will store information about the various shows ,showtimings, seat information in theatre and register purchaser bookings.
I have made following tables for MultiLocation Theatre booking service....Please check whether i have done correctly.
Am i using too many tables..
Any help would be greatly appreciated. You can email me privately at
nazir.gazala@yahoo.com if it is too lengthy or complicated to post in the forum.
COMPANY:
CompanyId----Primary Key
CompanyName
CompanyAddress
THEATRE:
TheatreId----Primary Key
TheatreName
TheatreAddress
LOCATION:
LocationId----Primary Key
TheatreId----Foreign Key
LocationName
LocationAddress
ContactNo
SHOW:
ShowId----Primary Key
LocationId----Foreign Key
ShowName
ShowDuration
SHOWDAY:
DayId----Primary Key
Day
SHOWTIME:
TimeId----Primary Key
TimeHour
TimeMinute
SHOWSCHEDULE:
ShowId----Foreign Key
DayId----Foreign Key
TimeId----Foreign Key
SEATCLASS:
Class----Primary Key
Price
SEAT:
SeatNo----Primary Key
Class----Foreign Key
RowNo
ColNo
PURCHASER:
PurchaserId----Primary Key
PurchaserName
PurchaserAddress
PurchaserTelephone
PurchaserEmail
PURCHASERBOOKING:
PurchaserBookingId----Primary Key
PurchaserId----Foreign Key
ShowId----Foreign Key
DayId----Foreign Key
TimeId----Foreign Key
BookingTime
I have made following tables for MultiLocation Theatre booking service....Please check whether i have done correctly:
COMPANY:
CompanyId----Primary Key
CompanyName
CompanyAddress
THEATRE:
TheatreId----Primary Key
TheatreName
TheatreAddress
LOCATION:
LocationId----Primary Key
TheatreId----Foreign Key
LocationName
LocationAddress
ContactNo
SHOW:
ShowId----Primary Key
LocationId----Foreign Key
ShowName
ShowDuration
SHOWDAY:
DayId----Primary Key
Day
SHOWTIME:
TimeId----Primary Key
TimeHour
TimeMinute
SHOWSCHEDULE:
ShowId----Foreign Key
DayId----Foreign Key
TimeId----Foreign Key
SEATCLASS:
Class----Primary Key
Price
SEAT:
SeatNo----Primary Key
Class----Foreign Key
RowNo
ColNo
PURCHASER:
PurchaserId----Primary Key
PurchaserName
PurchaserAddress
PurchaserTelephone
PurchaserEmail
PURCHASERBOOKING:
PurchaserBookingId----Primary Key
PurchaserId----Foreign Key
ShowId----Foreign Key
DayId----Foreign Key
TimeId----Foreign Key
BookingTime