If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > General > Database Concepts & Design > Help......Data Base design of MultiLocation Theatre booking service Of a company

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 02-02-12, 02:42
Gazala Gazala is offline
Registered User
 
Join Date: Feb 2012
Posts: 1
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

Last edited by Gazala; 02-02-12 at 04:50. Reason: posted in MySQL & DB2 forums
Reply With Quote
Reply

Tags
database design

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On