#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2013
    Posts
    1
    Rep Power
    0

    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?

    here is alink to my Er model attempt:
    www: shrani.najdi [dot] si/?n/oh/32HuiTFv/tester.png

    (sorry cant post link, as my account is new..)
  2. #2
  3. Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Sep 2006
    Posts
    858
    Rep Power
    388
    Originally Posted by kunkka500
    . . . E t c . . .
    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?
    Here is a link to some data models which you can compare with yours.


IMN logo majestic logo threadwatch logo seochat tools logo