 |
 |
|
 |
|
|
|
 |
| |
|
|
These Data Models have been contributed by Barry Williams, Principal Consultant with Database Answers.
1) This Page is designed to help you get started with designing a Database to support your work using SS5EE and/or in Coding4Fun.
The Data Models on this page are taken from the Top 20 of the Most Popular Models around the world.
If you are a Beginner, then we suggest you choose one of the first five Data Models.
If you are an Enthusiastic, then the second five are for you.
You can download the SQL Script to create the Tables in SQL Server 2005 Express Edition,(SS5EE).
You can also take a look at a diagram for each Data Model.
2) We are producing Tutorials around the Data Models.
3) We also publish monthly articles on database topics, targeted to the beginner or enthusiast developer.
|
|
|
|
|
|
| |
|
|
|
|
 |
| |
 Nr. |
Title |
Tables in the Data Model |
Level |
Download |
| 1 |
CD Collections |
Includes Artists, CDs, Tracks and Record Companies.
|
Beginner |
SQL |
| 2 |
Apartment Rentals |
Includes Apartments, Guests and Bookings. |
Beginner |
|
| 3 |
Hotel Reservations |
Includes Hotels, Guests, Rooms and Bookings. |
Beginner |
|
| 4 |
Video Rentals |
Includes Customers, Inventory and Rentals.
|
Beginner |
|
| 5 |
Inventory Control |
For Retail Stores, and includes Vendors, Product Items, and Stock Levels.
|
Beginner |
|
| 6 |
School Management |
Includes Students, Teachers and Parents. |
Enthusiast |
|
| 7 |
Clients and Fees |
Includes Clients and Fees.
|
Enthusiast |
|
| 8 |
Health and Fitness Clubs |
Includes Classes, Members and Staff.
|
Enthusiast |
|
| 9 |
Customers and Invoices |
Includes Accounts, Customers, Invoices, Products and Transactions.
|
Enthusiast |
|
| 10 |
Libraries and Books |
Includes Authors, Books and Members, (for the Enthusiast).
|
Enthusiast |
|
|
|
|
|
|
|
|
