Database Answers
Locations of visitors to this page
Home About Us Ask a Question Careers Clients Contact Us Data Models Tutorials 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.

There are over 900 very useful 'Kick-Start' Data Models that I have created since I started about 10 years ago,   and here's the Top 20
My Data Models are used in teaching Databases at the University of Cambridge
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 all around the world.
  1. Access Control
  2. Accident Management
  3. Accident Reports and Tickets
  4. Accidents at Work
  5. Accommodation (Long-term)
  6. Accounting Systems
  7. Actions,Decisions,People & Property
  8. Advertising
    1. Agencies
    2. Architecture for the Future
    3. Multi-Media Publications
    4. Publish and Subscribe (Complex)
    5. Publish and Subscribe (Simple)
    6. Advertising Systems
    7. Web Site Analytics
  9. Afghanistan Encounters
  10. Afghanistan Rainfall
  11. Agents and Leads
  12. Agents Commissions
  13. Air Transport
    1. Aircraft Parts and Orders
    2. Airline Reservations
    3. Airport Management
  14. Aircraft Parts and Orders
  15. Airline Reservations
  16. Airport Management
  17. Allotments
  18. Amazon and Starbucks
  19. Animal Shelters
  20. Animal Welfare
  21. Apartment Rentals
  22. Aquarium Stores
  23. Area Regulations
  24. Archeology
    1. Archeological Site Conservation
    2. Portable Antiquities Scheme
  25. Archimate Model for Insurance Claims
  26. Ars Digita BootCamp
  27. Art Exhibitions
  28. Art Galleries
  29. Art Galleries (Online)
  30. Asbestos Surveys
  31. Assets Maintenance
  32. Association Management
  33. Asylum Seekers and Refugees
  34. Athletes and Events
  35. Athletes and Teams
  36. ATM Machines
  37. Auction Web Site
  38. Audit of Projects
  39. Avon Cosmetics
  40. Baby-Sitters and Nannies
  41. Badminton Clubs
  42. Ballet Companies (Casting Productions)
  43. Ballet Companies (Org and People)
  44. Bands and Gigs
  45. 'Bang for the Buck' Models
    1. Customers and Orders
    2. Customers and Services
    3. Marriages (Contemporary)
    4. Marriages (Traditional)
    5. Organisations, People and Events
    6. Partnerships and Relationships
    7. Product Catalogs
    8. Reservations
  46. Bank and Branches
  47. Banking Acquisitions
  48. Banking Data Warehouses
  49. Banking (Online)
  50. Banking (Private)
  51. Bankrupts
  52. Baseball Umpire Scheduling
  53. Basel II Accord
  54. BBC (UK)
  55. Behavior Monitoring
  56. Best Practice
  57. Best Practice and User Events
  58. Bicycle Rental
  59. Bidders and Buyers
  60. Bikes and Customisation
  61. Bill of Materials
  62. Bills - Telephone
  63. Bills - for Utilities
  64. Bird Research
  65. Births, Deaths and Marriages
  66. Blogs
  67. Blood Banks
  68. BMEWS Data Architecture
  69. BMEWS Organization
  70. Boating Marinas
  71. Bookstore
  72. Bookstore and Warehouses
  73. Books and Libraries
  74. Botanical Gardens
  75. Boutiques
  76. Boy Scouts
  77. Breast Cancer Screening
  78. Breeding
    1. Cattle Breeding
    2. Dog Breeding
    3. Pigeon Breeding
  79. Brookfield Global Relocation Services
  80. Business 2 Business e-Commerce
  81. Business 2 Consumer e-Commerce
  82. Business Directories
  83. Call Centers
  84. Canal Trips
  85. Cancer Screening
  86. Canonical Data Models
  87. Car Dealership
  88. Car Hire
  89. Car insurance and Claims
  90. Car Park Security
  91. Car Parking Enforcement
  92. Car Parts Suppliers
  93. Car Sales
  94. Car Service Center
  95. Cardiac Catherization Registry
  96. Carphone Warehouse
  97. Case Management (Lawyers)
  98. Case Management (Social Workers)
  99. Casinos
  100. Catalogs of Products
  101. Catering Businesses for Schools
  102. Catering Services
  103. Catteries
  104. Cattle Breeding
  105. CD Collection
  106. CDL Drivers Medical Review
  107. Cell Apps Stores
  108. Cemetaries
  109. Census Results
  110. Charities and Appeals
  111. Charities (Just Giving)
  112. Chemical Dependency Providers
  113. Chess Tournaments
  114. Children ...
    1. Children and Families Support
    2. Children in Institutions (UNICEF)
    3. Children's Aid Rcds Mgt
    4. Children's Charities Flights
    5. Children's Clinics
    6. Children's Common Assessment Framework
    7. Childrens Lives
    8. Children's National Database
    9. Children's Playgroup
  115. Church Donations
  116. Church Members (Visio)
  117. Church Missionaries
  118. Church Praise Teams
  119. Church Sunday Schools
  120. Church (Youth)
  121. Cinema Bookings
  122. Circus
  123. Cirque du Soleil
  124. Citizens and Services
  125. City Councils
  126. City Hall Certificate Registration
  127. City Licences
  128. City Tourist Guide
  129. Click Stream Analysis
  130. Clients and Consultants
  131. Clients and Fees
  132. Clients and Locations
  133. Clinical Trials
  134. Clinics and Pharmacies
  135. Cloud Computing
  136. Clown Registry
  137. Club Members
  138. CMDB - Configuration Mgt DB
  139. Coach Trips
  140. Coding 4 Fun Projects
  141. Commercial Web Sites ...
    1. Avon Cosmetics
    2. Brookfield Global Relocation Services
    3. Cirque du Soleil
    4. Dice (Job Seekers Web Site)
    5. Dog Whisperer
    6. eBay Deals
    7. Financial Services Authority
    8. Gearhead Outfitters
    9. Gumtree
    10. IMDB (Internet Movie DB)
    11. Just Giving (Charity)
    12. Linked In
    13. MyLifeBits Research
    14. NewEgg
    15. Regus Office Accommodation
    16. SalesForce
    17. Shrek 2 Movie
    18. Star Craft 2 Game
    19. Ticketmaster
    20. Woot
    21. Yell (UK)
  142. Communities ...
    1. Community Groups and Workers
    2. FAQs and Newsletters
    3. Personalization
    4. Philip Greenspun
    5. Publish/Subscribe & KPI Portal
    6. User Registration
    7. Community Web Site
  143. Community Medical Centers
  144. Complaints and Feedback
  145. Competition Results
  146. Complex Event Processing
  147. Computer Sales (Dell)
  148. Conference Centers
  149. Conference Proceedings
  150. Conference Proceedings Management
  151. Conservation of Historic Objects
  152. Construction and Manufacturing
  153. Construction Jobs Bidding
  154. Consultants and Clients
  155. Consultant Search Web Site
  156. Consumer Packaged Goods (CPG)
  157. Contacts and Products
  158. Contact Management
  159. Container Shipping
  160. Contract Management
  161. Contract Staff Agencies
  162. Corporate Intranet
  163. Cosmetics Home Sales
  164. Course Catalogs
  165. Cow's Events
  166. CraigsList
  167. Credit Accumulation (Europe)
  168. Criminal Record Keeping
  169. Crisis Call Centers
  170. CRM
  171. CRUD - Create,Read,Update,Delete
  172. Cruise Liners and Passengers
  173. Cruise Ship Adminstration
  174. CSR Framework
  175. CVs and Job Histories (Visio)
  176. Dance School
  177. Data Architecture
  178. Data Dictionary
  179. Data Management ...
    1. Data Integration
  180. Data Mart Case Studies
  181. Data Mashups
  182. Data Warehouse ...
    1. Customers and Purchases
    2. eCommerce Data Warehouse
    3. Loading a Data Warehouse
    4. Data Warehouse Loading (Alt)
    5. Pharmaceuticals
    6. Snowflake Design for Transaction
    7. Star Design for Teaching Schedule
    8. Star Design for Transaction (Conceptual)
    9. Star Design for Transaction (Physical)
  183. Databases for Life
  184. Dating Sites
  185. Day Care Centers
  186. Debt Collection
  187. Debt Management
  188. Defense Logistics
  189. Dell Computer Sales
  190. Department Store
  191. Diabetes Diagnosis and Treatment
  192. Diet Decision Support System
  193. Dietician's Consulting Practice
  194. Dictionaries for Foreign Languages
  195. Digital Challenge (UK)
  196. Diseases and Symptoms
  197. Doctor's Practice
  198. Document Control Systems
  199. Document Management (Basic)
  200. Document Management Generic
  201. Document Management (Specific)
  202. Document Publication
  203. Document Template Management
  204. Document Workflow
  205. Dog Breeding
  206. Dog Kennels
  207. Dog Whisperer
  208. Domestic Violence Centers
  209. Donations :-
    1. Church Donations
    2. Library Donations
  210. Drinks in a Sports Bar
  211. Driver Recruitment Agencies
  212. Drivers Citations Log
  213. Drivers Education
  214. Driving School
  215. Driving Test Scores Database
  216. Dry Cleaners
  217. Earth-Moving Equipment
  218. Education :-
    1. Educational Networks
    2. School Management Systems
    3. School Print Shops
    4. Schools Sports Tournaments
    5. Student Accommodation
    6. Student Activities
    7. Student Applications
    8. Student Assessments (Simple)
    9. Student Assessments (Complex)
    10. Student Assignments
    11. Student Athletes and Teams
    12. Student Exams
    13. Student Exams in Saudi
    14. Student Information Systems
    15. Student Internships
    16. Student Loans
    17. Student Placements
    18. Student Registration
    19. Student Rosters
    20. Student Transcripts Tracking
    21. Student Work Placements
    22. University Course Catalogs
    23. University Gymnastics
  219. eBay Deals
  220. e-Commerce
    1. B2B e-Commerce
    2. B2C e-Commerce
    3. Customers, Campaigns and e-Commerce
    4. e-Commerce
    5. Games Web Site
    6. Online Art Galleries
    7. Orders & Shipments
    8. Photo Catalogs
    9. Shopping Carts
  221. e-Government
    1. UK e-Govt Standard Data
  222. e-Learning
  223. Elephant Sanctuaries
  224. Emergency Services
  225. Employees
  226. Employees Leave Records
  227. Employees Working at Home
  228. Employment Agencies
  229. Endangered Species
  230. Enterprise Data Mashups
  231. Enterprise Data Models
    1. Air Travel
    2. BMEWS BI
    3. Container Shipping
    4. Insurance
    5. Investment Banks
    6. Local Government
    7. Retail
  232. Enterprise Information Repository
    1. Data Migration Mapping
    2. Generation of Entities
    3. Glossary of Business Terms
    4. Glossary with Queries
  233. Entertainment
  234. Entity-Attribute-Value (EAV)

  235. Environmental Impact Assessment
  236. EPOS
  237. Equipment Maintenance
  238. Equipment Repair
  239. Estimating Development Costs
  240. ERP
  241. ERWin Models
    1. Circus
    2. Job Scheduling
    3. Museums (Complex)
    4. Not for Profits
    5. Organisations and People
    6. Organisations and Transactions
    7. Maritime Museums
    8. Photo Catalogs
    9. Real World of Entertainment
    10. Salesforce.com
    11. Salesforce Data Integration
    12. Shrek 2 Movie
    13. SOA (Service Oriented Architectures)
    14. Surveyors and Contacts
  242. Event Planning
  243. Event Processing (Complex)
  244. Event Registrations
  245. Event Reservations
  246. Events and Staff Training
  247. Events in a Cow's Life
  248. Experts and Questions
  249. Facebook and Social Networking Sites
  250. Facebook App Invitations
  251. Facilities Assignment
  252. Facilities and Inspections
  253. FAQs
  254. Families and Wills
  255. Family Advocacy
  256. Farm Management
  257. Farms and Cow's Events
  258. Fashion Boutiques
  259. Father of all Data Models
  260. Father of all Data Warehouses
  261. FBI Global Database
  262. Feedback
  263. Feedback and Complaints
  264. File Archiving Systems
  265. Financial Global Custody
  266. Financial Portals
  267. Financial Services Authority
  268. Fingerprint Recognition
  269. Fish Factory
  270. Fishing Industry
  271. Flights for Children's Charities
  272. Food Distribution
  273. Football Clubs
  274. Foreign Language Dictionaries
  275. Foreign Language Tournament Listings
  276. Forensic Science Labs
  277. Forklift Truck Servicing
  278. Fox Hunting
  279. Franchise Operators
  280. Freight Forwarders
  281. Fuel Coupons Mgt
  282. Fund Raising
  283. Funeral Homes
  284. Future of Databases
  1. Customers :-
    1. Clients and Fees
    2. Clients and Locations
    3. CRM
    4. Customer Management Systems
    5. Customers with multi-lingual B2C
    6. Customers at a Bank
    7. Customers at a Bank (retail)
    8. Customers at a Bookstore
    9. Customers at a Call Center
    10. Customers and Addresses
    11. Customers and Campaigns
    12. Customers and Car Hire
    13. Customers and Car Sales
    14. Customers and Car Servicing
    15. Customers and Credit Cards
    16. Customers and Dept Stores
    17. Customers and Deals (UML)
    18. Customers and Deliveries
    19. Customers and e-Commerce
    20. Customers and Games Shops
    21. Customers and Hairdressers
    22. Customers and Hardware Store
    23. Customers and Health Centres
    24. Customers and Insurance
    25. Customers and Invoices
    26. Customers and Jobs
    27. Customers and Loans
    28. Customers and Loyalty
    29. Customers and Memberships
    30. Customers and Online Banking
    31. Customers and Orders
    32. Customers and Partial Deliveries
    33. Customers and Payments (e-Gov't)
    34. Customers and Phone Bills
    35. Customers and Price Comparison Web Sites
    36. Customers and Products
    37. Customers and Purchases Data W'hse
    38. Customers and Retail
    39. Customers and Services (Basic)
    40. Customers and Services (Advanced)
    41. Customers and Shoppers Recommendations
    42. Customers and Telemarketing
    43. Customers and Water Bills
    44. Customer Class Scheduling
    45. Customers Comm & Personal
    46. Customer Data
    47. Customer Data Catalog
    48. Customer Journey Mapping
    49. Customers (Commercial & Personal)
    50. Customers (Retail)
    51. Customer MetaData Repository
    52. Customer Metrics
    53. Customer Order Tracking
    54. Generic Customer Model (Popkin)
  2. Gambling (Online)
  3. Gaming
    1. Games Features
    2. Games Store
    3. Gaming - Generic
    4. Gaming Leagues
    5. Gaming - Specific - Gears of War
    6. Gaming - Specific - Table Top
    7. Gaming Web Sites
    8. Shrek Movie
  4. Garbage Collection and Recycling
  5. Genealogy and Family Trees
  6. Generic Data Models
    1. Childrens Lives
    2. Circus (Events & Players)
    3. Customers and Services
    4. Document Management
    5. Father of All Models
    6. Generic Foundation
    7. Generic Me and My Life
    8. Organisations and People
    9. Organisations, People and Transactions
    10. Organisations,Members & Events
    11. Organisations,Members & Meetings
    12. Patient Care
    13. Reservations
    14. Retail
    15. Shrek 2 Movie (Events & Places)
    16. Transport
    17. User-defined Hierarchies
  7. George Orwell's 1984
  8. Global Accountability
  9. Global Community
  10. Global Consulting
  11. Global Credit Crunch
  12. Global Crime
  13. Global Custody
  14. Global Law Firm
  15. Global Project Management
  16. Global Relocation Services
  17. Global Reference Database
  18. Global Retail Marketing
  19. Golf Club Management
  20. Golf Course Maintenance
  21. Golf Course Maintenance Employee Tasks
  22. Golf Memorabilia
  23. Golf Tournaments
  24. Google AdSense
  25. Google Analytics
  26. Google Android Phone Platform
  27. Greyhound Training
  28. GRI Indicators
  29. GRI Repository
  30. GRI User's Portal
  31. Grocery Store
  32. Grocery Store Shelves
  33. Gumtree
  34. Gym Training Diary
  35. Hairdressers Appointments
  36. Harbour Management
  37. Hardware Sales
  38. Hazard Management
  39. Health Centers
  40. Health Clubs
  41. Health Insurance Claims
  42. Help Desk
  43. 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)
  44. High School Football
  45. Highways Agency (UK)
  46. Hobbies and Pastimes
    1. Chess Tournaments
    2. Golf Tournaments
    3. Olympic Games
    4. Olympic Sports
    5. Swimming Clubs
    6. Sailing Clubs
  47. Holiday Homes
  48. Home Libraries
  49. Horse Racing
  50. Horse Racing and Betfair
  51. Hospice Patient Care
  52. Hospital Admissions
  53. Hospital Outpatients
  54. Hospitals and Patients for Noor
  55. Hotel Reservations
  56. Hotels and Tourist Attractions
  57. HR or Personnel Department
  58. Houses and Rooms
  59. IAA Insurance Party
  60. Icons of the Western World
  61. IMDB (Internet Movie DB)
  62. Import/Export Logistics
  63. Importing Client Data
  64. Indigenous Peoples
  65. 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
  66. Inheritance Models
    1. Births, Deaths and Marriages
    2. Charities
    3. City Tourist Guide
    4. CMDB - Configuration Mgt DB
    5. Customers Commercial and Personal
    6. Event Registrations
    7. Games Store
    8. Icons of the Western World
    9. Insurance Brokers
    10. Libraries for Lawyers
    11. My Work
    12. National Trust (UK)
    13. NewEgg
    14. Photo Catalogs
    15. Roles Inheritance and Subtypes
    16. School Management Systems
    17. Shrek 2 Movie
    18. Tracking Manufactured Items
    19. Travel & Tourism Worldwide
    20. Union Grievances
    21. Vehicle Imports
  67. Inspections of Facilities
  68. Insurance
    1. Insurance Applications
    2. Insurance Brokers
    3. Insurance and eClaims
    4. Insurance Policies - Car, Home and Life
    5. Insurance Claims (in Archimate)
    6. Insurance Data Warehouses
    7. Insurance (General)
    8. Insurance (Personal)
    9. Insurance Policies and Claims
  69. Intelligent Environments
  70. Intelligent Transport Systems
  71. Internet Music Radio Stations
  72. 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 Furniture
    9. Inventory of IT Assets
    10. Inventory of Rental Equipment
    11. Inventory of Servers
    12. Inventory of Ship's Stores
    13. Inventory of Tooling Equipment
  73. Investment Banking
    1. Accounts
    2. Customers
    3. Financial Services Authority
    4. FX Deals
    5. Global Custody
    6. Settlements
  74. Invoices and Payments
  75. Issue Tracking (Software)
  76. ITIL - IT Infastructure Library
  77. Jewellery Stores
  78. Job Costing and Profitability
  79. Job Scheduling (Loading Data Warehouse)
  80. Job Scheduling (Services)
  81. Job Seekers Web Sites(Dice)
  82. Judges and Courts
  83. Justice Department
  84. Key Performance Indicators
  85. Kitchen Cabinets
  86. Knowledge Management
  87. Laboratory Management
  88. Land Registry
  89. Landscape Gardening
  90. Language Schools
  91. 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 MDM Data Model
    15. Mobile Apps Stores
    16. Police Mobile Application
    17. Prisons and Prisoners
    18. Private Investigators
    19. Tracking Evidence
    20. Traffic Cops and Tickets
  92. Lawn Bowling Clubs
  93. LDAP
  94. Legal Case Management
  95. Libraries
    1. Libraries Basic Model
    2. Libraries and Books
    3. Libraries of Digital Assets
    4. Libraries of Film Tapes
    5. Libraries of Media Items
    6. Library for Haidar Salim in Iraq
    7. Libraries of Sheet Music
    8. Libraries for Lawyers
    9. Libraries for Teachers
    10. Libraries for UK Schools
    11. Library Donations
    12. My Library (for Amazon Web Svcs)
    13. OPAC - Library Catalog
    14. Virtual Library for MyLifeBits
  96. Licences and Permits
  97. Lifecycle of a Sale
  98. Linked In
  99. Limousine Services
  100. Loading a Data Warehouse
  101. Loading a Data Warehouse (Alternate)
  102. Loan Management System
  103. Loan Management Consolidation
  104. Local Favourites
  105. Local Govt (UK)
  106. Local History Societies
  107. Logistics :-
    1. Corporate
    2. Defense
    3. Freight Forwarders
    4. Movements
    5. Shipments
    6. Ships Stores
  108. Long Term Accommodation
  109. Lost and Found Pets
  110. Loyalty and Customers
  111. LSC Framework for Excellence
  112. Machinery Diagnostics
  113. Magazine Subscriptions
  114. Mail System
  115. Maintenance Contracts :-
    1. For Products with no Parts
    2. For Products with Parts (Dezign)
  116. Making a Movie
  117. Making a Movie (for Beginners)
  118. 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 Manufacturers
    11. Vehicle Parts Manufacture
  119. Maritime Models :-
    1. Freight Forwarders
    2. Harbour Management
    3. Marine Archeology
    4. Maritime Museums
    5. Scuba Diving
    6. Swimming Clubs
    7. US Navy
  120. Marriages
  121. Mashups
  122. Matching Writers Names
  123. Master Data Management
  124. Me and Mommy
  125. Me and Mommy (a Tutorial)
  126. Media Libraries
  127. Medical :-
    1. Blood Banks
    2. Cancer Screening
    3. Community Medical Centers
    4. Dietician Practice
    5. Doctor's Practice
    6. Health Centers
    7. Health Insurance Claims
    8. Hospice Patient Care
    9. Hospital Admissions
    10. Hospital Outpatients
    11. Hospitals and Patients
    12. Medical Centers (Community)
    13. Medical Clinics and Pharmacies
    14. Medical Laboratories
    15. Medical Laboratories with Payments
    16. Mortuaries
    17. Natural Disease Treatments
    18. Nurses Roster
    19. Nursing Home
    20. Patient Care
    21. Patient Data Warehouse
    22. Patient Tests
    23. Patients Visits to the Doctor
    24. Pharmacies and Generics
    25. Pharmacies and Prescriptions
    26. Pharmaceuticals Data Warehouse
    27. Pharmaceutical Supplies
    28. Prescriptions Database
    29. Stop Smoking Services
    30. Symptoms and Diseases
  128. Medical Laboratories
  129. Mentoring Naval Officers
  130. Message Board for a Web Site
  131. MetaData Management
  132. MetaData Repositories
  133. MetaData Repository (Customer Data)
  134. Middle East Conflict
  135. Missionaries
  136. Mobile Police Application
  137. Modelling Agency
  138. Money Exchange for Students
  139. Mortuaries
  140. MP3 Music Site
  141. Movie Making
  142. Multi-Level Marketing
  143. Multi-Media Publication
  144. Multi-Resource Scheduling
  145. Museums (Simple)
  146. Museums (Complex)
  147. Music Lovers Communities
  148. Music over the Internet
  149. Music Performance Royalties
  150. Musicians, Bands and Gigs
  151. Musicians in Newspapers
  152. Musicians in a Band
  153. Musicians Uniforms
  154. MVC Model-View-Controller
  155. myDBA User Interface
  156. My Simple Life
  157. MyLifeBits Research
  158. My Work
  159. My Life and Work
  160. National Trust (UK)
  161. Native Peoples
  162. Natural Disease Treatments
  163. New Egg Web Site
  164. Newsagents
  165. Newsletters
  166. Newsstands
  167. Night Clubs
  168. Nomadic Tribes
  169. Not For Profits (NfPs/NPOs)
  170. Nurses Roster
  171. Nursing Home
  1. My Life
  2. Offenders and Movements
  3. Office Accommodation (Regus)
  4. Offshore Drilling Equipment
  5. Olympic Games
  6. Olympic Sports
  7. Online Art Galleries
  8. Online Banking
  9. Online Gambling
  10. Online Scheduling
  11. OPAC Library Catalog
  12. Opticians
  13. Oracle Data Dictionary
  14. Oracle Database Rpt
  15. Oracle PL/SQL
  16. Orders and Parts
  17. Organic Vegetable Garden Planner
  18. Organisations and People
  19. Organisations and Transactions
  20. Organisations, Meetings and Minutes
  21. Organisations,Members & Meetings
  22. Package Delivery Service
  23. Paintings on Loan
  24. Parking Space Registration
  25. Parking Tickets
  26. Parties and Products
  27. Partners in a Firm
  28. Partnerships and Relationships
  29. Parts and Distributers
  30. Passengers on a Cruise
  31. Patient Care
  32. Patient Tests
  33. Payrolls
  34. Performance Monitoring
  35. Permits and Licences
  36. Personalization
  37. Personal Insurance
  38. Pest Control
  39. Pharmacies and Generics
  40. Pharmacies and Prescriptions
  41. Pharmaceuticals Data Warehouse
  42. Pharmaceutical Supplies
  43. Philip Greenspun's Communities
  44. Phone Bills
  45. Photo Catalogs (e-Commerce)
  46. Piano Tuners
  47. Picture Library
  48. Pigeon Breeding
  49. Pizza Deliveries
  50. Plane Spotting
  51. Planets in the Solar System
  52. Police Departments
  53. Police Generalized Data Model
  54. Police Information Reports
  55. Police MDM Data Model
  56. Police Mobile Application
  57. Pool Hall Management
  58. Pool League Statistics
  59. Popkin System Architect :-
    1. Data Warehouse
    2. Data Dictionary
    3. Generic Customer Model
    4. Hotel Reservations
    5. National Trust Visitors
  60. Portals
    1. Financial Portals
    2. Publish and Subscribe
    3. Users and Portals
    4. Web Portal Navigation
  61. Prescriptions Database
  62. Preserved Railways
  63. Price Comparison Web Sites
  64. Printer Cartridge Tracking
  65. Prisons and Prisoners
  66. Private Banking
  67. Products :-
    1. Bill of Materials
    2. Product Catalogs (Simple)
    3. Product Catalogs (Complex)
    4. Product Catalogs for Paint
    5. Product Categories
    6. Product Characteristics
    7. Product Distribution
    8. Product Hierarchies
    9. Product Servicing
    10. Products and Manufacturers
    11. Products and Pricing
    12. Products and Security
    13. Products for Hire
    14. Products, Orders and Deliveries
  68. Product Catalogs (Commercial) :-
    1. Hotel Chocolat
    2. Comvita
    3. TK Maxx
    4. Wine Lists
  69. Project Audits
  70. Project Mgt Methodologies
  71. Project Planning
  72. Project Staff
  73. Properties (National Trust)
  74. Properties (Real Estate)
  75. Property Development
  76. Property Tax Appeals
  77. Proposals, Projects & Donors
  78. Pub Quiz League
  79. Pubs and Parties
  80. Public Transport
  81. Publish and Subscribe (Simple)
  82. Publish and Subscribe (Complex)
  83. Purchase Orders
  84. Purchase Orders for Cars
  85. Quantity Surveyors
  86. Quality of Life
  87. Questionnaires - Basic
  88. Questionnaires - Complex
  89. Questionnaires - Multiple Choice
  90. Questionnaires - for Marketing Surveys
  91. Radio Stations
  92. Railway Reservations
  93. Ratings and User Reviews
  94. Real Estate Agents
  95. Real Estate Rentals
  96. Real Estate Sales
  97. Real World Series
    1. Generic Real World
    2. Overview of the Real World
    3. Real World of Entertainment
    4. Real World of Insurance
  98. Recipes
  99. Record Label
  100. Recruitment Agencies
  101. Recruitment Agencies (Drivers)
  102. Recycling and Garbage Collection
  103. Reference Database
  104. Reference Data Manager
  105. Refugees & Asylum Seekers
  106. Removals Companies
  107. Repair of Equipment
  108. Report Generators
  109. Reservations :-
    1. Apartment Rentals
    2. Airline Reservations
    3. Car Hire
    4. Cinema Bookings
    5. Coach Trips
    6. Doctors Practice
    7. Driving School
    8. Event Reservations
    9. Flights for Children's Charities
    10. Generic Reservations
    11. Hairdressers Appointments
    12. Health Centers
    13. Holiday Homes
    14. Hotel Reservations
    15. Limousine Services
    16. Multi-Resource Scheduling
    17. Online Scheduling
    18. Pool Hall Management
    19. Railway Reservations
    20. Restaurant Bookings
    21. Restaurant Events Bookings
    22. Sports Centers
    23. Ticketmaster
    24. Vehicle Rental
  110. Resources Requesters
  111. Restaurant Bookings
  112. Restaurant Delivery Service
  113. Restaurant Events Bookings
  114. Retail Banks
  115. Retail Customers
  116. Reviews and Ratings
  117. Risk Management (UML)
  118. Roles Inheritance and Subtypes
  119. Rose's Cantina
  120. Sailing Club
  121. Sales Commissions
  122. Sales (Computer - Dell)
  123. Salesforce
  124. Salesforce.dot.com
  125. Salesforce CDM Strategy
  126. Salesforce Data Integration
  127. Sales Lifecycle
  128. Sales Promotion Analysis
  129. School Management Systems
  130. School Print Shops
  131. Schools Sports Tournaments
  132. Scientific Research
  133. Scuba Diving
  134. Search Engine
  135. Search for a Data Model
  136. Search for Musicians in Articles
  137. Search for Items in Newspapers
  138. Security Guards
  139. Septic Tanks
  140. Service Assessment
  141. Service Call Tracking
  142. Service Magic Professionals
  143. Service Request Calls
  144. Services Job Scheduling
  145. Sewing Rooms
  146. Shipping Companies
  147. Shipment Logistics
  148. Ships Stores Logistics
  149. Shoppers Recommendations
  150. Shopping Malls
  151. Show Business
    1. Ballet Companies
    2. CD Collection
    3. Circus
    4. Clown Registry
    5. Dance School
    6. Talent Agency
    7. Theater Company
    8. Theme Park and Visitor Activity
    9. ticketmaster
  152. Showpiece Models
    1. Generic Retail
    2. Inventory of Furniture
  153. Shrek2 Movie
  154. Single View of a Customer
  155. Skills and Authorisations Stamps
  156. Skills Tracking
  157. Smart Cities and Global R and D
  158. Snowflake Design
  159. SOA
  160. Social Anthropology
    1. Coping with Life
    2. Middle-East Conflict
    3. Quality of Life
    4. Usual Suspects
  161. Social Capitalist Awards
  162. Social Networking Sites
  163. Social Workers Case Mgt
  164. Soil Type Classifications
  165. Spam and Junk Mail
  166. Spatial Temporal Databases
  167. Special Needs Placements
  168. Sperm Banks
  169. Sports Card Collecting
  170. Sports Centers
  171. Spreadsheet Reports
  172. SQL Server 2008
  173. Staff Movements
  174. Starcraft 2
  175. Star Design for Teaching Schedule
  176. Star Design for Transaction
  177. Stock Control
    1. Stock Control (Retail Store)
    2. Stock Control (Sports Centers)
  178. Stockmarket Data
  179. Stop Smoking Services
  180. Street Cleaning Schedules
  181. Street Traders
  182. Students :-
    1. Achievements and Assessments
    2. Behavior Monitoring
    3. Church Sunday Schools
    4. Class Scheduling
    5. Credit Accumulation (Europe)
    6. e-Learning
    7. High School Football
    8. School Catering Businesses
    9. School Management Systems
    10. Schools Sports Tournaments
    11. School Timetables
    12. Student Accommodation
    13. Student Activities
    14. Student Applications
    15. Student Assessments (Simple)
    16. Student Assessments (Complex)
    17. Student Assignments
    18. Student Athletes
    19. Student Exams
    20. Student Exams in Saudi
    21. Student Information Systems
    22. Student Internships
    23. Student Loans
    24. Student Placements
    25. Student Questionnaires
    26. Student Registration
    27. Student Rosters
    28. Student Transcripts Tracking
    29. Student Work Placements
    30. University Course Catalogs
    31. University Gymnastics
  183. Surveyors and Contacts
  184. Suggestions Schemes
  185. Swimming Clubs
  186. Swiss Census
  187. Symptoms and Diseases
  188. System Architect :-
    1. Data Warehouse
    2. Data Dictionary
    3. Generic Customer Model
    4. Hotel Reservations
    5. National Trust Visitors
  189. Talent Agency
  190. Tanning Salons
  191. Task Logs (Knowledge Management)
  192. Tax Receipts
  193. Taxi Service
  194. Technical PC Support
  195. Telecomms
  196. Telemarketing
  197. Telephone Bills
  198. Tenant Contact Tracking
  199. Tennis Club Management
  200. Theater Company
  201. Theme Park and Visitor Activity
  202. Ticketmaster
  203. Timesheets
  204. Tour Guides
  205. Tracking :-
    1. Tracking Customer Orders
    2. Tracking Evidence
    3. Tracking Grants for Research
    4. Tracking Grants for Skills Development
    5. Tracking Machines and Counters
    6. Tracking Manufactured Items
    7. Tracking Manufacturers Orders
    8. Tracking Printer Cartridges
    9. Tracking Property Tax Appeals
    10. Tracking Share Transactions
    11. Tracking Software Problems
    12. Tracking Software Registration
    13. Tracking Tenant Contacts
  206. Traffic Cops and Tickets
  207. Travel and Transport :-
    1. Container Shipping
    2. Tour Guides
    3. Transport (Public)
    4. Transportation and Shipments
    5. Travel Agencies
    6. Travel and Tourism Worldwide
    7. Travel Company Complaints
  208. Treatments for Natural Diseases
  209. Trouble Tickets
  210. TV Electronic Programme Guides (EPGs)
  211. TV Talk Shows
  212. Tutorial on Database Schema
  213. Ubiquitous Data
  214. UK e-Govt Standard Data
  215. UML Class Diagrams
  216. UN Global Compact
  217. Uniforms on Loan
  218. Union Grievances
  219. University Course Catalogs
  220. University Gymnastics
  221. US Government Contracting
  222. US Government Organization
  223. Used Flutes Exchange
  224. User-Defined Hierarchies
  225. User-Extendable Database
  226. User-Extendable DataDictionary
  227. User Identity Management
    1. Customer Master Index
    2. LDAP
    3. Single View of the Customer
    4. User Identity Management
  228. User Groups
  229. User Portals
  230. User Portals and KPIs
  231. User Profiles
  232. User Reviews and Ratings
  233. User-Submitted Material
  234. Usual Suspects
    1. Conflict and Wars
    2. Football Clubs
    3. Fox Hunting
    4. Wedding Parties
  235. Vegetable Garden Planner
  236. Vehicle Imports
  237. Vehicle Maintenance
  238. Vehicle Mileage Tracking
  239. Vehicle Manufacturers
  240. Vehicle Parts Manufacture
  241. Vehicle Registration Authority
  242. Vehicle Rental
  243. Vehicle Tracking
  244. 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
  245. Vets Practice
  246. Video Purchase
  247. Video Rental Stores
  248. Virus Research
  249. Volcanoes (Visio & Dezign)
  250. Voters and Elections
  251. Warehouse Inventory Management
  252. Waste Management
  253. Waste Skip Hire
  254. Water Bills
  255. Weather Reporting
  256. Web 2.0
  257. Web Portal Navigation
  258. Web Site for a Community
  259. Web Site for DBA Site
  260. Web Site Analytics
  261. Web Site Pages
  262. Web Site Registration
  263. Web Site Traffic Analysis
  264. Web Sites for Hobbies and Pastimes
  265. Weddings
  266. Wedding Parties
  267. Weighbridge Operations
  268. Wildlife Parks
  269. Wills and Families
  270. Wine Cellars
  271. Wine, Food and Merchants
  272. Wine Lists
  273. Wiring Diagrams
  274. Woot
  275. Workflow
  276. Worksheets
  277. World Health Organization STD
  278. World Language Classification
  279. Yell (UK)
  280. Youth Church
  281. Zip Codes in Mexico
  282. 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.
About Us Contact Us