Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2013

    Check my ER model, need advice

    Well, i am in a making of an ER model, it is like this: I have a hotel wich has rooms and appartments. And in one Appartment/room there can be 1-6 persons. The price depends on the room type. The rooms have diverse inventory (tv, radio,...), some are equiped with an inventory for handycapped people... There are also event that people can attend to (dance, movie, etc), some of these events are free and for some you need to pay.

    I made this ER model so far, but im afraid i made a mistake, because i dont know where i should include the PERSON entity, so i can search for instance which person attended an event or something like that...

    Can anyone guide me a bit?

    In the attachment is what i made, but i am not sure if its ok,... so im asking for your oppinion/guide
    Attached Thumbnails Attached Thumbnails test_er.png  

  2. #2
    Join Date
    Jul 2012

    A suggestion


    Here is a Data Model on Event Reservations from my Database Answers Web Site :-
    Event Reservations

    And here is one for Hotel Reservations :-
    Data Model for Hotel Reservations

    Maybe you should combine them to solve your problem.


    Barry in London

Posting Permissions

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