Database Answers Cargo Ship at Night
Printer Printer-friendly version

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Data Model for a Cargo Ship at Night   

This is the second of our 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 Data Marts from this simple start, using our Best Practice Event-driven Approach.
An Access Database is available on demand.
The Specifications for the Data Model were obtained by thinking about a Cargo Ship.

We might design a Data Mart, following our 'Best Pratice' Event-driven approach.
The Data Mart 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.

This Model show only Entity names which makes it easy to read.

When we think about a Cargo Ship at Sea, we think firstly about Ships and Cargo, and then we think about the Customers, Journeys, Staff 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 Cargo Ship at Sea
Then we think about how these various things are related, and how they might look on a 3NF Normalised Data Model.
For example, Customers arrange for their Cargo to be shipped from one Port to another.

ERD Data Model for a Cargo Ship at Sea

Barry Williams
Principal Consultant
Database Answers Ltd.
London, England
November 3rd. 2012

© DataBase Answers Ltd. 2012
About Us Contact Us