 |
 |
|
 |
|
|
|
 |
| |
|
|
This Page is designed to help you if you want a series of Data Models in an e-Commerce Theme.
A Tutorial for Beginners supports Model Number 4 on Customers and Orders.
It uses Starbucks and Amazon.com as examples.
|
|
|
|
|
|
| |
|
|
|
|
|
 |
| |
 NR. |
LEVEL |
SSE |
TITLE |
TABLES INCLUDED |
| 1 |
Beginner |
SQL |
CD Collections |
Artists, CDs, Tracks and Record Companies.
|
| 2 |
Beginner |
SQL |
Video Rental Store |
Customers, Orders, Rentals and Videos - shows Inheritance. |
| 3 |
Beginner |
SQL |
Inventory Control |
For Retail Stores, and includes Vendors, Product Items, and Stock Level.
|
| 4 |
Beginner |
SQL |
Amazon and Starbucks |
Supports a Tutorial
which Uses Customers and Orders to cover the basic concepts of One-to-Many and Many-to-Many Relationships, as well as Primary Keys, Foreign Keys and so on.
|
| 5 |
Beginner |
SQL |
Customers and Addresses |
Includes Customers and Addresses for Billing, Delivery and so on.
|
| 6 |
Enthusiast |
SQL |
Customers and Invoices |
Includes Accounts, Customers, Invoices, Products and Transactions.
|
| 7 |
Enthusiast |
|
Orders and Deliveries |
Includes Customers, Trucks, Routes and Deliveries.
|
| 8 |
Enthusiast |
|
e-Commerce |
Includes Customers, Invoices, Products and Shipments.
|
| 9 |
Enthusiast |
|
Organisations and People |
Includes Organisations, Events and People.
|
| 10 |
Enthusiast |
|
Data Warehouse |
Star Schema for a Financial Transaction Data Warehouse.
|
 |
|
 |
|
|
|
|
|
|
|
