Database Answers

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map


Here are some useful 'Kick-Start' Data Models that I have created since I started 3 years ago.
If you would like an Access Database for any of these Models, let me know (but specify a Subject otherwise your email will be treated as spam).
Here's a Design Note     I have also added a Data Model Search facility.
   Why do I do this for free ?
I would appreciate your comments on my new Tutorial on Data Modelling.
  1. Accidents at Work
  2. Accommodation (Long-term)
  3. Act! Contact Management
  4. Afghanistan Rainfall
  5. Aircraft Parts and Orders
  6. Airline Booking
  7. Apartment Rentals
  8. Area Regulations
  9. Archeology
  10. Ars Digita BootCamp
  11. Assets Maintenance
  12. Asylum Seekers and Refugees
  13. Athletes and Events
  14. Athletes and Teams
  15. ATM Machines
  16. Auction Web Site
  17. Avon Cosmetics
  18. Ballet Companies (Casting Productions)
  19. Ballet Companies (Org and People)
  20. 'Bang for the Buck' Models
    1. Catalogs of Products
    2. Customers and Products
    3. Customers and Services
    4. Marriages (Contemporary)
    5. Marriages (Traditional)
    6. Partnerships and Relationships
    7. Product Catalogs
    8. Generic Foundation New
    9. Reservations
  21. Bank and Branches
  22. Bankrupts
  23. Basel II Accord
  24. Best Practice
  25. Bidders and Buyers
  26. Bill of Materials
  27. BMEWS
  28. Bookstore
  29. Bookstore and Warehouses
  30. Books and Libraries
  31. Business 2 Business e-Commerce
  32. Business 2 Consumer e-Commerce
  33. Call Centers
  34. Car Dealership
  35. Car Hire
  36. Car Parts Suppliers
  37. Car Sales
  38. Car Service Center
  39. Case Management
  40. Casinos
  41. CD Collection
  42. Charities
  43. Childrens National Database
  44. Chess Tournaments
  45. Church Members (Visio)
  46. Cinema Bookings (Dezign)
  47. City Licences
  48. City Tourist Guide
  49. Click Stream Analysis
  50. Clients and Consultants
  51. Clients and Fees
  52. Clients and Locations
  53. Clinical Trials
  54. Clown Registry
  55. Club Members
  56. Coach Trips
  57. Commercial Web Sites ...
    1. Avon Cosmetics
    2. eBay Deals
    3. Raiser's Edge Charities
    4. SalesForce
    5. Shrek 2 Movie
    6. Ticketmaster
  58. Communities ...
    1. FAQs and Newsletters
    2. Personalization
    3. Philip Greenspun
    4. Publish/Subscribe & KPI Portal
    5. User Registration
  59. Construction and Manufacturing
  60. Consultants and Clients
  61. Consultant Search Web Site
  62. Contacts
  63. Contract Management
  64. Corporate Intranet
  65. Cosmetics Home Sales
  66. Crisis Call Centers
  67. CRM and Personalization
  68. CRM - Microsoft's Data Model
    (looks terrible).
  69. CSR Framework
  70. CVs and Job Histories (Visio)
  71. Data Architecture
  72. Data Dictionary
  73. Data Warehouses ...
    1. eCommerce Data Warehouse
    2. Loading a Data Warehouse
    3. Snowflake Design for Transaction
    4. Star Design for Teaching Schedule
    5. Star Design for Transaction (Conceptual)
    6. Star Design for Transaction (Physical)
  74. Dating Sites
  75. Day Care Centers
  76. Department Store
  77. Dietician's Consulting Practice
  78. Dictionaries for Foreign Languages
  79. Doctor's Practice
  80. Document Management - Generic
  81. Document Management - Specific
  82. Document Publication
  83. Driving School
  84. Education and Students :-
    1. School Management System
    2. Student Assignments
    3. Student Athletes and Teams
    4. Student Exams
    5. Student Loans
    6. Student Work Placements
  1. Customers :-
    1. Clients and Fees
    2. Clients and Locations
    3. CRM Customer Metrics
    4. CRM and Personalization
    5. CRM Top-Level Architecture
    6. CRM Top-Level Overview
    7. Customers with multi-lingual B2C
    8. Customers at a Bank
    9. Customers at a Bookstore
    10. Customers at a Call Center
    11. Customers and Addresses
    12. Customers and Campaigns
    13. Customers and e-Commerce
    14. Customers and Car Hire
    15. Customers and Car Sales
    16. Customers and Car Servicing
    17. Customers and Dept Stores
    18. Customers and Deals (UML)
    19. Customers and Deliveries
    20. Customers and Games Shops
    21. Customers and Hairdressers
    22. Customers and Hardware Store
    23. Customers and a Health Center
    24. Customers and Insurance
    25. Customers and Loans
    26. Customers and Orders
    27. Customers and Phone Bills
    28. Customers and Products
    29. Customers and Services
    30. Customers Card Transactions
    31. Customers Comm & Personal
    32. Customer Data
    33. Customer Data Catalog
    34. Customers (Commercial & Personal)
    35. Customer MetaData Repository
    36. Customer Metrics
    37. Customer Order Tracking
    38. Generic Customer Model (Popkin)
  2. eBay Deals
  3. e-Commerce
    1. Games Web Site
    2. Orders & Shipments
    3. Photo Catalogs
  4. e-Government
  5. Employment Agencies
  6. Enterprise Information Repository
    1. Data Migration Mapping
    2. Generation of Entities
    3. Glossary of Business terms
    4. Glossary with Queries

  7. EPOS
  8. ERP
  9. Event Reservations
  10. Father of all Data Models.
  11. Financial Information Portal
  12. Foreign Language Dictionaries
  13. Franchise Operators
  14. Fund Raising
  15. Games Features
  16. Games Store
  17. Genealogy Family Tree
  18. Generic Data Models
    1. Customers and Services
    2. Document Management
    3. Father of All Models
    4. Generic Foundation
    5. Organisations and People
    6. Organisations and Transactions
    7. Patient Care
    8. Places, Players & Events (1)
    9. Places, Players & Events (2)
    10. Reservations
    11. Transport
    12. User-defined Hierarchies
  19. George Orwell's 1984
  20. Global Accountability
  21. Global Community
  22. Global Consulting
  23. Global Law Firm
  24. Global Reference Database
  25. Golf Club Management
  26. Golf Tournaments
  27. GRI Indicators
  28. GRI Repository
  29. Hairdressers Appointments
  30. Hardware Sales
  31. Health Centers
  32. Health Clubs
  33. Health Insurance Claims
  34. Help Desk
  35. Hierarchies & Trees
    1. Employees
    2. Organization Hierarchies
    3. Preferences
    4. Product Hierarchies
    5. Reference Data Manager
    6. User-Defined Hierarchies
    7. Vehicle Parts Manufacture
    8. World Language Classification
      (with Oracle CONNECT BY)
  36. Hospice Patient Care
  37. Hospital Admissions
  38. Hotel Reservations
  39. HR or Personnel Department
  40. Houses and Rooms
  41. IAA Insurance Party
  42. Inheritance Models
    1. Charities
    2. City Tourist Guide
    3. Customers Commercial and Personal
    4. Games Store
    5. Insurance Brokers
    6. Libraries for Lawyers
    7. National Trust (UK)
    8. Photo Catalogs
    9. School Management System
    10. Shrek 2 Movie
  43. Insurance Brokers
  44. Inventory Control
    1. Inventory Control (Files in Boxes)
    2. Inventory Control (Manuals)
    3. Inventory Control (Publishing)
    4. Inventory Control (Retail Store)
    5. Inventory Control (Sports Centers)
  45. Inventory of Servers
  46. Investment Banking
  47. Job Scheduling
  48. Job Scheduling (2)
  49. Justice Department
  50. Key Performance Indicators
  51. Kitchen Cabinets
  52. Knowledge Management
  53. Land Registry
  54. Landscape Gardening
  55. Law Enforcement
    1. Case Management
    2. Justice Department
    3. Lawyers, Cases and Bills
    4. Libraries for Lawyers
    5. Prisons and Prisoners
    6. Tracking Evidence
    7. Traffic Cops and Tickets
  56. Legal Case Management
  57. Libraries
  58. Libraries and Books
  59. Libraries for Lawyers
  60. Libraries for Teachers
  61. Loan Management System
  62. Local Govt (UK)
  63. Long Term Accommodation
  64. Mail System
  65. Maintenance Contracts :-
    1. For Products with no Parts
    2. For Products with Parts (Dezign)
  66. Manuals at Locations
  67. Medical :-
    1. Dietician Practice
    2. Doctor's Practice
    3. Health Center
    4. Health Insurance Claims
    5. Hospice Patient Care
    6. Hospital Admissions
    7. Nursing Home
    8. Patient Care
    9. Pharmacies and Generics
    10. Pharmacies and Prescriptions
    11. Pharmaceutical Supplies
  68. Message Board for a Web Site
  69. MetaData Management
  1. Modelling Agency
  2. MP3 Music Site
  3. Museums (Simple)
  4. Museums (Complex)
  5. Musicians in Newspapers
  6. Musicians in a Band
  7. National Trust (UK)
  8. Newsagents
  9. Newsletters
  10. Not For Profits (NPOs)
  11. Nursing Home
  12. Offshore Drilling Equipment
  13. Olympic Sports
  14. Oracle Data Dictionary
  15. Oracle Database Rpt
  16. Oracle PL/SQL
  17. Orders and Parts
  18. Organisations and People
  19. Organisations and Transactions
  20. Package Delivery Service
  21. Parking Space Registration
  22. Parties and Products
  23. Partners in a Firm
  24. Patient Care
  25. Payrolls
  26. Performance Monitoring
  27. Personalization
  28. Personal Insurance
  29. Pharmacies and Generics
  30. Pharmacies and Prescriptions
  31. Pharmaceutical Supplies
  32. Philip Greenspun's Communities
  33. Phone Bills
  34. Photo Catalogs (e-Commerce)
  35. Picture Library
  36. Pizza Deliveries
  37. Popkin System Architect :-
    1. Data Warehouse
    2. Data Dictionary
    3. Generic Customer Model
    4. Hotel Reservations
    5. National Trust Visitors
  38. Portals
  39. Portals and KPIs
  40. Prisons and Prisoners
  41. Products :-
    1. Bill of Materials
    2. Product Catalogs
    3. Product Categories
    4. Product Characteristics
    5. Product Distribution
    6. Product Hierarchies
    7. Product Servicing
    8. Products and Security
  42. Project Planning
  43. Project Staff
  44. Properties (National Trust)
  45. Properties (Real Estate)
  46. Proposals, Projects & Donors
  47. Pub Quiz League
  48. Pubs and Parties
  49. Questionnaire - Complex Analysis
  50. Questionnaire Health History
  51. Questionnaire - Analysis
  52. Questionnaire - Simple Analysis
  53. Questionnaire - Very Simple
  54. Railway Reservations
  55. Real Estate Agents
  56. Real Estate Rentals
  57. Real Estate Sales
  58. Real World Series
    1. Generic Real World
    2. Real World of CSR
    3. Real World of Entertainment
    4. Real World of Insurance
    5. Real World of Sports
  59. Recipes
  60. Record Label
  61. Recruitment Agencies
  62. Reference Database
  63. Reference Data Manager
  64. Refugees & Asylum Seekers
  65. Removals Companies
  66. Reservations :-
    1. Apartment Rentals
    2. Car Hire
    3. Cinema Bookings
    4. Coach Trips
    5. Driving School
    6. Event Reservations
    7. Hairdressers Appointments
    8. Health Centers
    9. Hotel Reservations
    10. Railway Reservations
    11. Restaurant Bookings
    12. Sports Centers
    13. Ticketmaster
    14. Vehicle Rental
  67. Resources Requesters
  68. Restaurant Bookings
  69. Restaurant Delivery Service
  70. Risk Management (UML)
  71. Sailing Club
  72. Sales Force.com (ERWin)
  73. Sales Promotion Analysis
  74. School Management System
  75. Search Engine
  76. Search for a Data Model
  77. Search for Musicians in Articles
  78. Search for Items in Newspapers
  79. Service Assessment
  80. Show Business
    1. Ballet Companies
    2. CD Collection
    3. Circus
    4. Clown Registry
    5. Talent Agency
    6. ticketmaster
  81. Shrek2 Movie
  82. Snowflake Design
  83. Sports Centers
  84. Star Design for Teaching Schedule
  85. Star Design for Transaction
  86. Stock Control
    1. Stock Control (Retail Store)
    2. Stock Control (Sports Centers)
  87. Stockmarket Data
  88. Student Assignments
  89. Student Athletes
  90. Student Exams
  91. Student Loans
  92. Student Work Placements
  93. Talent Agency
  94. Tax Receipts
  95. Taxi Service
  96. Technical PC Support
  97. Telephone Bills
  98. Tenant Contact Tracking
  99. Theater Company
  100. Ticketmaster
  101. Tracking Customer Orders
  102. Tracking Evidence
  103. Tracking Software Problems
  104. Tracking Tenant Contacts
  105. Traffic Cops and Tickets
  106. Transportation and Shipments
  107. UML Class Diagrams
  108. UN Global Compact
  109. Used Flutes Exchange
  110. User-Defined Hierarchies
  111. User Portals
  112. User Portals and KPIs
  113. User Profiles
  114. Vehicle Mileage Tracking
  115. Vehicle Parts Manufacture
  116. Vehicle Rental
  117. Video Purchase
  118. Video Rental
  119. Volcanoes (Visio & Dezign)
  120. Web Site for a Community
  121. Web Site for DBA Site
  122. Web Site Analysis
  123. Web Site Pages
  124. WebSite Registration
  125. Web Site Traffic Analysis
  126. Workflow
  127. Worksheets
  128. World Health Organization STD
  129. World Language Classification
  130. Zoos

