Print Version of the Top-Level Subject Areas for a Hotel Napkin

Data Model for a Hotel Napkin

When I started thinking about my Hotel Napkin, I was leaving the Savoy Hotel in London where
I had been attending a Presentation organised by an American company called Adaptive Planning.
I met people in similar interests to mine and also with different interests which made for an interesting outing.
Step 1 : Define the 'Things of Interest' We define the 'Things of Interest' as Conferences, Conference Organisers, Delegates,
Hotels, Networking Contacts, Venues and so on.

So we end up with this draft list that provides our starting-point for designing the Data Model ...

Data Model for a Hotel Napkin

Step 2: Create the ERD Data Model
When we think about how these various things are related, we can define the following Business Rules and
how they might look in a 3NF Normalised Data Model.

ERD Data Model for a Hotel Napkin

Step 3: Align the ERD to our Canonical Data Model
When we align the ERD to our standard Database Answers Canonical Data Model,
this is the result (showing only the Entity names) :-

Canonical Data Model for a Hotel Napkin