 |
 |
|
 |
|
|
|
 |
| |
|
|
1) This Page is designed to help you if you want a series of Data Models in an e-Commerce Theme.
A Tutorial will support these Data Models.
|
|
|
|
|
|
| |
|
|
|
|
|
 |
| |
 1 |
CD Collections |
Includes Artists, CDs, Tracks and Record Companies,(for the Beginner),
download SQL Script.
|
| 2 |
Video Rental Store |
Includes Customers, Orders, Rentals and Videos - shows Inheritance,(for the Beginner ?),
download SQL Script.
|
| 3 |
Inventory Control |
For Retail Stores, and includes Vendors, Product Items, and Stock Levels, (for the Beginner).
download SQL Script.
|
| 4 |
Payrolls |
Includes Employees, Adjustments and Payments,(for the Beginner).
|
| 5 |
Customers and Addresses |
Includes Customers and Addresses for Billing, Delivery and so on. (for the Beginner).
|
| 6 |
Customers and Invoices |
Includes Accounts, Customers, Invoices, Products and Transactions, (for the Enthusiast).
|
| 7 |
Organisations and People |
Includes Organisations, Events and People, (for the Enthusiast).
|
| 9 |
Orders and Deliveries |
Includes Customers, Trucks, Routes and Deliveries, (for the Enthusiast).
|
| 8 |
e-Commerce |
Online Photo Catalogs - includes Customers, Transactions and Payments - shows Inheritance, (for the Enthusiast).
|
| 10 |
Data Warehouse |
Star Schema for a Financial Transaction Data Warehouse.
|
 |
|
 |
|
|
|
|
|
|
|
