Results 1 to 1 of 1
  1. #1
    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 05:50. Reason: posted in MySQL & DB2 forums

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •