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. Access Control Accidents at Work Accommodation (Long-term) Actions,Decisions,People & Property Afghanistan Rainfall Agents and Leads Agents Commissions Aircraft Parts and Orders Airline Reservations Airport Management Amazon and Starbucks Animal Shelters 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 Balbir's Expert Exchange Ballet Companies (Casting Productions) Ballet Companies (Org and People) '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 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 Business 2 Business e-Commerce Business 2 Consumer e-Commerce Business Directories Call Centers Canal Trips 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 Cemetaries Census Results Charities and Appeals Charities (Just Giving) Chess Tournaments Children in Institutions (UNICEF) Children's Aid Rcds Mgt 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 Coding 4 Fun Projects Communities ... Community Groups and Workers FAQs and Newsletters Personalization Philip Greenspun Publish/Subscribe & KPI Portal User Registration Complaints and Feedback Competition Results Conference Centers 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 Department Store Diabetes Diagnosis and Treatment Dietician's Consulting Practice Dictionaries for Foreign Languages Digital Challenge (UK) Diseases and Symptoms Doctor's Practice 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 Education :- Educational Networks School Management Systems School Print Shops Schools Sports Tournaments Student Accommodation 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 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 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 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 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 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 Android Phone Platform GRI Indicators GRI Repository GRI User's Portal Grocery Store Gym Training Diary Hairdressers Appointments Harbour Management Hardware Sales 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 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 Mobile Application Prisons and Prisoners 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 Limousine Services Loan Management System Local Govt (UK) Logistics 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 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 Medical :- Blood Banks Dietician Practice Doctor's Practice Health Centers Health Insurance Claims Hospice Patient Care Hospital Admissions Hospital Outpatients Hospitals and Patients Medical Laboratories 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 in Newspapers Musicians in a Band MVC Model-View-Controller My Life MyLifeBits Research My Work My Life and Work National Trust (UK) Native Peoples Natural Disease Treatments New Egg Web Site Newsagents Newsletters 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 Pool League Statistics Police Generalized Data Model Police Information Reports Police Mobile Application Popkin System Architect :- Data Warehouse Data Dictionary Generic Customer Model Hotel Reservations National Trust Visitors Portals Portals and KPIs Prescriptions Database Preserved Railways Price Comparison Web Sites Prisons and Prisoners Products :- Bill of Materials Product Catalogs Product Categories Product Characteristics Product Distribution Products for Hire Product Hierarchies Product Servicing Products and Security 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 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 Reference Database Reference Data Manager Refugees & Asylum Seekers Removals Companies Report Generators Reservations :- Apartment Rentals Airline Reservations Car Hire Cinema Bookings Coach Trips Driving School Event Reservations Hairdressers Appointments Health Centers Holiday Homes Hotel Reservations Limousine Services Online Scheduling 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 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 Request Calls Services Job Scheduling Sewing Rooms 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 Smart Cities and Global R and D Snowflake Design SOA Social Anthropology 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 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 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 Tax Receipts Taxi Service Technical PC Support Telephone Bills Tenant Contact Tracking Theater Company Ticketmaster Timesheets Tour Guides Tracking Customer Orders Tracking Evidence Tracking Grants for Research Tracking Grants for Skills Development Tracking Manufactured Items Tracking Share Transactions Tracking Software Problems 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 Vertical Applications CRM and Customers e-Commerce Education Entertainment Health and Fitness Law Enforcement Students Transport and Travel Vets Practice Video Purchase Video Rental Volcanoes (Visio & Dezign) Voters and Elections Warehouse Inventory Management Waste Management Waste Skip Hire Water Bills Weather Reporting Web 2.0 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 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. Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map