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. Access Control Accidents at Work Accident Management Accommodation (Long-term) Actions,Decisions,People & Property Advertising Agencies Architecture for the Future Multi-Media Publications Publish and Subscribe (Complex) Publish and Subscribe (Simple) Advertising Systems Web Site Analytics Afghanistan Encounters Afghanistan Rainfall Agents and Leads Agents Commissions Aircraft Parts and Orders Airline Reservations Airport Management Amazon and Starbucks Animal Shelters Animal Welfare Apartment Rentals Aquarium Stores Area Regulations Archeology Ars Digita BootCamp Art Galleries Art Galleries (Online) Assets Maintenance Asylum Seekers and Refugees Athletes and Events Athletes and Teams ATM Machines Auction Web Site Avon Cosmetics Baby-Sitters and Nannies Badminton Clubs Ballet Companies (Casting Productions) Ballet Companies (Org and People) Bands and Gigs 'Bang for the Buck' Models Catalogs of Products Customers and Products Customers and Services Marriages (Contemporary) Marriages (Traditional) Partnerships and Relationships Product Catalogs Generic Foundation Reservations Bank and Branches Banking (Online) Bankrupts Baseball Umpire Scheduling Basel II Accord BBC (UK) Behavior Monitoring Best Practice Best Practice and User Events Bidders and Buyers Bill of Materials Blogs Blood Banks BMEWS Data Architecture BMEWS Organization Boating Marinas Bookstore Bookstore and Warehouses Books and Libraries Botanical Gardens Boutiques Boy Scouts Breast Cancer Screening Business 2 Business e-Commerce Business 2 Consumer e-Commerce Business Directories Call Centers Canal Trips Cancer Screening Car Dealership Car Hire Car Park Security Car Parking Enforcement Car Parts Suppliers Carphone Warehouse Car Sales Car Service Center Case Management (Lawyers) Case Management (Social Workers) Casinos Catalogs of Products Catering Businesses for Schools Catering Services Catteries Cattle Breeding CD Collection CemetariesCensus Results Charities and Appeals Charities (Just Giving) Chess Tournaments Children ... Children and Families Support Children in Institutions (UNICEF) Children's Aid Rcds Mgt Children's Charities Flights Children's Clinics Childrens Common Assessment Framework Children's National Database Children's Playgroup Church Donations Church Members (Visio) Church Praise Teams Church Sunday Schools Church (Youth) Cinema Bookings Circus Cirque du Soleil Citizens and Services City Councils City Hall Certificate Registration City Licences City Tourist Guide Click Stream Analysis Clients and Consultants Clients and Fees Clients and Locations Clinical Trials Clown Registry Club Members CMDB - Configuration Mgt DB Coach Trips Commercial Web Sites ... Avon Cosmetics Cirque du Soleil Dice (Job Seekers Web Site) Dog Whisperer eBay Deals Just Giving (Charity) MyLifeBits Research NewEgg SalesForce Shrek 2 Movie Ticketmaster Woot Coding 4 Fun Projects Communities ... Community Groups and Workers FAQs and Newsletters Personalization Philip Greenspun Publish/Subscribe & KPI Portal User Registration Community Web Site Community Medical Centers Complaints and Feedback Competition Results Conference Centers Conference Proceedings Conservation of Historic Objects Construction and Manufacturing Construction Jobs Bidding Consultants and Clients Consultant Search Web Site Contacts and Products Contact Management Contract Management Contract Staff Agencies Corporate Intranet Cosmetics Home Sales Course Catalogs Cow's Events Consumer Packaged Goods (CPG) CraigsList Credit Accumulation (Europe) Crisis Call Centers CRM CSR Framework CVs and Job Histories (Visio) Dance School Data Architecture Data Dictionary Data Mart Case Studies Data Mashups Data Warehouse ... Customers and Purchases eCommerce Data Warehouse Loading a Data Warehouse Pharmaceuticals Snowflake Design for Transaction Star Design for Teaching Schedule Star Design for Transaction (Conceptual) Star Design for Transaction (Physical) Databases for Life Dating Sites Day Care Centers Debt Collection Debt Management Defense Logistics Department Store Diabetes Diagnosis and Treatment Dietician's Consulting Practice Dictionaries for Foreign Languages Digital Challenge (UK) Diseases and Symptoms Doctor's Practice Document Control Systems Document Management Document Management (Specific) Document Publication Document Workflow Dog Kennels Dog Whisperer Domestic Violence Centers Donations :- Church Donations Library Donations Drivers Citations Log Driving School Driving Test Scores Database Dry Cleaners Education :- Educational Networks School Management Systems School Print Shops Schools Sports Tournaments Student Accommodation Student Activities Student Assessments (Simple) Student Assessments (Complex) Student Assignments Student Athletes and Teams Student Exams Student Exams in Saudi Student Information Systems Student Loans Student Registration Student Rosters Student Transcripts Tracking Student Work Placements University Course Catalogs eBay Deals e-Commerce B2B e-Commerce B2C e-Commerce Customers, Campaigns and e-Commerce Games Web Site Orders & Shipments Photo Catalogs Shopping Carts e-Government UK e-Govt Standard Data e-Learning Elephant Sanctuaries Emergency Services Employees Employees Leave Records Employees Working at Home Employment Agencies Endangered Species Enterprise Data Mashups Enterprise Information Repository Data Migration Mapping Generation of Entities Glossary of Business terms Glossary with Queries Entertainment Environmental Impact Assessment EPOS Equipment Maintenance Estimating Development Costs ERP Event Registrations Event Reservations Events in a Cow's Life Experts and Questions FAQs Families and Wills Family Advocacy Farm Management Farms and Cow's Events Fashion Boutiques Father of all Data Models FBI Global Database Feedback and Complaints File Archiving Systems Financial Portals Fingerprint Recognition Fish Factory Fishing Industry Flights for Children's Charities Food Distribution Football Clubs Foreign Language Dictionaries Foreign Language Tournament Listings Forensic Science Labs Forklift Truck Servicing Fox Hunting Franchise Operators Freight Forwarders Fuel Coupons Mgt Fund Raising Funeral Homes Customers :- Clients and Fees Clients and Locations CRM Call Centers Customer Metrics Marketing Data Marketing Data Architecture Microsoft Dynamics CRM Personalization Top-Level Data Model Template for a Source Systems Data Dictionary Customers with multi-lingual B2C Customers at a Bank Customers at a Bookstore Customers at a Call Center Customers and Addresses Customers and Campaigns Customers and Car Hire Customers and Car Sales Customers and Car Servicing Customers and Credit Cards Customers and Dept Stores Customers and Deals (UML) Customers and Deliveries Customers and e-Commerce Customers and Games Shops Customers and Hairdressers Customers and Hardware Store Customers and Health Centres Customers and Insurance Customers and Invoices Customers and Loans Customers and Online Banking Customers and Orders Customers and Partial Deliveries Customers and Payments (e-Gov't) Customers and Phone Bills Customers and Price Comparison Web Sites Customers and Products Customers and Purchases Data W'hse Customers and Retail Customers and Services Customers and Water Bills Customer Class Scheduling Customers Comm & Personal Customer Data Customer Data Catalog Customer Journey Mapping Customers (Commercial & Personal) Customer MetaData Repository Customer Metrics Customer Order Tracking Generic Customer Model (Popkin) Future of Databases Gambling (Online) Games Features Games Store Gaming Leagues Garbage Collection and Recycling Genealogy and Family Trees Generic Data Models Circus (Events & Players) Customers and Services Document Management Father of All Models Generic Foundation Generic Me and My Life Organisations and People Organisations, People and Transactions Organisations,Members & Meetings Patient Care Reservations Shrek 2 Movie (Events & Places) Transport User-defined Hierarchies George Orwell's 1984 Global Accountability Global Community Global Consulting Global Credit Crunch Global Crime Global Law Firm Global Project Management Global Reference Database Golf Club Management Golf Course Maintenance Golf Tournaments Google AdSense Google Analytics Google Android Phone Platform GRI Indicators GRI Repository GRI User's Portal Grocery Store Gym Training Diary Hairdressers Appointments Harbour Management Hardware Sales Hazard Management Health Centers Health Clubs Health Insurance Claims Help Desk Hierarchies & Trees Business Intelligence / MI Employees Management Hierarchies Organization Hierarchies Parties and Phones Preferences Product Hierarchies Reference Data Manager User-Defined Hierarchies Vehicle Parts Manufacture World Language Classification (with Oracle CONNECT BY) High School Football Highways Agency (UK) Hobbies and Pastimes Chess Tournaments Golf Tournaments Olympic Sports Swimming Clubs Sailing Clubs Holiday Homes Home Libraries Horse Racing Horse Racing and Betfair Hospice Patient Care Hospital Admissions Hospital Outpatients Hospitals and Patients for Noor Hotel Reservations HR or Personnel Department Houses and Rooms IAA Insurance Party Indigenous Peoples Icons of the Western World Industry Specific CRM and Customers e-Commerce Education Entertainment Health and Fitness Law Enforcement Students Transport and Travel Inheritance Models Charities City Tourist Guide CMDB - Configuration Mgt DB Customers Commercial and Personal Event Registrations Games Store Insurance Brokers Libraries for Lawyers National Trust (UK) NewEgg Photo Catalogs School Management Systems Shrek 2 Movie Tracking Manufactured Items Travel & Tourism Worldwide Vehicle Imports Insurance Brokers Insurance for Vehicles Insurance (Personal) Intelligent Environments Interior Design Companies Internet Music Radio Stations Inventory Control Inventory and Equipment Maintenance Inventory Control (Files in Boxes) Inventory Control (Manuals) Inventory Control (Publishing) Inventory Control (Retail Store) Inventory Control (Sports Centers) Inventory Control and Pricing Inventory of IT Assets Inventory of Rental Equipment Inventory of Servers Inventory of Ship's Stores Inventory of Tooling Equipment Investment Banking Invoices and Payments Issue Tracking (Software) ITIL - IT Infastructure Library Jewellery Stores Job Costing and Profitability Job Scheduling (Loading Data Warehouse) Job Scheduling (Services) Job Seekers Web Sites(Dice) Judges and Courts Justice Department Key Performance Indicators Kitchen Cabinets Knowledge Management Laboratory Management Land Registry Landscape Gardening Language Schools Law Enforcement Case Management Fingerprint Recognition Forensic Science Labs Global Crime Judges and Courts Justice Department Lawyers, Cases and Bills Libraries for Lawyers Offenders and Movements Parking Tickets Police Departments Police Generalized Data Model Police Information Reports Police MDM Data Model Police Mobile Application Prisons and Prisoners Private Investigators Tracking Evidence Traffic Cops and Tickets Lawn Bowling Clubs LDAP Legal Case Management Libraries Libraries Basic Model Libraries and Books Libraries of Digital Assets Libraries of Film Tapes Libraries of Sheet Music Libraries for Lawyers Libraries for Teachers Libraries for UK Schools Library Donations My Library (for Amazon Web Svcs) OPAC - Library Catalog Virtual Library for MyLifeBits Licences and Permits Lifecycle of a Sale Limousine Services Loan Management System Local Favourites Local Govt (UK) Logistics (Corporate) Logistics (Defense) Logistics (Freight Forwarders) Logistics (Shipments) Logistics (Ships Stores) Long Term Accommodation LSC Framework for Excellence Magazine Subscriptions Mail System Maintenance Contracts :- For Products with no Parts For Products with Parts (Dezign) Making a Movie Making a Movie (for Beginners) Manufacturing :- Aircraft Orders and Parts Assets Maintenance Bill of Materials Construction and Manufacturing Customer Purchases Data W'house Paper Manufacturing Product Catalogs Tracking Customer Orders Vehicle Maintenance Vehicle Parts Manufacture Maritime Models :- Freight Forwarders Harbour Management Marine Archeology Maritime Museums Scuba Diving Swimming Clubs US Navy Marriages Mashups Master Data Management Me and Mommy Me and Mommy (a Tutorial) Medical :- Blood Banks Cancer Screening Community Medical Centers Dietician Practice Doctor's Practice Health Centers Health Insurance Claims Hospice Patient Care Hospital Admissions Hospital Outpatients Hospitals and Patients Medical Centers (Community) Medical Laboratories Medical Laboratories with Payments Mortuaries Natural Disease Treatments Nurses Roster Nursing Home Patient Care Pharmacies and Generics Pharmacies and Prescriptions Pharmaceuticals Data Warehouse Pharmaceutical Supplies Prescriptions Database Stop Smoking Services Symptoms and Diseases Medical Laboratories Message Board for a Web Site MetaData Management Middle East Conflict Mobile Police Application Modelling Agency Mortuaries MP3 Music Site Movie Making Multi-Level Marketing Multi-Media Publication Museums (Simple) Museums (Complex) Music Lovers Communities Music over the Internet Music Performance Royalties Musicians, Bands and Gigs Musicians in Newspapers Musicians in a Band MVC Model-View-Controller myDBA User Interface My Life My Simple Life MyLifeBits Research My Work My Life and Work National Trust (UK) Native Peoples Natural Disease Treatments New Egg Web Site Newsagents Newsletters Nomadic Tribes Not For Profits (NfPs/NPOs) Nurses Roster Nursing Home Offenders and Movements Offshore Drilling Equipment Olympic Sports Online Art Galleries Online Banking Online Gambling Online Scheduling OPAC Library Catalog Opticians Oracle Data Dictionary Oracle Database Rpt Oracle PL/SQL Orders and Parts Organic Vegetable Garden Planner Organisations and People Organisations and Transactions Organisations,Members & Meetings Package Delivery Service Paintings on Loan Parking Space Registration Parking Tickets Parties and Products Partners in a Firm Patient Care Payrolls Performance Monitoring Permits and Licences Personalization Personal Insurance Pest Control Pharmacies and Generics Pharmacies and Prescriptions Pharmaceuticals Data Warehouse Pharmaceutical Supplies Philip Greenspun's Communities Phone Bills Photo Catalogs (e-Commerce) Piano Tuners Picture Library Pizza Deliveries Plane Spotting Police Departments Police Generalized Data Model Police Information Reports Police MDM Data Model Police Mobile Application Pool Hall Management Pool League Statistics Popkin System Architect :- Data Warehouse Data Dictionary Generic Customer Model Hotel Reservations National Trust Visitors Portals Financial Portals Publish and Subscribe Users and Portals Web Portal Navigation Prescriptions Database Preserved Railways Price Comparison Web Sites Prisons and Prisoners Products :- Bill of Materials Product Catalogs Product Categories Product Characteristics Product Distribution Product Hierarchies Product Servicing Products and Manufacturers Products and Security Products for Hire Products, Orders and Deliveries Project Planning Project Staff Properties (National Trust) Properties (Real Estate) Property Development Proposals, Projects & Donors Pub Quiz League Pubs and Parties Public Transport Publish and Subscribe (Simple) Publish and Subscribe (Complex) Quantity Surveyors Quality of Life Questionnaires - Basic Questionnaires - Complex Questionnaires - Multiple Choice Questionnaires - for Marketing Surveys Radio Stations Railway Reservations Ratings and User Reviews Real Estate Agents Real Estate Rentals Real Estate Sales Real World Series Generic Real World Overview of the Real World Real World of Entertainment Real World of Insurance Recipes Record Label Recruitment Agencies Recycling and Garbage Collection Reference Database Reference Data Manager Refugees & Asylum Seekers Removals Companies Report Generators Reservations :- Apartment Rentals Airline Reservations Car Hire Cinema Bookings Coach Trips Doctors Practice Driving School Event Reservations Flights for Children's Charities Hairdressers Appointments Health Centers Holiday Homes Hotel Reservations Limousine Services Online Scheduling Pool Hall Management Railway Reservations Restaurant Bookings Sports Centers Ticketmaster Vehicle Rental Resources Requesters Restaurant Bookings Restaurant Delivery Service Retail Customers Reviews and Ratings Risk Management (UML) Sailing Club Sales Commissions Salesforce Salesforce.dot.com Salesforce CDM Strategy Salesforce Data Integration Sales Lifecycle Sales Promotion Analysis School Management Systems School Print Shops Schools Sports Tournaments Scientific Research Scuba Diving Search Engine Search for a Data Model Search for Musicians in Articles Search for Items in Newspapers Security Guards Septic Tanks Service Assessment Service Magic Professionals Service Request Calls Services Job Scheduling Sewing Rooms Ships Stores Logistics Shopping Malls Show Business Ballet Companies CD Collection Circus Clown Registry Dance School Talent Agency Theater Company ticketmaster Shrek2 Movie Single View of a Customer Skills and Authorisations Stamps Smart Cities and Global R and D Snowflake Design SOA Social Anthropology Coping with Life Middle-East Conflict Quality of Life Usual Suspects Social Capitalist Awards Social Networking Sites Social Workers Case Mgt Spam and Junk Mail Spatial Temporal Databases Sperm Banks Sports Card Collecting Sports Centers Spreadsheet Reports SQL Server 2008 Staff Movements Star Design for Teaching Schedule Star Design for Transaction Stock Control Stock Control (Retail Store) Stock Control (Sports Centers) Stockmarket Data Stop Smoking Services Street Cleaning Schedules Street Traders Students :- Behavior Monitoring Church Sunday Schools Class Scheduling Credit Accumulation (Europe) e-Learning High School Football School Catering Businesses School Management Systems Schools Sports Tournaments Student Accommodation Student Activities Student Assessments (Simple) Student Assessments (Complex) Student Assignments Student Athletes Student Exams Student Exams in Saudi Student Information Systems Student Loans Student Questionnaires Student Registration Student Rosters Student Transcripts Tracking Student Work Placements University Course Catalogs Surveyors and Contacts Swimming Clubs Symptoms and Diseases Talent Agency Tanning Salons Task Logs (Knowledge Management) Tax Receipts Taxi Service Technical PC Support Telephone Bills Tenant Contact Tracking Theater Company Ticketmaster Timesheets Tour Guides Tracking :- Tracking Customer Orders Tracking Evidence Tracking Grants for Research Tracking Grants for Skills Development Tracking Manufactured Items Tracking Share Transactions Tracking Software Problems Tracking Software Registration Tracking Tenant Contacts Traffic Cops and Tickets Transport (Public) Transportation and Shipments Travel Agencies Travel and Tourism Worldwide Treatments for Natural Diseases Trouble Tickets TV Electronic Programme Guides (EPGs) TV Talk Shows Tutorial on Database Schema UK e-Govt Standard Data UML Class Diagrams UN Global Compact Uniforms on Loan Union Grievances University Course Catalogs US Government Contracting US Government Organization Used Flutes Exchange User-Defined Hierarchies User-Extendable Database User-Extendable DataDictionary User Identity Management Customer Master Index LDAP Single View of the Customer User Identity Management User Portals User Portals and KPIs User Profiles User Reviews and Ratings User-Submitted Material Usual Suspects Conflict and Wars Football Clubs Fox Hunting Wedding Parties Vegetable Garden Planner Vehicle Imports Vehicle Maintenance Vehicle Mileage Tracking Vehicle Parts Manufacture Vehicle Registration Authority Vehicle Rental Vehicle Tracking Vertical Applications CRM and Customers e-Commerce Education Entertainment Health and Fitness Law Enforcement Students Transport and Travel Vets Practice Video Purchase Video Rental Stores Volcanoes (Visio & Dezign) Voters and Elections Warehouse Inventory Management Waste Management Waste Skip Hire Water Bills Weather Reporting Web 2.0 Web Portal Navigation Web Site for a Community Web Site for DBA Site Web Site Analytics Web Site Pages Web Site Registration Web Site Traffic Analysis Web Sites for Hobbies and Pastimes Weddings Wedding Parties Weighbridge Operations Wildlife Parks Wills and Families Wine Cellars Wiring Diagrams Woot Workflow Worksheets World Health Organization STD World Language Classification Youth Church Zip Codes in Mexico 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