<div>
Thanks for the information, that helps a lot. &nbsp;Having look at the existing options I reckon I'll go with one of those and customise it to our requirements. &nbsp;SP
</div>


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

<div>
<div class="content wysiwyg-content">
Hi, <br />
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. &nbsp;Here's an outline of the Entities (in caps) and their relationship with one another -<br />
<br />
GUEST makes RESERVATION books ROOM<br />
<br />
GUEST books and participates in ACTIVITIES<br />
<br />
RESERVATION books ACTIVITIES<br />
<br />
I've already created the ERD but am having trouble defining cardinality, any suggestions with detail would be much appreciated... &nbsp;SP
</div>
</div>


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

Assistance defining cardinality in an Entity Relationship Diagram required

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

A consultant is a professional who provides professional or expert advice in a particular area such as security (electronic or physical), management, education, accountancy, law, human resources, marketing and public relations, finance, engineering, science or any of many other specialized fields.