Database Answers Locations of visitors to this page
Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map

I've added a PayPal button to make it easier for people who want to make a voluntary contribution (starting at $10) to help with the cost of producing these Databases.
Ten of my Data Models are featured as Starter Databases for Microsoft SQL Server 2005 Express.

Here are more than 600 very useful 'Kick-Start' Data Models that I have created since I started 5 years ago,   and here's the Top 20
If you would like an Access Database for any of these Models, email me at dba_requests-at-myway.com, simply replace -at- by an @ sign, and put the Database name in the Subject.
If you are new to Databases, then check out my new Tutorial on Understanding a Database Schema.
You are invited to join my new Community for people interested in Databases, which has members from 80 different Cities around the world.
  1. Access Control
  2. Accidents at Work
  3. Accommodation (Long-term)
  4. Actions,Decisions,People & Property
  5. Afghanistan Rainfall
  6. Agents and Leads
  7. Agents Commissions
  8. Aircraft Parts and Orders
  9. Airline Reservations
  10. Airport Management
  11. Amazon and Starbucks
  12. Animal Shelters
  13. Apartment Rentals
  14. Aquarium Stores
  15. Area Regulations
  16. Archeology
  17. Ars Digita BootCamp
  18. Art Galleries
  19. Art Galleries (Online)
  20. Assets Maintenance
  21. Asylum Seekers and Refugees
  22. Athletes and Events
  23. Athletes and Teams
  24. ATM Machines
  25. Auction Web Site
  26. Avon Cosmetics
  27. Baby-Sitters and Nannies
  28. Badminton Clubs
  29. Balbir's Expert Exchange
  30. Ballet Companies (Casting Productions)
  31. Ballet Companies (Org and People)
  32. '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
    9. Reservations
  33. Bank and Branches
  34. Banking (Online)
  35. Bankrupts
  36. Baseball Umpire Scheduling
  37. Basel II Accord
  38. BBC (UK)
  39. Behavior Monitoring
  40. Best Practice
  41. Bidders and Buyers
  42. Bill of Materials
  43. Blogs
  44. Blood Banks
  45. BMEWS Data Architecture
  46. BMEWS Organization
  47. Boating Marinas
  48. Bookstore
  49. Bookstore and Warehouses
  50. Books and Libraries
  51. Botanical Gardens
  52. Boutiques
  53. Boy Scouts
  54. Breast Cancer Screening New
  55. Business 2 Business e-Commerce
  56. Business 2 Consumer e-Commerce
  57. Business Directories
  58. Call Centers
  59. Canal Trips
  60. Cancer Screening New
  61. Car Dealership
  62. Car Hire
  63. Car Park Security
  64. Car Parking Enforcement
  65. Car Parts Suppliers
  66. Carphone Warehouse
  67. Car Sales
  68. Car Service Center
  69. Case Management (Lawyers)
  70. Case Management (Social Workers)
  71. Casinos
  72. Catalogs of Products
  73. Catering Businesses for Schools
  74. Catering Services
  75. Catteries
  76. Cattle Breeding
  77. CD Collection
  78. Cemetaries
  79. Census Results
  80. Charities and Appeals
  81. Charities (Just Giving)
  82. Chess Tournaments
  83. Children in Institutions (UNICEF)
  84. Children's Aid Rcds Mgt
  85. Childrens Common Assessment Framework
  86. Children's National Database
  87. Children's Playgroup
  88. Church Donations
  89. Church Members (Visio)
  90. Church Praise Teams
  91. Church Sunday Schools
  92. Church (Youth)
  93. Cinema Bookings
  94. Circus
  95. Cirque du Soleil
  96. Citizens and Services
  97. City Councils
  98. City Hall Certificate Registration
  99. City Licences
  100. City Tourist Guide
  101. Click Stream Analysis
  102. Clients and Consultants
  103. Clients and Fees
  104. Clients and Locations
  105. Clinical Trials
  106. Clown Registry
  107. Club Members
  108. CMDB - Configuration Mgt DB
  109. Coach Trips
  110. Commercial Web Sites ...
    1. Avon Cosmetics
    2. Cirque du Soleil
    3. Dice (Job Seekers Web Site)
    4. Dog Whisperer
    5. eBay Deals
    6. Just Giving (Charity)
    7. MyLifeBits Research
    8. NewEgg
    9. SalesForce
    10. Shrek 2 Movie
    11. Ticketmaster
  111. Coding 4 Fun Projects
  112. Communities ...
    1. Community Groups and Workers
    2. FAQs and Newsletters
    3. Personalization
    4. Philip Greenspun
    5. Publish/Subscribe & KPI Portal
    6. User Registration
  113. Complaints and Feedback
  114. Competition Results
  115. Conference Centers
  116. Conservation of Historic Objects
  117. Construction and Manufacturing
  118. Construction Jobs Bidding
  119. Consultants and Clients
  120. Consultant Search Web Site
  121. Contacts and Products
  122. Contact Management
  123. Contract Management
  124. Contract Staff Agencies
  125. Corporate Intranet
  126. Cosmetics Home Sales
  127. Course Catalogs
  128. Cow's Events
  129. Consumer Packaged Goods (CPG)
  130. CraigsList
  131. Credit Accumulation (Europe)
  132. Crisis Call Centers
  133. CRM
  134. CSR Framework
  135. CVs and Job Histories (Visio)
  136. Dance School
  137. Data Architecture
  138. Data Dictionary
  139. Data Mart Case Studies
  140. Data Mashups
  141. Data Warehouse ...
    1. Customers and Purchases
    2. eCommerce Data Warehouse
    3. Loading a Data Warehouse
    4. Pharmaceuticals
    5. Snowflake Design for Transaction
    6. Star Design for Teaching Schedule
    7. Star Design for Transaction (Conceptual)
    8. Star Design for Transaction (Physical)
  142. Databases for Life
  143. Dating Sites
  144. Day Care Centers
  145. Debt Collection
  146. Department Store
  147. Diabetes Diagnosis and Treatment
  148. Dietician's Consulting Practice
  149. Dictionaries for Foreign Languages
  150. Digital Challenge (UK)
  151. Diseases and Symptoms
  152. Doctor's Practice
  153. Document Management
  154. Document Management (Specific)
  155. Document Publication
  156. Document Workflow
  157. Dog Kennels
  158. Dog Whisperer
  159. Domestic Violence Centers
  160. Donations :-
    1. Church Donations
    2. Library Donations
  161. Drivers Citations Log
  162. Driving School
  163. Driving Test Scores Database
  164. Education :-
    1. Educational Networks
    2. School Management Systems
    3. School Print Shops
    4. Schools Sports Tournaments
    5. Student Accommodation
    6. Student Assessments (Simple)
    7. Student Assessments (Complex)
    8. Student Assignments
    9. Student Athletes and Teams
    10. Student Exams
    11. Student Exams in Saudi
    12. Student Information Systems
    13. Student Loans
    14. Student Registration New
    15. Student Rosters
    16. Student Transcripts Tracking
    17. Student Work Placements
    18. University Course Catalogs
  165. eBay Deals
  166. e-Commerce
    1. B2B e-Commerce
    2. B2C e-Commerce
    3. Customers, Campaigns and e-Commerce
    4. Games Web Site
    5. Orders & Shipments
    6. Photo Catalogs
    7. Shopping Carts
  167. e-Government
    1. UK e-Govt Standard Data
  168. e-Learning
  169. Elephant Sanctuaries
  170. Emergency Services
  171. Employees
  172. Employees Leave Records
  173. Employees Working at Home
  174. Employment Agencies
  175. Endangered Species
  176. Enterprise Data Mashups
  177. Enterprise Information Repository
    1. Data Migration Mapping
    2. Generation of Entities
    3. Glossary of Business terms
    4. Glossary with Queries
  178. Entertainment

  179. Environmental Impact Assessment
  180. EPOS
  181. Equipment Maintenance
  182. Estimating Development Costs
  183. ERP
  184. Event Registrations
  185. Event Reservations
  186. Events in a Cow's Life
  187. FAQs
  188. Families and Wills
  189. Family Advocacy
  190. Farm Management
  191. Farms and Cow's Events
  192. Fashion Boutiques
  193. Father of all Data Models
  194. FBI Global Database
  195. Feedback and Complaints
  196. File Archiving Systems
  197. Financial Portals
  198. Fingerprint Recognition
  199. Fish Factory
  200. Fishing Industry
  201. Football Clubs
  202. Foreign Language Dictionaries
  203. Foreign Language Tournament Listings
  204. Forensic Science Labs
  205. Forklift Truck Servicing
  206. Fox Hunting New
  207. Franchise Operators
  208. Freight Forwarders
  209. Fuel Coupons Mgt
  210. Fund Raising
  211. Funeral Homes
  1. Customers :-
    1. Clients and Fees
    2. Clients and Locations
    3. CRM
    4. Customers with multi-lingual B2C
    5. Customers at a Bank
    6. Customers at a Bookstore
    7. Customers at a Call Center
    8. Customers and Addresses
    9. Customers and Campaigns
    10. Customers and Car Hire
    11. Customers and Car Sales
    12. Customers and Car Servicing
    13. Customers and Credit Cards
    14. Customers and Dept Stores
    15. Customers and Deals (UML)
    16. Customers and Deliveries
    17. Customers and e-Commerce
    18. Customers and Games Shops
    19. Customers and Hairdressers
    20. Customers and Hardware Store
    21. Customers and Health Centres
    22. Customers and Insurance
    23. Customers and Invoices
    24. Customers and Loans
    25. Customers and Online Banking
    26. Customers and Orders
    27. Customers and Partial Deliveries
    28. Customers and Phone Bills
    29. Customers and Price Comparison Web Sites New
    30. Customers and Products
    31. Customers and Purchases Data W'hse
    32. Customers and Retail
    33. Customers and Services
    34. Customers and Water Bills
    35. Customer Class Scheduling
    36. Customers Comm & Personal
    37. Customer Data
    38. Customer Data Catalog
    39. Customer Journey Mapping New
    40. Customers (Commercial & Personal)
    41. Customer MetaData Repository
    42. Customer Metrics
    43. Customer Order Tracking
    44. Generic Customer Model (Popkin)
  2. Future of Databases
  3. Gambling (Online)
  4. Games Features
  5. Games Store
  6. Gaming Leagues
  7. Garbage Collection and Recycling
  8. Genealogy and Family Trees
  9. Generic Data Models
    1. Circus (Events & Players)
    2. Customers and Services
    3. Document Management
    4. Father of All Models
    5. Generic Foundation
    6. Generic Me and My Life
    7. Organisations and People
    8. Organisations, People and Transactions
    9. Organisations,Members & Meetings
    10. Patient Care
    11. Reservations
    12. Shrek 2 Movie (Events & Places)
    13. Transport
    14. User-defined Hierarchies
  10. George Orwell's 1984
  11. Global Accountability
  12. Global Community
  13. Global Consulting
  14. Global Credit Crunch
  15. Global Crime
  16. Global Law Firm
  17. Global Project Management
  18. Global Reference Database
  19. Golf Club Management
  20. Golf Course Maintenance
  21. Golf Tournaments
  22. Google AdSense
  23. Google Android Phone Platform
  24. GRI Indicators
  25. GRI Repository
  26. GRI User's Portal
  27. Grocery Store
  28. Gym Training Diary
  29. Hairdressers Appointments
  30. Harbour Management
  31. Hardware Sales
  32. Health Centers
  33. Health Clubs
  34. Health Insurance Claims
  35. Help Desk
  36. Hierarchies & Trees
    1. Business Intelligence / MI
    2. Employees
    3. Management Hierarchies
    4. Organization Hierarchies
    5. Parties and Phones
    6. Preferences
    7. Product Hierarchies
    8. Reference Data Manager
    9. User-Defined Hierarchies
    10. Vehicle Parts Manufacture
    11. World Language Classification
      (with Oracle CONNECT BY)
  37. High School Football
  38. Highways Agency (UK)
  39. Hobbies and Pastimes
    1. Chess Tournaments
    2. Golf Tournaments
    3. Olympic Sports
    4. Swimming Clubs
    5. Sailing Clubs
  40. Holiday Homes
  41. Home Libraries
  42. Horse Racing
  43. Horse Racing and Betfair
  44. Hospice Patient Care
  45. Hospital Admissions
  46. Hospital Outpatients
  47. Hospitals and Patients for Noor
  48. Hotel Reservations
  49. HR or Personnel Department
  50. Houses and Rooms
  51. IAA Insurance Party
  52. Indigenous Peoples
  53. Icons of the Western World
  54. Industry Specific
    1. CRM and Customers
    2. e-Commerce
    3. Education
    4. Entertainment
    5. Health and Fitness
    6. Law Enforcement
    7. Students
    8. Transport and Travel
  55. Inheritance Models
    1. Charities
    2. City Tourist Guide
    3. CMDB - Configuration Mgt DB
    4. Customers Commercial and Personal
    5. Event Registrations
    6. Games Store
    7. Insurance Brokers
    8. Libraries for Lawyers
    9. National Trust (UK)
    10. NewEgg
    11. Photo Catalogs
    12. School Management Systems
    13. Shrek 2 Movie
    14. Tracking Manufactured Items
    15. Travel & Tourism Worldwide
    16. Vehicle Imports
  56. Insurance Brokers
  57. Insurance for Vehicles
  58. Insurance (Personal)
  59. Intelligent Environments
  60. Interior Design Companies
  61. Internet Music Radio Stations
  62. Inventory Control
    1. Inventory and Equipment Maintenance
    2. Inventory Control (Files in Boxes)
    3. Inventory Control (Manuals)
    4. Inventory Control (Publishing)
    5. Inventory Control (Retail Store)
    6. Inventory Control (Sports Centers)
    7. Inventory Control and Pricing
    8. Inventory of IT Assets
    9. Inventory of Rental Equipment
    10. Inventory of Servers
    11. Inventory of Ship's Stores
    12. Inventory of Tooling Equipment
  63. Investment Banking
  64. Invoices and Payments
  65. Issue Tracking (Software)
  66. ITIL - IT Infastructure Library
  67. Jewellery Stores
  68. Job Costing and Profitability
  69. Job Scheduling (Loading Data Warehouse)
  70. Job Scheduling (Services)
  71. Job Seekers Web Sites(Dice)
  72. Judges and Courts
  73. Justice Department
  74. Key Performance Indicators
  75. Kitchen Cabinets
  76. Knowledge Management
  77. Laboratory Management
  78. Land Registry
  79. Landscape Gardening
  80. Language Schools
  81. Law Enforcement
    1. Case Management
    2. Fingerprint Recognition
    3. Forensic Science Labs
    4. Global Crime
    5. Judges and Courts
    6. Justice Department
    7. Lawyers, Cases and Bills
    8. Libraries for Lawyers
    9. Offenders and Movements
    10. Parking Tickets
    11. Police Departments
    12. Police Generalized Data Model
    13. Police Information Reports
    14. Police Mobile Application
    15. Prisons and Prisoners
    16. Private Investigators
    17. Tracking Evidence
    18. Traffic Cops and Tickets
  82. Lawn Bowling Clubs
  83. LDAP New
  84. Legal Case Management
  85. Libraries
    1. Libraries Basic Model
    2. Libraries and Books
    3. Libraries of Digital Assets
    4. Libraries of Film Tapes
    5. Libraries of Sheet Music
    6. Libraries for Lawyers
    7. Libraries for Teachers
    8. Libraries for UK Schools
    9. Library Donations New
    10. My Library (for Amazon Web Svcs)
    11. OPAC - Library Catalog
    12. Virtual Library for MyLifeBits
  86. Licences and Permits
  87. Limousine Services
  88. Loan Management System
  89. Local Govt (UK)
  90. Logistics
  91. Long Term Accommodation
  92. LSC Framework for Excellence
  93. Magazine Subscriptions
  94. Mail System
  95. Maintenance Contracts :-
    1. For Products with no Parts
    2. For Products with Parts (Dezign)
  96. Making a Movie
  97. Manufacturing :-
    1. Aircraft Orders and Parts
    2. Assets Maintenance
    3. Bill of Materials
    4. Construction and Manufacturing
    5. Customer Purchases Data W'house
    6. Paper Manufacturing
    7. Product Catalogs
    8. Tracking Customer Orders
    9. Vehicle Maintenance
    10. Vehicle Parts Manufacture
  98. Maritime Models :-
    1. Freight Forwarders
    2. Harbour Management
    3. Marine Archeology
    4. Maritime Museums
    5. Scuba Diving
    6. Swimming Clubs
    7. US Navy
  99. Marriages
  100. Mashups
  101. Master Data Management
  102. Medical :-
    1. Blood Banks
    2. Cancer Screening New
    3. Dietician Practice
    4. Doctor's Practice
    5. Health Centers
    6. Health Insurance Claims
    7. Hospice Patient Care
    8. Hospital Admissions
    9. Hospital Outpatients
    10. Hospitals and Patients
    11. Medical Laboratories
    12. Mortuaries
    13. Natural Disease Treatments
    14. Nurses Roster
    15. Nursing Home
    16. Patient Care
    17. Pharmacies and Generics
    18. Pharmacies and Prescriptions
    19. Pharmaceuticals Data Warehouse
    20. Pharmaceutical Supplies
    21. Prescriptions Database
    22. Stop Smoking Services
    23. Symptoms and Diseases
  103. Medical Laboratories
  104. Message Board for a Web Site
  105. MetaData Management
  106. Middle East Conflict
  107. Mobile Police Application
  108. Modelling Agency
  109. Mortuaries
  110. MP3 Music Site
  111. Movie Making
  112. Multi-Level Marketing
  113. Multi-Media Publication
  114. Museums (Simple)
  115. Museums (Complex)
  116. Music Lovers Communities
  117. Music over the Internet
  118. Music Performance Royalties
  119. Musicians in Newspapers
  120. Musicians in a Band
  121. MVC Model-View-Controller
  1. My Life
  2. MyLifeBits Research
  3. My Work
  4. My Life and Work
  5. National Trust (UK)
  6. Native Peoples
  7. Natural Disease Treatments
  8. New Egg Web Site
  9. Newsagents
  10. Newsletters
  11. Not For Profits (NfPs/NPOs)
  12. Nurses Roster
  13. Nursing Home
  14. Offenders and Movements
  15. Offshore Drilling Equipment
  16. Olympic Sports
  17. Online Art Galleries
  18. Online Banking
  19. Online Gambling
  20. Online Scheduling
  21. OPAC Library Catalog
  22. Opticians
  23. Oracle Data Dictionary
  24. Oracle Database Rpt
  25. Oracle PL/SQL
  26. Orders and Parts
  27. Organic Vegetable Garden Planner
  28. Organisations and People
  29. Organisations and Transactions
  30. Organisations,Members & Meetings
  31. Package Delivery Service
  32. Paintings on Loan
  33. Parking Space Registration
  34. Parking Tickets
  35. Parties and Products
  36. Partners in a Firm
  37. Patient Care
  38. Payrolls
  39. Performance Monitoring
  40. Permits and Licences
  41. Personalization
  42. Personal Insurance
  43. Pest Control
  44. Pharmacies and Generics
  45. Pharmacies and Prescriptions
  46. Pharmaceuticals Data Warehouse
  47. Pharmaceutical Supplies
  48. Philip Greenspun's Communities
  49. Phone Bills
  50. Photo Catalogs (e-Commerce)
  51. Piano Tuners
  52. Picture Library
  53. Pizza Deliveries
  54. Plane Spotting
  55. Police Departments
  56. Pool League Statistics
  57. Police Generalized Data Model
  58. Police Information Reports
  59. Police Mobile Application
  60. Popkin System Architect :-
    1. Data Warehouse
    2. Data Dictionary
    3. Generic Customer Model
    4. Hotel Reservations
    5. National Trust Visitors
  61. Portals
  62. Portals and KPIs
  63. Prescriptions Database
  64. Preserved Railways
  65. Price Comparison Web Sites
  66. Prisons and Prisoners
  67. Products :-
    1. Bill of Materials
    2. Product Catalogs
    3. Product Categories
    4. Product Characteristics
    5. Product Distribution
    6. Products for Hire
    7. Product Hierarchies
    8. Product Servicing
    9. Products and Security
  68. Project Planning
  69. Project Staff
  70. Properties (National Trust)
  71. Properties (Real Estate)
  72. Property Development
  73. Proposals, Projects & Donors
  74. Pub Quiz League
  75. Pubs and Parties
  76. Public Transport
  77. Publish and Subscribe (Simple)
  78. Publish and Subscribe (Complex)
  79. Quantity Surveyors
  80. Quality of Life
  81. Questionnaires - Basic
  82. Questionnaires - Complex
  83. Questionnaires - Multiple Choice
  84. Questionnaires - for Marketing Surveys
  85. Railway Reservations
  86. Ratings and User Reviews
  87. Real Estate Agents
  88. Real Estate Rentals
  89. Real Estate Sales
  90. Real World Series
    1. Generic Real World
    2. Overview of the Real World
    3. Real World of Entertainment
    4. Real World of Insurance
  91. Recipes
  92. Record Label
  93. Recruitment Agencies
  94. Recycling and Garbage Collection
  95. Reference Database
  96. Reference Data Manager
  97. Refugees & Asylum Seekers
  98. Removals Companies
  99. Report Generators
  100. Reservations :-
    1. Apartment Rentals
    2. Airline Reservations
    3. Car Hire
    4. Cinema Bookings
    5. Coach Trips
    6. Driving School
    7. Event Reservations
    8. Hairdressers Appointments
    9. Health Centers
    10. Holiday Homes
    11. Hotel Reservations
    12. Limousine Services
    13. Online Scheduling
    14. Railway Reservations
    15. Restaurant Bookings
    16. Sports Centers
    17. Ticketmaster
    18. Vehicle Rental
  101. Resources Requesters
  102. Restaurant Bookings
  103. Restaurant Delivery Service
  104. Retail Customers
  105. Reviews and Ratings
  106. Risk Management (UML)
  107. Sailing Club
  108. Sales Commissions
  109. Salesforce
  110. Salesforce.dot.com
  111. Salesforce CDM Strategy
  112. Salesforce Data Integration
  113. Sales Promotion Analysis
  114. School Management Systems
  115. School Print Shops
  116. Schools Sports Tournaments
  117. Scientific Research
  118. Scuba Diving
  119. Search Engine
  120. Search for a Data Model
  121. Search for Musicians in Articles
  122. Search for Items in Newspapers
  123. Security Guards
  124. Septic Tanks
  125. Service Assessment
  126. Service Request Calls
  127. Services Job Scheduling
  128. Sewing Rooms
  129. Shopping Malls
  130. Show Business
    1. Ballet Companies
    2. CD Collection
    3. Circus
    4. Clown Registry
    5. Dance School
    6. Talent Agency
    7. Theater Company
    8. ticketmaster
  131. Shrek2 Movie
  132. Single View of a Customer
  133. Skills and Authorisations Stamps New
  134. Smart Cities and Global R and D
  135. Snowflake Design
  136. SOA
  137. Social Anthropology
    1. Coping with Life New
    2. Middle-East Conflict
    3. Quality of Life
    4. Usual Suspects New
  138. Social Capitalist Awards
  139. Social Networking Sites
  140. Social Workers Case Mgt
  141. Spam and Junk Mail
  142. Spatial Temporal Databases
  143. Sperm Banks
  144. Sports Card Collecting
  145. Sports Centers
  146. SQL Server 2008
  147. Staff Movements
  148. Star Design for Teaching Schedule
  149. Star Design for Transaction
  150. Stock Control
    1. Stock Control (Retail Store)
    2. Stock Control (Sports Centers)
  151. Stockmarket Data
  152. Stop Smoking Services
  153. Street Cleaning Schedules
  154. Street Traders
  155. Students :-
    1. Behavior Monitoring
    2. Church Sunday Schools
    3. Class Scheduling
    4. Credit Accumulation (Europe)
    5. e-Learning
    6. High School Football
    7. School Catering Businesses
    8. School Management Systems
    9. Schools Sports Tournaments
    10. Student Accommodation
    11. Student Assessments (Simple)
    12. Student Assessments (Complex)
    13. Student Assignments
    14. Student Athletes
    15. Student Exams
    16. Student Exams in Saudi
    17. Student Information Systems
    18. Student Loans
    19. Student Questionnaires
    20. Student Registration New
    21. Student Rosters
    22. Student Transcripts Tracking
    23. Student Work Placements
    24. University Course Catalogs
  156. Surveyors and Contacts
  157. Swimming Clubs
  158. Symptoms and Diseases
  159. Talent Agency
  160. Tanning Salons New
  161. Tax Receipts
  162. Taxi Service
  163. Technical PC Support
  164. Telephone Bills
  165. Tenant Contact Tracking
  166. Theater Company
  167. Ticketmaster
  168. Timesheets
  169. Tour Guides
  170. Tracking Customer Orders
  171. Tracking Evidence
  172. Tracking Grants for Research
  173. Tracking Grants for Skills Development
  174. Tracking Manufactured Items
  175. Tracking Share Transactions
  176. Tracking Software Problems
  177. Tracking Tenant Contacts
  178. Traffic Cops and Tickets
  179. Transport (Public)
  180. Transportation and Shipments
  181. Travel Agencies New
  182. Travel and Tourism Worldwide
  183. Treatments for Natural Diseases
  184. Trouble Tickets
  185. TV Electronic Programme Guides (EPGs)
  186. TV Talk Shows
  187. Tutorial on Database Schema
  188. UK e-Govt Standard Data
  189. UML Class Diagrams
  190. UN Global Compact
  191. Uniforms on Loan
  192. Union Grievances
  193. University Course Catalogs
  194. US Government Contracting
  195. US Government Organization
  196. Used Flutes Exchange
  197. User-Defined Hierarchies
  198. User-Extendable Database
  199. User-Extendable DataDictionary
  200. User Identity Management
    1. Customer Master Index
    2. LDAP New
    3. Single View of the Customer
    4. User Identity Management New
  201. User Portals
  202. User Portals and KPIs
  203. User Profiles
  204. User Reviews and Ratings
  205. User-Submitted Material
  206. Usual Suspects New
    1. Conflict and Wars New
    2. Football Clubs
    3. Fox Hunting New
    4. Wedding Parties
  207. Vegetable Garden Planner
  208. Vehicle Imports
  209. Vehicle Maintenance
  210. Vehicle Mileage Tracking
  211. Vehicle Parts Manufacture
  212. Vehicle Registration Authority
  213. Vehicle Rental
  214. Vertical Applications
    1. CRM and Customers
    2. e-Commerce
    3. Education
    4. Entertainment
    5. Health and Fitness
    6. Law Enforcement
    7. Students
    8. Transport and Travel
  215. Vets Practice
  216. Video Purchase
  217. Video Rental
  218. Volcanoes (Visio & Dezign)
  219. Voters and Elections
  220. Warehouse Inventory Management
  221. Waste Management
  222. Waste Skip Hire
  223. Water Bills
  224. Weather Reporting New
  225. Web 2.0
  226. Web Site for a Community
  227. Web Site for DBA Site
  228. Web Site Analytics
  229. Web Site Pages
  230. Web Site Registration
  231. Web Site Traffic Analysis
  232. Web Sites for Hobbies and Pastimes
  233. Weddings
  234. Wedding Parties New
  235. Weighbridge Operations
  236. Wildlife Parks
  237. Wills and Families
  238. Wine Cellars
  239. Wiring Diagrams
  240. Workflow
  241. Worksheets
  242. World Health Organization STD
  243. World Language Classification
  244. Youth Church
  245. Zip Codes in Mexico
  246. 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 each day 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. Here's a first draft of a page of French Data Models.
Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map