[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
Solved

# Assistance defining cardinality in an Entity Relationship Diagram required

Posted on 2009-02-22
Medium Priority
1,428 Views
Hi,
I'm creating a ERD for a hotel with leisure facilities who are moving from a manual system of reservations and would appreciate some assistance in defining the cardinality of the Entities in said ERD.  Here's an outline of the Entities (in caps) and their relationship with one another -

GUEST makes RESERVATION books ROOM

GUEST books and participates in ACTIVITIES

RESERVATION books ACTIVITIES

I've already created the ERD but am having trouble defining cardinality, any suggestions with detail would be much appreciated...  SP
0
Question by:spower22

LVL 36

Accepted Solution

Gary Patterson earned 1200 total points
ID: 23705978
There is an awful lot of decent hotel software out there already built, tested, debugged, and working.  Do you really want to build something that you can buy for \$200:

http://www.imagichotelreservation.com/ (just and example - I haven't used it - but it looks like there is a free trial available.)

Also, if you haven't already, take a look at aoy of these open source hotel projects.  Even if you don't adopt one as your starting point (and why wouldn't you?), you'll certainly get ideas for features and structure:

http://sourceforge.net/search/?words=hotel&sort=score&sortdir=desc&offset=0&type_of_search=soft&pmode=0

Anyway, here's a shot at your relationships.

GUEST : RESERVATION - Possession
RESERVATION : ROOM - Association
GUEST : ACTIVITY: Association
RESERVATION : ACTIVITIES - Association

http://www.datamodel.org/DataModelCardinality.html

In a real life the relationships may be a bit more complex, since there may also be entities such as is also the relationship to ROOMTYPES (reservations are typically made for a given room type, rather than a specific room) and perhaps ACCOUNT - a method of aggregating charges for a group of rooms, or for billing non-guests for banquet or activities.

Hope this helps.

- Gary Patterson

0

LVL 35

Assisted Solution

David Todd earned 800 total points
ID: 23707876
Hi,

To echo and enlarge on Gary's thoughts above, there is a lot of software out there.

A guest's stay is a process
make a booking
confirm a booking
change the booking
check-in and room assignment!
hotel's nightly process charges for room
check-out
pay bill

Rather than start by modelling the static data, I would model the process. The process will require different states to be saved at different times.

If you end up building something, make very sure that even if it does't have that many features, that each feature is very resiliant. Hotels tend to be busy places, with some of the less IT Savy folk, and often at night staffed by folk on minimum wage. It seems that people skills and IT skills are on opposite ends of a personality continuim. That is, it has to be EASY to use and DIFFICULT to crash.

I've done my time supporting a product called Hotelier Plus, so I've a little experience in where you are going ...

HTH
David
0

Author Comment

ID: 23709672
Thanks for the information, that helps a lot.  Having look at the existing options I reckon I'll go with one of those and customise it to our requirements.  SP
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What we learned in Webroot's webinar on multi-vector protection.
Creating a Cordova application which allow user to save to/load from his Dropbox account the application database.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
###### Suggested Courses
Course of the Month19 days, 6 hours left to enroll