Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2008
    Posts
    2

    [Design] Cinema database

    helou

    i am designing database for cinema which should support ticket reservation. i am not convinced if my conception is good. i'll be appreciative for taking a look.

    http://antrodus.fm.interia.pl/cinemasys.jpg

    i'll be making an interface in delphi and i'm not sure how show reserved tickets on choosen seance. any ideas ?

    thanks 4 mountain

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    your primary keys are all wrong

    i'm assuming that since each primary key includes an "id" INTEGER, your intention was to use a surrogate (e.g. IDENTITY or AUTO_INCREMENT or SEQUENCE)

    you have separate tables movie_price_group and price_group -- why? (DECIMAL is correct, FLOAT is wrong)

    when a ticket is issued, is it for a specific seat? if so, why are tickets not linked to the seats table?

    finally, when is this assignment due?

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Jun 2008
    Posts
    2
    http://antrodus.fm.interia.pl/cinemasys3.jpg

    i'm using flamerobin [generators and triggers for autoincrement] for making database and delpihi for interface.

    movie_price_group is for 'premiere'=1, 'old'=0,8, price_group is for 'mon-thu'=5$, 'weekends'=8$ i thought it could be usefull for calculating prices of tickets -> movie_price_group * price_group ...

    ....

    In form1 i will make a view from tabels seance+movie+movie_kind+movie_age_restriction
    i'd like to show
    MOVIE title, time, SEANCE start,MOVIE_KIND name(ex. horror), MOVIE_AGE_RESTRICTION name(ex. 18)
    i will make search engine by movie title. when i choose movie i'll go to form 2

    with ideseance, idmovie and idroom (SEANCE) i'd like to paint all free [which are not in table TICKET] seats from room_has_seat
    then form3 with info seat_no, row_no, date, start(seance start), title, cost

    ....

    is it good ?
    Last edited by antro; 06-03-08 at 07:43.

Posting Permissions

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