Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2012
    Posts
    2

    derived table, troubles , conceptual modeling, pls XD

    hi superguys,
    im building a website that supports a multiplex cinema, and allows users to book tickets for the screenings;
    so an user can do a prenotation, and i have set a class/object 'prenotation';


    i need to track the prenotation, that mean also the movie, the cinema, the date etc.. and if another user want to book, he cant see the booked seat as available, so i think i need to report someway the busy places so i (and the users) can know which places are free
    and this is way i think i need to track the prenotation

    now i wonder:
    first of all, should i think about this problem in the conceptual model?


    yes? so how should i manage this function in the conceptual model?
    should i give the right attributes to the prenotation class, in way that, for every prenotation i know the movie,the date, the cinema and the seat?
    or i can solve this in the relational schema?


    SUGGEST!!! SUGGEST!!! SUGGEEST!!! SUGGEEEST!!!

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by Menghins View Post
    so an user can do a prenotation, and i have set a class/object 'prenotation';
    what's a prenotation? and what's a class/object?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Oct 2009
    Location
    221B Baker St.
    Posts
    486
    Not sure about "prenotation" but class and object are primary in object-oriented development (objects get grouped into classes).

    Possibly this is an OO implementation?

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by papadi View Post
    Possibly this is an OO implementation?
    why conflate that with database design, then?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Oct 2009
    Location
    221B Baker St.
    Posts
    486
    Who knows what evil lurks in the hearts of men . . .

  6. #6
    Join Date
    Oct 2012
    Posts
    2
    prenotation = book of the tickets(and related seat in the cinema)

    Actually im using the object-oriented paradigm to create "data stores" by just inventing a new object(class)

    i have talked improperly, assuming it how if this was obvius, so i need to sorry XD

Posting Permissions

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