A Design Note on Primary Keys
My approach is very simple and always uses a system-generated unique number as a Primary Key, (except for Reference Data).
This is called a surrogate key, but there is a 'gotcha' which can be deadly. It is all too easy to enter the same record twice. Therefore you must always be sure to enforce a unique constraint on the natural key. Luckily this is easy to do in Access which can be a good basis for clarifying your design and constraints.

Why do I do this for free ?
I design these Data Models for free to give something back to the Database community that has provided me with a good (and interesting) living for the past 15 years.

Each Model is usually what I can do in the 20 minutes of voluntary work that I allocate from my consulting work.

My intention is to provide a wide range of 'Kick Start' Models that anyone can use as a starting-point, and could extend cleanly and logically, with appropriate reference to the Business Rules.

It is not my intention to provide Models that can be used off-the-shelf to meet the requirements of a large commercial organisation.
After all, that is one of the things I do for a living !!!

None of the Models is the complete and final solution in its area, but any of them can be added to easily and quickly to meet a specific requirement. The logic in each Model is correct and contains the minimum Entities for the area being modelled. It is easy to create a complex Model by combining these Kick-Start Models because they all follow the same design approach and standards.

Generally, I try to make the Data Models and the associated Business Rules consistent, but I don't always define the Rules because that is a very valuable 'exercise for the student'.
I'd be very interested in hearing any
suggestions for improving this facility.
Home Ask a Question Careers Contact us Data Models First Timers Search Site Map