Explanation

A Data Model is a collection of related tables that can be analyzed together.

Example

Customers

    │

    │ CustomerID

    ▼

Sales ───────── Products

    │              │

    │ ProductID    │ ProductID

    ▼              ▼

 

             Product Information

A better model for a typical business is a star schema:

             Products

                 │

                 │

Customers ─── Sales ─── Employees

                 │

                 │

              Calendar

Sales is the central fact table, while Products, Customers, Employees and Calendar are dimension tables.

Practice

Create a Data Model containing:

• Sales
• Products
• Customers
• Calendar