Can anyone check my ER model?

[Hikarim]

Well, i am in a making of an ER model..
Can anyone guide me a bit?

[IMG][/IMG]

[Netzgeist]

i dont know where i should include the PERSON entity

persons have accomondations which may or may not include events. does the hotel have all the persons or are there persons who are not related to the hotel (accomondation requirements)?

[Hikarim]

The hotel has all the persons, who are accomodated in rooms/appartments ... and those persons can join events. and the hotel is hosting those events

[Netzgeist]

so put persons next to hotel since the hotel will register any events/accomondations for them.

[Hikarim]

I tryed to think through and fixed my model a bit... Do you think i did right that i connected EVENTS with PERSONS, even tough the hotel is the organizer, but only hotel customers attend, so i tought this way is good, or am i wrong?

And, do you think i di ok with the accomodation and its connections?
[IMG][/IMG]

[Netzgeist]

If the hotel can create/modify and link persons to events, youll also need to visualize this connection. rest looks okay to me.

[Hikarim]

So there should be a link between HOTEL -> EVENTS and PERSONS -> EVENTS, right?

[AT0MiX]

basically, thats not an ER-Model.

You have to use "relations" between 2 entities.

for exmaple:

[Netzgeist]

Sure but this way only:

Event:
- has list<person>persons
- has type
- has name

Person:
- has accoms
- may have additional unique data

Accom:
- has capacity
- has list<item> inventory
- has type
- has price

Hotel:
- has list<event> (add/rem/mod)
- has list<person> (add/rem/mod)
- has list<accom> (add/rem/mod)
-- (add/rem/mod) persons to events
-- (add/rem/mod) accoms to persons


To clarify:
Ask yourself what a person actually does irl to join an event or sign an accom: He asks the hotel to do so.

[Hikarim]

So, i made another(fixed) model, i hope i made it right
[IMG][/IMG]

So, i the connection betwwen EVENTS-PERSONS right?, i connected HOTEL->EVENTS, because the hotel can make events, delete them etc,...and EVENTS-> PERSONS, because each event has a person that attends (or something in that logic), or should i make another entity LIST and connect it like this: EVENTS->LIST<-PERSONS ?

ok, i actually done the whole thing and tested with with a base, and it works, so i would like to tank you for all the help Netzgeist, Thank you!