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.

Here are more than 750 very useful 'Kick-Start' Data Models that I have created since I started about 7 years ago,   and here's the Top 20

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. Accidents at Work
  3. Accident Management
  4. Accommodation (Long-term)
  5. Actions,Decisions,People & Property
  6. 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
  7. Afghanistan Encounters
  8. Afghanistan Rainfall
  9. Agents and Leads
  10. Agents Commissions
  11. Aircraft Parts and Orders
  12. Airline Reservations
  13. Airport Management
  14. Amazon and Starbucks
  15. Animal Shelters
  16. Animal Welfare
  17. Apartment Rentals
  18. Aquarium Stores
  19. Area Regulations
  20. Archeology
  21. Ars Digita BootCamp
  22. Art Galleries
  23. Art Galleries (Online)
  24. Assets Maintenance
  25. Asylum Seekers and Refugees
  26. Athletes and Events
  27. Athletes and Teams
  28. ATM Machines
  29. Auction Web Site
  30. Avon Cosmetics
  31. Baby-Sitters and Nannies
  32. Badminton Clubs
  33. Ballet Companies (Casting Productions)
  34. Ballet Companies (Org and People)
  35. Bands and Gigs
  36. '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
  37. Bank and Branches
  38. Banking (Online)
  39. Bankrupts
  40. Baseball Umpire Scheduling
  41. Basel II Accord
  42. BBC (UK)
  43. Behavior Monitoring
  44. Best Practice
  45. Best Practice and User Events
  46. Bidders and Buyers
  47. Bill of Materials
  48. Blogs
  49. Blood Banks
  50. BMEWS Data Architecture
  51. BMEWS Organization
  52. Boating Marinas
  53. Bookstore
  54. Bookstore and Warehouses
  55. Books and Libraries
  56. Botanical Gardens
  57. Boutiques
  58. Boy Scouts
  59. Breast Cancer Screening
  60. Business 2 Business e-Commerce
  61. Business 2 Consumer e-Commerce
  62. Business Directories
  63. Call Centers
  64. Canal Trips
  65. Cancer Screening
  66. Car Dealership
  67. Car Hire
  68. Car Park Security
  69. Car Parking Enforcement
  70. Car Parts Suppliers
  71. Carphone Warehouse
  72. Car Sales
  73. Car Service Center
  74. Case Management (Lawyers)
  75. Case Management (Social Workers)
  76. Casinos
  77. Catalogs of Products
  78. Catering Businesses for Schools
  79. Catering Services
  80. Catteries
  81. Cattle Breeding
  82. CD Collection
  83. CemetariesCensus Results
  84. Charities and Appeals
  85. Charities (Just Giving)
  86. Chess Tournaments
  87. 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. Childrens Common Assessment Framework
    7. Children's National Database
    8. 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
    12. Woot
  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
    7. Community Web Site
  113. Community Medical Centers
  114. Complaints and Feedback
  115. Competition Results
  116. Conference Centers
  117. Conference Proceedings
  118. Conservation of Historic Objects
  119. Construction and Manufacturing
  120. Construction Jobs Bidding
  121. Consultants and Clients
  122. Consultant Search Web Site
  123. Contacts and Products
  124. Contact Management
  125. Contract Management
  126. Contract Staff Agencies
  127. Corporate Intranet
  128. Cosmetics Home Sales
  129. Course Catalogs
  130. Cow's Events
  131. Consumer Packaged Goods (CPG)
  132. CraigsList
  133. Credit Accumulation (Europe)
  134. Crisis Call Centers
  135. CRM
  136. CSR Framework
  137. CVs and Job Histories (Visio)
  138. Dance School
  139. Data Architecture
  140. Data Dictionary
  141. Data Mart Case Studies
  142. Data Mashups
  143. 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)
  144. Databases for Life
  145. Dating Sites
  146. Day Care Centers
  147. Debt Collection
  148. Debt Management
  149. Defense Logistics
  150. Department Store
  151. Diabetes Diagnosis and Treatment
  152. Dietician's Consulting Practice
  153. Dictionaries for Foreign Languages
  154. Digital Challenge (UK)
  155. Diseases and Symptoms
  156. Doctor's Practice
  157. Document Control Systems
  158. Document Management
  159. Document Management (Specific)
  160. Document Publication
  161. Document Workflow
  162. Dog Kennels
  163. Dog Whisperer
  164. Domestic Violence Centers
  165. Donations :-
    1. Church Donations
    2. Library Donations
  166. Drivers Citations Log
  167. Driving School
  168. Driving Test Scores Database
  169. Dry Cleaners
  170. Education :-
    1. Educational Networks
    2. School Management Systems
    3. School Print Shops
    4. Schools Sports Tournaments
    5. Student Accommodation
    6. Student Activities
    7. Student Assessments (Simple)
    8. Student Assessments (Complex)
    9. Student Assignments
    10. Student Athletes and Teams
    11. Student Exams
    12. Student Exams in Saudi
    13. Student Information Systems
    14. Student Loans
    15. Student Registration
    16. Student Rosters
    17. Student Transcripts Tracking
    18. Student Work Placements
    19. University Course Catalogs
  171. eBay Deals
  172. 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
  173. e-Government
    1. UK e-Govt Standard Data
  174. e-Learning
  175. Elephant Sanctuaries
  176. Emergency Services
  177. Employees
  178. Employees Leave Records
  179. Employees Working at Home
  180. Employment Agencies
  181. Endangered Species
  182. Enterprise Data Mashups
  183. Enterprise Information Repository
    1. Data Migration Mapping
    2. Generation of Entities
    3. Glossary of Business terms
    4. Glossary with Queries
  184. Entertainment

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