Database Answers White Smoke in the Vatican (Click for ABC News Web Site)
Printer Printer-friendly version

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Data Model for White Smoke in the Vatican   
This is another of my Invisible Models that are based on things that we see around us every day without giving them much thought.
We demonstrate how to develop a 3NF Data Model and Dimensional Models from this simple start, using our Best Practice Event-driven Approach.
My first thought when I started this work was simply that I was interested in seeing where it would lead me.

My second thought was that because I was dealing with things I came across in my everyday life, that it would inevitably lead me to my Canonical Data MOdel.

I was very pleased to find this was the case ;-0)
An Access Database is available on demand.
The Specifications for the Data Model were obtained by thinking about the Napkin that I picked-up in the American Bar at the Savoy Hotel. .

We have designed a Dimensional Model, following our 'Best Pratice' Event-driven approach.
This is very useful for providng data for Reports and Business Intelligence.

We would be glad to have your comments.

If you are new to Data Models, this page of my new Tutorial will help you understand the Data Model.

Step 1) The Conclave of Cardinals
reaches a decision
Conclave of Cardinals (Click for ABC News Web Site)
Step 2) White smoke
signals the election of a new Pope
White Smoke in the Vatican (Click for ABC News Web Site)
Step 3) The new Pope appears New Pope in the Vatican (Click for Vatican News Web Site) Step 4) to the waiting crowd Crowd outside St.Peter's Basilica in Rome (Click for Vatican News Web Site)
Step 5) Create the ERD Data Model
When we think about how these various things are related, we find that
they map naturally on to the pattern of the Database Answers Canonical Data Model.

ERD Data Model for White Smoke in the Vatican
Step 6) This is our Canonical Data Model


DBA Canonical Data Model
The Dimensional Model looks like this

Dimensional Model


Barry Williams
Principal Consultant
Database Answers Ltd.
London, England
March 14th. 2013


© DataBase Answers Ltd. 2013
About Us Contact Us