The Toilets Data Model
Back to the Home Page

My Approach My plan to design a simple Datababase for a Toilet.

Step 1 - Review the View from Head Office

Step 2 - Review the Conceptual Data Model

Step 3 - I start with a Photograph of the Toilet

Step 4 - Then I find a Drawing of a Standard Toilet This is based on the American Standard Toilets Parts Diagram and helps me to identify the separate parts that I use in my Data Model.

Step 5 - Then I design a Conceptual Data Model for the Diagram in Step 2. I have added the Toilet Lid and Seat because they don't appear in the American Standards Diagram.

Step 6 - Simplify the Conceptual Data Model I generalise the Model by replacing specific Components by generic Components. In this case, it means replacing Lid and Seat, Tank and Bowl by 'Assemblies', and Trip Lever by 'Components'.

Step 7 - Create a Logical Data Model

Step 8 - Then I create the Physical Model to generate the Database.

© Database Answers Ltd. 2018