The Toilets Data Model


Printer-friendly version

Careers

Data Models for a BOM for Furniture

An Access Database is available.

This is an example of a Bill of Materials Design Pattern and shows how we use the Pattern in practice.

This material is laid out as a Tutorial and supplements our page of Tutorials.
It will help you understand the thinking behind the construction of a simple Data Model.

My Approach
My plan to design a simple Datababase for a BOM for Furniture Data.

Step 1 - Review the View from Head Office

Step 2 - Review the Conceptual Data Model

Step 3 - I start with a Photograph of pieces of Furniture

Step 4 - Then I find a Drawing of the components in a Table
such as Legs and Table Tops.

Step 5 - Then I design a Conceptual Data Model
for the Diagram in Step 2, taking a Table as an example.

Img 4 - Parts Diagram

Step 6 - Then I design a Conceptual Data Model for a Data Warehouse