Home About Us Ask a Question Careers Clients Contact Us Data Models Tutorials Site Map Click here for our new Courses on Database Design and Data Modelling. 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. Here are over 1,700 very useful 'Kick-Start' Data Models that I have created since I started about 10 years ago,   and click here for the Top 20 Click here for a list of more than 50 Industry-specific Models. Access Control Accident Management Accident Reports and Tickets Accidents at Work Accommodation (Long-term) Accounting Systems Accounting Systems for Double-Entry Bookeeping Accounting Systems with Multiple Bank Accounts Actions,Decisions,People & Property Active Directory Activity Based Costing A Day at the Olympics Advertising Advertising Billboards 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 Agents and Leads Agents Commissions Agents (Generic) Newsagents Real Estate Agents Talent Agencies Travel Agents Agile Data Modelling Air Cadet Firearms Activities Air Transport Air Transport Platform Aircraft and Inheritance Aircraft from WW2 Aircraft Parts and Orders Airline Bookings in Africa Airline Operations Airline Reservations Airline Travel Routes Airport in a Box Airport Management Airport Managment and the Internet of Things Airport Management Platform BAA (British Airports Authority) Enterprise Data Model for Air Travel Flight Bookings Flight Bookings (Private) Missing Flight MH370 Travel Terminals Aircraft Parts and Orders Airline Bookings in Africa Airline Reservations Airport Management Allocation of People Allotments Alumni Web Portals Amazon and Starbucks Amazon Jungle Villagers American Pickers TV Show American Studies Amusement Parks Animal Shelters Animal Species Animal Treatments Animal Welfare Animals (Prevention of Cruelty) Anti-Money Laundering AML Transaction Monitoring Apartment Rentals Apex Infrastructure Apex Application Architecture Apex Operational Support Services Apex Sandbox Application Frameworks Appointments (Help Wanted Ads) Apprenticeships and Training Approach 2db Design Aquarium Stores Area Regulations Archeology Archeology Archeological Site Conservation Portable Antiquities Scheme Archimate Model for Insurance Claims Ars Digita BootCamp Art Exhibitions Art Galleries Art Galleries (Online) Artificial Intelligence ARTS Retail Model Best Replica Watches ARTS Retail and Canonical Data Models Asbestos Surveys Assets Asset Management Assets Assets and Insurance Assets and Locations Assets Maintenance Assets Schedules Association Management Asylum Seekers and Refugees Athletes and Doping Athletes and Events Athletes and Teams ATM Machines Auction Web Site Auctions with Silent Bids Audio Equipment Rental Audit of Projects Auditions (Music) Automotive Industry Platform Avon Cosmetics B2B B2C Baby Photo Competitions Baby-Sitters and Nannies Badminton Clubs Ballet Companies (Casting Productions) Ballet Companies (Org and People) Baltimore Police Department Bands and Gigs BAM (Business Activity Monitoring) BAM BAM and Data Quality BAM and Event Data Architecture 'Bang for the Buck' Models Customers and Orders Customers and Services Marriages (Contemporary) Marriages (Traditional) Organisations, People and Events Partnerships and Relationships Product Catalogs Reservations Bank and Branches Bank Robberies Banking Acquisitions Banking Checking Accounts Banking Data Marts Banking Data Warehouses Banking (Generic) (Retail and Investment) Banking (Online) Banking (Platform 2020) Banking (Private) Bankrupts Barry's Life and Times Baseball Umpire Scheduling Basel II Accord BBC (UK) B.B.King Beauty BI Beer from Laos Beer Making Beekeeping Behavior Monitoring Best-Looking Models Best Practice Manuals BI OSS BO Banking POC BO Timesheets BI Semantic Model (Microsoft) BI (Self-Service) Bicycle Rental Bidders and Buyers Big Data Big Data Demo Big Data - Hadoop Big Data - Oracle's Approach Big Data - Teradata Architecture Big Data - Tutorial Bikes and Customisation Bill of Materials (BOM) BOM Design Patterns Board BI (Switzerland) Bills - Telephone Bills - for Utilities Bird Research Births, Deaths and Marriages Blaze TV Blockchain Blogs Blood Banks BMEWS 123 Bmews BI on the Beach BMEWS Design Pattern 1 BMEWS Organization Boating Marinas Boatyards Boiler Rooms Book Reviews and Ratings Bookkeeping Bookstore Bookstore and Warehouses Books and Libraries Botanical Gardens Boutiques Boy Scouts Breast Cancer Screening Breeding Cattle Breeding Dog Breeding Pigeon Breeding British Council British Open Golf Championship 2015 Broadcasting Corporations Broadcasting Operators Brookfield Global Relocation Services Building Societies Bureau of Justice Statistics Bus Tours Bus Tracking Business 2 Business e-Commerce (b2b) Business 2 Consumer e-Commerce (b2c) Business Accounts Business Activity Monitoring (BAM) BAM BAM and Data Quality BAM and Event Data Architecture Business Directories Call Centers Canal Trips Cancer Screening Cancer Treatment Effectiveness Canonical Data Model Cantina (Rose's) Car Dealership Car Hire Car Park Security Car Parking Enforcement Car Parts Suppliers Car Rental Business Car Sales Car Sales (Simple) Car Service Center Caravan Park Holiday Bookings Cardiac Catherization Registry (&EAV) Cardiac Surgery Database Cargo Ship at Night Carolyn's Data Model Carphone Warehouse Case Management (Lawyers) Case Management (Lawyers Role-based) Case Management (Social Workers) Casinos Catalogs of Products Catering Businesses for Schools Catering Services Catteries Cattle Breeding CD Collection CDL Drivers Medical Review Cell Apps Stores Cemetaries Census of Parishioners Census Results Charities (A Tutorial) Chart of Accounts Charities and Appeals Charities and Collection Tins Charities (Just Giving) Chemical Dependency Providers Chess Tournaments Children ... Child Care Centres Children and Families Support Children in Institutions (UNICEF) Children's Aid Records Mgt Children's Charities Flights Children's Clinics Children's Common Assessment Framework Childrens Lives Children's National Database Children's Playgroups Christmas Christmas and New Year's Eve Church Donations Church Food_Pantry Visits Church Members (Visio) Church Missionaries Church Praise Teams Church Sunday Schools Church (Youth) Cinema Bookings Circus Cirque du Soleil Citizen Developer Stuff Citizens and Events Citizens and Services City Councils City Hall Certificate Registration City Licences City Tourist Guide Classified Ads Claygate Conservation Claygate Data Platform Claygate Tourist Guide Cleaning Companies Cleaning Job Scheduling Click Stream Analysis Clients and Consultants Clients and Fees Clients and Locations Clients and Pensions Clients, Services and Fees Clinical Trials Clinics and Pharmacies Cloud Computing Cloud Data Services Clown Registry Club Members CMDB - Configuration Mgt DB Coach Trips Coding 4 Fun Projects Coin Collecting Collectables Coin Collecting Comic Book Collections Comedy Central Commercial Fishing Commercial Properties Commercial Self Service Commercial Web Sites ... Avon Cosmetics Baltimore Police Department Brookfield Global Relocation Services Cirque du Soleil Descartes Systems Group Dice (Job Seekers Web Site) Digital Innovation Inc. Dog the Bounty Hunter Dog Whisperer eBay Deals Financial Services Authority Gearhead Outfitters Go Compare.com Gumtree Ideal Shopping IMDB (Internet Movie DB) Just Giving (Charity) Keytec (Netherlands) Linked In Magic Gatherer Cards MyLifeBits Research NewEgg Open University Oxford University Press Performing Rights Society Regus Office Accommodation RSPCA (UK) SalesForce Salim Shrek 2 Movie Sony Computer Entertainment Europe Sony Corporation Starbubble Cafe, Eindhoven, Holland Star Craft 2 Game Tesco The Maritime Group Ticketmaster TK Maxx Woot Yell (UK) Commodities Exchange Platform Common Data Model Communities ... Community Groups and Workers FAQs and Newsletters Personalization Philip Greenspun Publish/Subscribe & KPI Portal User Registration Community Web Site Complaints Community Medical Centers Company Associations Competition Results Complex Event Processing Compliance and Regulations Compliance with GDPR Computer Sales (Dell) Concrete Manufacturing Condomiums and Accounts Conference Centers Conference Proceedings Conference Proceedings Management Conflict and Wars Conformed Dimensions (Data Marts) Day at the Olympics Retail Banks Telecomms Conglomerates Capita (Outsourced Business Processes) Kier Group (Construction) xCAP TBC Conservation of Historic Objects Construction and Manufacturing Construction Companies Construction Jobs Bidding Consultants and Clients Consultant Search Web Site Consumer Packaged Goods (CPG) Contacts and Availability Contacts and Comments Contacts and Products Contact Management Container Shipping Contract Management Contract Staff Agencies Contracts Coping with Life Copyright Hub Corporate Hierarchy Corporate Intranet Cosmetics Home Sales Cottage Rentals Course Catalogs Course on Data Modelling Cow's Events CPG - Consumer Packaged Goods CraigsList Credit Accumulation (Europe) Crime Investigation Criminal Record Keeping Crisis Call Centers CRM CRUD - Create,Read,Update,Delete Cruises :- Cruise Liners and Passengers Cruise Ship Adminstration Cruise Ships CSR Framework CSR Indicators Cultural club Customs - Generic Customs - Swiss CVs and Job Histories (Visio) Dance School Data Analysis Data Architecture Data Dictionary Data Dictionary in the Clouds Data-driven Procedures Data Governance in the Clouds Data Governance (SOA) Data Integration Data Landscapes Data Management Platform from Gartner Data Mart Case Studies Data Mashups Data Migration and Design Patterns Data Mining Data Modelling Research Data Quality Audit Data Warehouses :- Basic Data Mart Customers and Purchases eCommerce Data Warehouse Loading a Data Warehouse Data Warehouse Automation Data Warehouse Loading (Alt) Federated Data Marts Pharmaceuticals Snowflake Schema for Financial Transaction Star Design for Teaching Schedule Star Design for Transaction (Conceptual) Star Design for Transaction (Physical) Star Schema Databases for Life Dating Sites Day Care Centers DBA Cloud Services DBA Business Platform DBA Cloud Services for SMBs DBA Commodities Exchange DBA Data Platform Logistics for Heathrow DBA Packaged Services DBA Partners Presentation Debt Collection Debt Management Defense Logistics Dell Computer Sales Department Store Descartes Systems Group Design Patterns and Generic Models Development Disabilities Services Diabetes Diagnosis and Treatment Diet Decision Support System Dietician's Consulting Practice Dictionaries for Foreign Languages Digital Challenge (UK) Digital Transformation :- Basic Challenger Banks Getting Started Getting Started with Self-Service Self-Service Directional Drilling Companies Disaster Recovery Diseases and Symptoms Doctor's Practice Do-It-Now Services Documents :- Document Control Systems Document Management - Basic Document Management - Generic Document Management - Security Document Management - Specific Document Publication Document Template Management Document Destruction Tracking Document Workflow Documents and Collections Documents and Expenses Dog Breeding Dog Kennels Dog the Bounty Hunter Dog Whisperer Domestic Violence Centers Domo Business Mgt Platform Donald Trump's World Donations :- Church Donations Library Donations Dragon Boat Racing Drama Workshop Groups Drinks in a Sports Bar Driver Recruitment Agencies Drivers Citations Log Drivers Education Driving School (Simple) Driving School (Complex) Driving Test Scores Database Dry Cleaners Earth-Moving Equipment Eat 17 Stores eBay Deals Ebola Victims e-Commerce B2B e-Commerce B2C e-Commerce Customers, Campaigns and e-Commerce e-Commerce e-Commerce Business Games Web Site Online Art Galleries Orders & Shipments Photo Catalogs Shopping Carts Education :- Educational Networks Open University School Management Systems School Print Shops Schools Sports Tournaments Student Accommodation Student Activities Student Applications Student Assessments (Simple) Student Assessments (Complex) Student Assignments Student Athletes and Teams Student Exams Student Exams in Saudi Student Information Systems Student Internships Student Loans Student Placements Student Registration Student Rosters Student Transcripts Tracking Student Work Placements University Course Catalogs University Gymnastics University Organisation e-Government UK e-Govt Standard Data UK Local Govt Channel Shift UK Council Planning Applications e-Learning Electrical Power Suppliers Electronic Medical Records Elephant Sanctuaries eMails Emergency Services Emergency Services Volunteers Employees Employee Record Keeping Employees Employees Leave Records Employees Owners and Locations Employees Savings Funds Employees Schedules Employees Working at Home Employment Agencies Endangered Species English Gentlemen Enterprise Data Mashups Enterprise Data Models Air Travel BMEWS BI Container Shipping Digital Innovation Inc. EDM and Subject Area Models Electrical Power Suppliers Events and Exhibitions Financial Services Gym Management (& Tutorial) Insurance Investment Banks Local Government Local Government Channel Shift Oil Companies Retail Waste Management Enterprise Information Repository Data Migration Mapping Generation of Entities Glossary of Business Terms Glossary with Queries Entertainment Entertainment Delivery Platform Entertainment Events Entertainment (24 Data Models) Entity-Attribute-Values (EAV) Entrepreneurs Environmental Impact Assessment Environmental Monitoring EPOS Equipment Maintenance Equipment Repair ERD and UML ERP ERWin Models Circus ERD and UML Job Scheduling Local Government Residents Museums (Complex) Not for Profits Organisations and People Organisations and Transactions Maritime Museums Photo Catalogs Real World of Entertainment Salesforce.com Salesforce Data Integration Shrek 2 Movie SOA (Service Oriented Architectures) Surveyors and Contacts Estimating Development Costs ETL Business Rules Make-up Artists Kit Data Migration Mapping Data Warehouse Loading Master Data in Malaysia Master Data Management Events Event Alerts (Publish and Subscribe) Event-Driven Architecture (and BAM) Event Driven Platform Event Management Event Planning Event Processing (Complex) Event Registrations Event Reservations Events and Exhibitions Events and KPIS Events and Staff Training Events in a Cow's Life 1) Everyday Activities 2) Once in a Lifetime Everyday Events Everyday Interests Expenses and Documents Experts and Questions Facebook and Social Networking Sites Facebook App Invitations Facilitated Workshops Facilities Assignment Facilities and Inspections Facilities Management Platform Families and Wills Family Advocacy Family Budgets FAQs Farm Management Farming Company in Saudi Farms and Cow's Events Fashion Boutiques Father of all Data Models Father of all Data Warehouses FBI Global Database Federated Data Marts Feedback Feedback for Services Feedback Management Fertilizer Companies FIFA Scandal 2015 File Archiving Systems Film Rights Finance Subject Area Financial Engagement Financial Global Custody Financial Cashflows Financial Portals Financial Reporting Platform Financial Services Financial Statement Generator Fingerprint Recognition Fish Factory Fishing Industry Flight Catering Systems Flights for Children's Charities Food and Wine Restaurant Bookings Wine Wine, Food and Merchants Wine Stores Wine, Vineyards and Roles Food Distribution Football Clubs Football Clubs Tutorial Foreign Language Dictionaries Foreign Language Tournament Listings Forensics Forensic Science Labs Forklift Truck Servicing Fox Hunting Franchise Operators Freight Forwarders Frozen Yoghurt Shops Fuel Coupons Mgt Fuel Stock Fund Raising Funeral Homes Future of Databases Future of Payments 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 Customer Data Platform Customer Experience Management Customer Journey Mapping Basic Intermediate Advanced More Advanced Convert to Retail Platform Customer Lifetime Value Customer Management Customer Sales (M) Customer Service on the Move Customers with multi-lingual B2C Customers at a Bank Customers at a Bank (retail) Customers at a Bookstore Customers at a Call Center Customers and Addresses Customers and Campaigns Customers and Car Hire Customers and Car Parts 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 Financial Services Customers and Frozen Yoghurt Shops Customers and Games Shops Customers and Hairdressers Customers and Hardware Store Customers and Health Centres Customers and Insurance Customers and Inventory Management Customers and Invoices Customers and Jobs Customers and Loans Customers and Loyalty Customers and Memberships Customers and Online Banking Customers and Orders Customers and Partial Deliveries Customers and Payments Customers and Payments (e-Gov't) Customers and Phone Bills Customers and Price Comparison Web Sites Customers and Products Customers and Products (Canonical) Customers and Products (Generic) Customers and Products and Promotions Customers and Products and Inheritance Customers and Purchases Data W'hse Customers and Queries Customers and Retail Customers and Services Customers and Services (Advanced) Customers and Services (Basic) Customers and Services (EMS Ship Supply) Customers and Services (Generic) Customers and Services (Vecom Marine) Customers and Shoppers Recommendations Customers and Telemarketing Customers and Timesheets Customers and Water Bills Customers Class Scheduling Customers Comm & Personal Customers Data Customers Data Catalog Customers Data Warehouse Inventory - Customers and POS Customer Journey Mapping Customer Journey Mapping - Complex Customers (Commercial & Personal) Customers (Retail) Customers MetaData Repository Customers Metrics Customers Order Tracking Generic Customer Model (Popkin) Know your Customer Gambling (Online) Gaming Gaming Competitions Gaming - Generic Games Features Games Store Gaming Leagues Gaming - Specific - Gears of War Gaming - Specific - Table Top Gaming Web Sites Shrek Movie Garbage Collection and Recycling GDPR (General Data Protection Regulation) Genealogy and Family Trees Generic Enterprise Soutions Chart of Accounts Customers and Queries Finance Subject Area Financial Cashflows Financial Engagement Financial Global Custody Financial Services Financial Portals Financial Reporting Platform Financial Services Financial Statement Generator Report Generators Generic Models (and Design Patterns) Canonical Data Model Childrens Lives Circus (Events & Players) Customers Generic Customers (Popkin) Customers and Services Dimensional Model Document Management Enterprise Data Model Father of All Models Generic Foundation Generic Me and My Life Generic Point of Sale (POS) Museums Organisations and People Organisations, People and Transactions Organisations, Members & Events Organisations, Members & Meetings Organisations, Staff and Changes Patient Care Payments (Generic) Payments and Invoices Point of Sale (POS) POS for Animal Feed Manufacture Publish and Subscribe (Basic) Publish and Subscribe (using Tags) Publish and Subscribe (Financial Portal) Publish and Subscribe and Event Alerts Reservations Retail Shrek 2 Movie (Events & Places) Transport Usual Suspects George Orwell's 1984 Getting Started Give up Smoking Glastonbury Music Festival Global Accountability Global Community Global Consulting Global Credit Crunch Global Crime Global Custody Global Interaction Platform Global Law Firm Global Project Management Global Relocation Services Global Reference Database Global Retail Marketing Going Public Golf Golf Course Specifications (1) Golf Course Maintenance (2) Golf Course Maintenance Employee Tasks (3) Golf Club Management (4) Golf Championships (British Open 2015) (5) Golf Memorabilia (6) Golf Tournaments Google AdSense Google Analytics Google Android Phone Platform Google World Governance, Risk Mgt and Compliance (GRC) Greyhound Training GRI Indicators GRI Repository GRI User's Portal Grocery Store Grocery Store Shelves Gumtree Gym Equipment Gym Management (& Tutorial) Gym Training Diary Hairdressers Appointments Harbour Management Hardware Sales Hazard Management Health Centers Health Clubs Health Insurance Claims Health Topics and Educational Material Hedgehogs Help Desk Help Desk and Issues Help Wanted Ads Hierarchies & Trees Business Intelligence / MI Employees Japanese Organised Crime Mafia Organised Crime Management Hierarchies Organization Hierarchies Parties and Phones (Plain) Hierarchies Preferences Reference Data Manager User-Defined Hierarchies Vehicle Parts Manufacture World Language Classification (with Oracle CONNECT BY) High School Activities High School Football High School Football Analytics Highways Agency (UK) History Enthusiasts Hobbies and Pastimes Chess Tournaments Golf Tournaments Olympic Games Olympic Sports Swimming Clubs Sailing Clubs Holiday Homes Home Libraries Home Safety, Security and Alarms Homeowners Associations Horse Racing Horse Racing and Betfair Hospice Patient Care Hospital Management Hospital Admissions Hospitals Clinics and Orders Hospital Operating Theaters Hospital Outpatients Hospital Patients Hospital Staff Hospital Supplies Hospitality Hotel Reporting Services Hotel Reservations Hotels and Tourist Attractions Hotels Platform HR (Basic) HR or Personnel Department HR Platform HR (Training Evaluation) Houses and Rooms Human Body IIA Insurance Party Icons of the Western World Identifiers and Column Memos Identity Cards Ikebana (Japanese Flowers) IMDB (Internet Movie DB) Import/Export Logistics Importing Client Data Incidents Indigenous Peoples Industry Data Models Industry Specific CRM and Customers e-Commerce Education Entertainment Health and Fitness Law Enforcement Students Transport and Travel Information Factory Inheritance Models American Studies Baltimore Police Department Births, Deaths and Marriages Charities City Tourist Guide CMDB - Configuration Mgt DB Contacts and Availability Customers Commercial and Personal Event Registrations Games Store Icons of the Western World Inheritance and Customers Insurance Brokers Libraries for Lawyers My Work National Trust (UK) NewEgg Photo Catalogs Roles Inheritance and Subtypes School Management Systems Shrek 2 Movie Tracking Manufactured Items Travel & Tourism Worldwide Travel and Transport (top Level) Union Grievances Vehicle Imports Inspection Services Inspections of Facilities Insurance Insurance Applications Insurance Applications (Advanced) Insurance Brokers Insurance and eClaims Insurance Common Data Model Insurance FNOL Insurance Policies - Car, Home and Life Insurance Claims (in Archimate) Insurance Data Warehouses Insurance (General) Insurance (Personal) Insurance Policies and Claims Solvency II Intelligent Environments Intelligent Transport Systems Internet Music Radio Stations Internet of Things Local Government Logistics Inventory Control Fuel Stock Inventory and Equipment Maintenance Inventory and Sales 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 Furniture Inventory of IT Assets Inventory of Plants in a Nursery Inventory of Rental Equipment Inventory of Servers Inventory of Ship's Stores Inventory of Tooling Equipment Inventory Reconciliation Inventory Reconciliation (Generic) Investment Banking Accounts Data Mart for FX Deals Data Marts Generic Framework Data Warehouses Clients (Customers) Enterprise Data Model Financial Reporting Platform Financial Services Authority FX Deals Global Custody Settlements Wealth Management Invisible Models (& Tutorial) Beer from Laos Cargo Ship at Night Cruise Ships Dutch Barges Hotel Napkin Office Building (HTC 41) Stag Beetles Taxis UK Pillar Boxes White Smoke in the Vatican Invoices and Payments Invoicing and B2B ISA 95 Islamic State 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) Jobs Skills and Users Judges and Courts Judo Training Juggernaut Launching Pad Julie Meyer Justice Department Keith's Banking Keytec (Netherlands) KPI and Financial Portals (Publish/Subscribe) KPI Definitions (Key Performance Indicators) KPI Triangle KPIs and SOPs (Standard Operating Procedures) KPIs for Oracle Finance Kitchen Cabinets Know your Customer Kony Data Architecture Laboratory Test Systems Laboratory Management Land Registry Landscape Gardening Language Schools Laundry Management Law Enforcement :- Anti-Money Laundering Baltimore Police Department Bank Robberies Case Management Case Management (Role-based) Crime Investigation Fingerprint Recognition Forensics Forensic Science Labs Global Crime Global Justice (USA) Japanese Organised Crime Judges and Courts Justice Department Lawyers, Cases and Bills Legal Entities Libraries for Lawyers Mafia Organised Crime Money Laundering (Anti) Offenders and Movements Organised Crime in Japan Parking Tickets Police Departments Police Generalized Data Model Police Information Reports Police MDM Data Model Mobile Apps Stores Police Mobile Application Police Canonical Data Model Prisons and Prisoners Private Investigators Tracking Evidence Traffic Cops and Tickets Tracking Terrorists Tracking Terrorists (Domestic UK) Tracking Terrorists in the Middle East Yakuza Japanese Organised Crime Lawn Bowling Clubs LDAP Legal Case Management Lending and leasing Libraries :- Libraries Basic Model Libraries and Books Libraries and Librarians Libraries of Digital Assets Libraries of Film Tapes Libraries of Media Items Libraries of Sheet Music Libraries for Lawyers Libraries for Teachers Libraries for UK Schools Library Asset Register Library Donations Library for Haidar Salim in Iraq My Library (for Amazon Web Svcs) OPAC - Library Catalog Virtual Library for MyLifeBits Licences and Permits Lifecycle of a Sale Life Sciences Data Mart Linked In Limousine Services Loading a Data Warehouse Loading a Data Warehouse (Alternate) Loan Management System Loan Management Consolidation Local Favourites Local Government :- Channel Shift Customer MDM Enterprise Data Model Internet of Things Local Govt in Alabama Operational Support Services (OSS) Residents Subject Areas Top-Level Local History Societies Locationss Locations as a Subject Area Logistics :- Basic Logistics Canonical Style Model Corporate Descartes Systems Group Defense Deliveries (Warehouse) Enterprise Model for Logistics Freight Forwarders Internet of Things and Logistics Logistics and Shipments Logistics and Travel Logistics Platform Movements Shipments Ships Stores Long Term Accommodation Lost and Found Pets Lotteries Loyalty and Customers Loyalty Programs LSC Framework for Excellence Maana's Page Machinery Diagnostics Mafia Organised Crime Magazine Subscriptions Mail Delivery Systems Maintenance (Contracts) :- For Products with no Parts For Products with Parts Maintenance, Repair and Overhaul (MRO) Making a Movie Making a Movie (for Beginners) Make-up Artists Kit Movie Studios Manufacturing :- Aircraft Orders and Parts Assets Maintenance Bill of Materials Component Manufacture (Keytec, Netherlands) Concrete Manufacturing Construction and Manufacturing Customer Purchases Data W'house Packaging Equipment Manufacturers BOM Paper Manufacturing Product Catalogs Shower Screens Manufacture (for Nimble Elephant) Tracking Customer Orders Vehicle Maintenance Vehicle Maintenance with Inheritance Vehicle Manufacturers Vehicle Parts Manufacture Maritime Models :- Freight Forwarders Harbour Management Marine Archeology Maritime Museums Scuba Diving Swimming Clubs The Maritime Group US Navy Market Research Marketing Funnels Marriages Mashups Matching Writers Names Master Data in Malaysia Master Data Management (Customers, Local Gov't) Master Data Management (Motor Trade) Me and Mommy Me and Mommy (a Tutorial) Me and Mommy Enhanced (Free) Tutorial Media Libraries Medical (Healthcare) Models Blood Banks Cancer Screening Community Medical Centers Development Disabilities Services Dietician Practice Doctor's Practice Ebola Victims Electronic Medical Records Health Centers Health Insurance Claims Health Topics and Educational Material Hospice Patient Care Hospital Admissions Hospital Operating Theaters Hospital Outpatients Hospitals and Patients Medical Centers (Community) Medical Clinics and Pharmacies Medical Laboratories Medical Laboratories with Payments Medicines and Authorisations Mortuaries Natural Disease Treatments Nurses Roster Nursing Home Occupational Health Outpatients Medical Center Pathology Tests Patient Care Patient Data Warehouse Patient Tests Patients Visits to the Clinic Patients Visits to the Doctor Pharma and Biotechnology Information Pharmacies and Generics Pharmacies and Prescriptions Pharmaceuticals Data Warehouse Pharmaceutical Companies Pharmaceutical Supplies Podiatry Clinics Prescriptions Database Stop Smoking Services Symptoms and Diseases Tracking Results of Treatment Medical Laboratories Meetings Meeting Old Friends Membership Organistions Mendix Stuff Mentoring Naval Officers Message Board for a Web Site Message Handling Systems MetaData Management MetaData Repositories MetaData Repository (Customer Data) Microsoft BI Semantic Model Microsoft Common Data Model Microsoft Entity Framework Microsoft Integration Patterns Microsoworlds Middle East Conflict Middle East Conflict (Complex) Military Intelligence Mines and Billing Missionaries Mobile Applications (Police) Mobile Development Platform Mobile Payments Services Modelling Agency Models for Marketers Monaco Money Exchange for Students Monkey World Mortuaries Motor Trade Movements Movie Making Movie Studios MP3 Music Site Multi-Level Marketing Multi-Media Publication Multi-Resource Scheduling Multi-User Databases Museums (Simple) Museums (Complex) Museums (Generic) Music Auditions Music Lovers Communities Music over the Internet Music Performance Royalties Musicians, Bands and Gigs Musicians in Newspapers Musicians in a Band Musicians Uniforms MVC Model-View-Controller myDBA User Interface Meetings My Life My Life and Work MyLifeBits Research My Simple Life My Work National Trust (UK) Native Peoples Natural Disease Treatments New Egg Web Site Newsagents Newsletters Newspapers Newsstands Night Clubs Nomadic Tribes Not For Profits (NfPs/NPOs) Not for Profits and Services Nurses Roster Nursery School Nursing Home Occupational Health Offenders and Movements Office Accommodation (Regus) Office Building (HTC 41) Offshore Drilling Equipment Oil Companies Olympic Games Basic Olympics Day at the Olympics Judo in London 2012 Olympic Sports Olympics Rio 2016 Omni Channel Retailing (aka Multi-Channel) Online Art Galleries Online Banking Online Exams Online Gambling Online Scheduling Online Shopping OPAC Library Catalog Open University Operational Data Stores Operational Support Services Operations Management ORM - Object Role Modelling OSS and Local Government OSS Service Delivery Platform Opticians Oracle Data Dictionary Oracle Database Rpt Oracle Digital Universe Oracle PL/SQL Oracle SMBs Orders and Parts Organic Vegetable Garden Planner Organisations and People Organisations and Transactions Organisations, Meetings and Minutes Organisations, Members & Meetings Organisations, Staff and Changes Oriental Rugs - Buy, Sell and Service Outpatients Medical Center Oxford University Press Package Delivery Service Packaging Equipment Manufacturers Paintings on Loan Panama Papers Parking Space Registration Parking Tickets Parties and Products Parties, Roles and Customers Parties, Users and Entities Partners in a Firm Partnerships and Relationships Parts and Distributers Party - IIA Insurance Party Master Index Passengers on a Cruise Pathology Tests Patient Care Patient Monitoring System Patient Tests Patients Visits to the Clinic Patients Visits to the Doctor Payments Services (Mobile) Payments Subject Area (Wholesale Banks) Payments to Authors Payrolls Penitentaries People Performance Auditing Performance Monitoring Permits and Licences Personalization Personal Insurance Personal Trainers Pest Control Pharma and Biotechnology Information Pharmacies and Generics Pharmacies and Prescriptions Pharmaceuticals Data Warehouse Pharmaceutical Companies Pharmaceutical Supplies Philip Greenspun's Communities Phone Bills Phone Calls and Legal Cases Photo Catalogs (e-Commerce) Piano Tuners Picture Library Pigeon Breeding Pizza Deliveries Plane Spotting Planets in the Solar System Planning Applications (UK Councils) Plants in a Nursery Platform Project Podiatry Clinics Point of Sale (POS) Generic Police :- Baltimore Police Department Police Canonical Data Model Police Departments Police Generalized Data Model Police Information Reports Police MDM Data Model Police Mobile Applications Tracking Evidence Traffic Cops and Tickets Pool Hall Management Pool League Statistics Popular Culture Sue Grafton's Alphabet Mysteries Portals Financial Portals Publish and Subscribe Users Portals and Links Web Portal Navigation Postal Services Prescriptions Database Preserved Railways Price Comparison Web Sites Print Shops Printer Cartridge Tracking Prisons and Prisoners Private Banking Problem Fixing Problem Reporting Services Problems and Solutions Procurement Procurement (Eat 17 Stores) Procument Platform Product Catalogs (Simple) Product Catalogs (Generic) Product Catalogs for Flow Systems Product Catalogs (Selfridges) Product Categories Product Characteristics Product Distribution Product Hierarchies Product Servicing Products and Manufacturers Products and Pricing Products and Security Products, Categories and Attributes Products for Hire Products - Master Data Products, Orders and Deliveries Products, Types and Characteristics Product Catalogs (Commercial) :- Comvita Hotel Chocolat John Lewis Selfridges TK Maxx Wine Lists Professional Services :- Professional Services Professional Services Automation Professional Services with Third Generation Platforms Project Audits Project Management Project Management Platform Project Planning Project Staff Projects and Activities Projects and Pipes Properties (National Trust) Properties (Real Estate) Property Development Property Investment Property Maintenance Property Tax Appeals Proposals, Projects & Donors Pub Quiz League Pubs and Parties Publications Master Data Catalogue Public Transport Publish and Subscribe (Basic) Publish and Subscribe (using Tags) Publish and Subscribe (Financial Portal) Publish and Subscribe and Event Alerts Puppies Tricks Purchase Orders Purchase Orders for Cars Purchase Requests Quantity Surveyors Quality of Life Queen Elizabeth II Questionnaires - Basic Questionnaires - Complex Questionnaires - Evaluation Questionnaires - Multiple Choice Questionnaires - for Marketing Surveys Rabbit Breeding Rabbit Rescue Radio Stations Railway Level Crossings Railway Reservations Ratings and User Reviews Real Estate :- Commercial Development and Risk Commercial Properties Homeowners Associations Real Estate Platform Properties Property Investment Real Estate Agents Rentals Sales Real World Series Generic Real World Overview of the Real World Real World of Entertainment Real World of Insurance Recipes Recipes (Products and Assemblies) Recipes (Recursive) Record Label Recommendation Engine (Advanced) Recommendation Engine (Basic) Recommendation Engine (Intermediate) Recruitment Agencies Recruitment Agencies (Drivers) Recruitment Agencies (Generic) Recycling and Garbage Collection Reference Database Reference Data Manager Reference Data Services Reference Data Specialists Refugees & Asylum Seekers Religious Organizations Removals Cloud Service Removals Companies Rental Equipment (Audio) Repair of Equipment Repair Services Report Enhancements Report Generators Research Lifecycle Reservations :- Apartment Rentals Airline Reservations Car Hire Caravan Park Holiday Bookings Cinema Bookings Coach Trips Community Centre Bookings Doctors Practice Driving School Event Reservations Flights for Children's Charities Generic Reservations Hairdressers Appointments Health Centers Holiday Homes Hotel Reservations Limousine Services Multi-Resource Scheduling Online Scheduling Pool Hall Management Railway Reservations Restaurant Bookings Restaurant Events Bookings Sports Centers The Maritime Group Theater Bookings Ticketmaster Vehicle Rental Visits to Church Food Pantry Visitor Management System Resolution Planning Resources Requesters Restaurant Bookings Restaurant Delivery Service Restaurant Events Bookings Restaurant Guide Restaurants and Customers Retail Retail Banks Retail Bank Accounts for Husbands and Wives Retail Banking in the Clouds Retail Customers Retail Customers (ARTS Standard Model) Retail (Generic) Retail (POS) Reviews and Ratings Rich People's Web Site Risk Management (UML) Roles Inheritance and Subtypes Rose's Cantina Rules Engines RV Dealerships Sailing Club Sales Commissions Sales (Computer - Dell) Salesforce Salesforce.dot.com Salesforce CDM Strategy Salesforce Data Integration Sales Lifecycle Sales Promotion Analysis Sales Receipts Sales Receipts - Generic Airline Boarding Pass Dutch Railways Malaysia TK Maxx School Management Systems School Print Shops School Reporting in Chile Schools Sports Tournaments Scientific Research Scuba Diving Search Engine Search and Rescue Equipment Search for a Data Model Search for Items in Newspapers Search for Job Skills Search for Musicians in Articles Security Guards Self-Service BI Self-Service Commodities Exchange SelF-Service Data Analysis Self-service Data Governance Self-Service Data Platform Self Service Digital Transformation Self Service Learning Self-Service Procurement Self-Service Vacations Self-Service World-Wide Data Platform Semantic and Best_practice Digital Transformation Semantic and Linked Data Semantic Building Blocks Semantic Enquiries Semantic Language Semantic Layer and Commodities Exhange Semantic Layer and a Welsh Dictionary Semantic Layers Semantic Layer (Universal) Semantic Project Semantic Model (Microsoft BI) Semantic Models Senior Citizens and OAPs Separation of Duties Septic Tanks Service Assessment Service Call Tracking Service Delivery Platform Service Delivery Platforms (Layered) Service Magic Professionals Service Request Calls Service Requests Platform (OSS) Services for Certification (& Tutorial) Services Job Scheduling Sewing Rooms Shipping Companies Shipment Logistics Ships Stores Logistics Shipwrecks in Australia Shoppers Recommendations Shopping Malls Show Business Ballet Companies CD Collection Circus Clown Registry Dance School Talent Agencies Theater Bookings Theater Company Theme Park and Visitor Activity Theme Parks ticketmaster Shower Screens Manufacture (for Nimble Elephant Book) Showcase Models Shrek2 Movie Simplification of Data Modelling Single Sign-on (SSO) Singapore Water Treatment Single View of a Customer Skills and Authorisations Stamps Skills Tracking Slowly Changing Dimensions s Small Shops (Frozen Yoghurt) Small Town Life Smart Cities and Global R and D Smart Clothes Smart Homes Smart Meters SMBs SMBs (Cloud Services) Snowflake Schema SOA SOA Data Governance Social Anthropology Coping with Life Middle-East Conflict Quality of Life Usual Suspects Social Capitalist Awards Social Media Social Media Monitoring Social Networking Sites Social Workers Case Mgt Software License Management Soil Type Classifications Solvency II Sony Computer Entertainment Europe Sony Corporation Spam and Junk Mail Spatial Temporal Databases Special Interest Models Canonical Data Model Gym Management (& Tutorial) Occupational Health Omni Channel Retailing Retail Banking in the Clouds Special Interest Events Special Needs Placements Spelthorne Business Competition Sperm Banks Sports Card Collecting Sports Centers Spreadsheet Reports SQL Server 2008 Staff Movements Staff Training (Tracking) Stag Beetles Starbubble Cafe, Eindhoven, Holland Starcraft 2 Star Design for Teaching Schedule Star Design for Transaction Star Schema Stamp Collections Stock Control Fuel Stock Stock Control (Retail Store) Stock Control (Sports Centers) Stock Exchanges Stockmarket Data Stop Smoking Services Strawberry Exports Street Cleaning Schedules Street Traders Streets and Residents Students :- Achievements and Assessments Alumni Web Portals Analytics Behavior Monitoring Church Sunday Schools Class Scheduling Credit Accumulation (Europe) e-Learning High School Football Online Exams School Catering Businesses School Management Systems Schools Sports Tournaments School Timetables Student Accommodation Student Activities Student Applications Student Assessments (Simple) Student Assessments (Complex) Student Assignments Student Athletes Student Exams Student Exams in Saudi Student Fees Collection Student Fitness Tests Student Information Systems Student Internships Student Loans Student Marking Student Master Index Student Placements Student Questionnaires Student Registration Student Rosters Student Transcripts Tracking Student Work Placements Students from Wyoming University Course Catalogs University Gymnastics University Organisation Studio Rental (Audio) Subject Areas Accounts Addresses and Parties Contracts Customers Customers and Payments Customers Addresses and Payment Methods Customers Master Data Deliveries Finance Insurance Investment Banks Invoices and Payments Local Government Parties Payments and Invoices Payments Subject Area Payments for Wholesale Banks Procurement Products Product Catalogs Promotions Reference Database Reference Data Manager Reservations Retail Suds Sue Grafton's Alphabet Mysteries Surveyors and Contacts Suggestions Schemes Supply Chains Supply Chains - Retail Supply Chains - Retail Mgt Summer Camps Swimming Clubs Swiss Census Swiss Customs Symptoms and Diseases System Architect :- Data Warehouse Data Dictionary Generic Customer Model Hotel Reservations National Trust Visitors Talent Agencies Tanning Salons Task Logs (Knowledge Management) Tax Receipts Taxi Service Technical PC Support Telecomms Telemarketing Telephone Bills Tenant Contact Tracking Tender Management Tennis Championships (Wimbledon) Tennis Club Management Teradata :- Communications Data Model Financial Services LDM Solvency II Risk Data Infratructure Travel and Hospitality Model Unified Data Architecture Terrorism Terrorists (Tracking) Terrorists (Tracking Domestic UK) Theater Bookings Theater Company Theme Park and Visitor Activity Theme Parks Things to Buy and Sell Third Generation Platform for Professional Services Ticket Purchases in Groups Ticketing Systems Ticketmaster Time Dimension Models Timesheets Timesheets and Customers Toilets (Tutorial) Tour Guides Tourist Guide for Claygate Towns and Villages TPC-DS (Benchmarks) Tracking :- Tracking Chemicals in a Lab Tracking Customer Consent Tracking Customer Orders Tracking Customer Shipments Tracking Document Destruction Tracking Employee Time Tracking Evidence Tracking Exam Proctors Tracking Farmers Payments Tracking Film Rights Tracking First Aid Kits Tracking Grants for Research Tracking Grants for Skills Development Tracking Inspection Equipment Tracking Inventory for Restaurants Tracking Locks and Keys Tracking Logistics and WIP Tracking Lost Racing Pigeons Tracking Logistics and WIP Tracking Machines and Counters Tracking Manufactured Items Tracking Manufacturers Orders Tracking Medical Results Tracking Multiple Job Payments Tracking People in Offices Tracking Petroleum Shipments Tracking Printer Cartridges Tracking Processes and Steps Tracking Projects:- Idea in You Marketing Funnels Project Proposals Tracking Progess in Training Tracking Progress on Projects Tracking Property Tax Appeals Tracking Results of Treatment Tracking Search and Rescue Equipment Tracking Share Transactions Tracking Shipping (& Tutorial) Tracking Software Problems Tracking Software Registration Tracking Staff Assignments Tracking Staff Training Tracking Subject Areas Tracking Telephone Calls Tracking Tenant Contacts Tracking Terrorists Tracking Terrorists in the Middle East Tracking Transport Facts Tracking Vehicles Tracking Village School Improvement Tracking Visits of Pharmaceutical Vendor Tracking Visitors to a Building Tracking Warehouse Movements Tracking Zoo Deliveries Trade Show Discussions Traffic Cops and Tickets Training Matrix Trains Public Transport Railway Level Crossings Railway Reservations Trains and Boats and Planes Train Spotters Train System Map Train Ticketing systems Trains and Boats and Planes Training Evaluation Transport for London Travel and Transport Airline Reservations Container Shipping Movements Railway Level Crossings Tour Guides Trains and Boats and Planes Transport (Public) Transportation and Shipments Travel Agencies and Bookings Travel Agents and Reservations Travel and Tourism Worldwide Travel and Transport (top Level) Travel Company Complaints Travel Routes Travel Terminals Travis Perkins Treatments for Natural Diseases Trouble Tickets Tree Farming and Conservation Turtle Conservation Tutorial From the Cradle to the Grave Tutorial on Charities Tutorial on Cloud Services Architecture Tutorial on Feeding Time at the Zoo (5 minutes) Tutorial on Database Schema Tutorial on Feeding Time at the Zoo (5 minutes) Tutorial on Toilets TV Electronic Programme Guides (EPGs) TV in the Shower TV Talk Shows TV's Made in Chelsea Types of Data Models Ubiquitous Data UK Council Planning Applications UK e-Govt Standard Data UML Class Diagrams UN Activities Analysis Platform UN Convention on Biological Diversity UN Global Compact UN Global Compact Platforms for 2017 UN ODC eLearning Uniforms on Loan Union Dues Union Grievances Universal Activities Universal Business Platform Universal Data Platform University Course Catalogs University Gymnastics University Organisation US Government Contracting US Government Organization US Presidential Transition 2017 USA Today State-by-State USDA Database Used Flutes Exchange User-Defined Hierarchies User-Extendable Database User-Extendable DataDictionary User Identity Management Customer Master Index (Local Gov't) LDAP Single View of the Customer User Identity Management User Groups User Portals User Portals and KPIs User Portals and Links User Profiles User Services Platform Users and Shared Services Users and Entities Users, Portals, KPIs and Links User Reviews and Ratings User Roles User-Submitted Material Usual Suspects Conflict and Wars English Gentlemen Football Clubs Fox Hunting Wedding Parties Utilities Utilities Comprehensive Models Utility Bills Vegetable Garden Planner Vehicle Imports Vehicle Maintenance Vehicle Maintenance with Inheritance Vehicle Mileage Tracking Vehicle Manufacturers Vehicle Parts Manufacture Vehicle Registration Authority Vehicle Rental Vehicle Tracking Vending Machines Vertabelo Database Models 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 Village Competitions Virus Research Visitor Management System Visits to Church Food Pantry Volcanoes (Visio & Dezign) Voluntary Organisations Voters and Elections Vulnerable People Warehouse Inventory Management Waste Management Waste Management Research Waste Skip Hire Water Bills WM_Final Weather Reporting Wealth Management Wearable Technology Web Sites Web 2.0 Web Portal Navigation Web Site for a Community Web Site for DBA Site Web Sites for Hobbies and Pastimes Web Site Analytics Web Site Message Board Web Site Pages Web Site Registration Web Site Traffic Analysis Web Site User Plans Web Site Visits Weddings Wedding Parties Weighbridge Operations White House White Smoke in the Vatican Wholesale Banks Payment Systems Wildlife Parks Wills and Families Wimbledon Tennis Championships Wine Wine Cellars (ERwin) Wine, Food and Merchants (ERwin) Wine, Food and Pairings Wine Lists Wine Stores Wine, Vineyards and Roles Wiring Diagrams Woot Workflow Workout Programmes Worksheets Workshops (Facilitated) World Health Organization STD World Language Classification Yakuza Japanese Organised Crime Yale Modelling Research Yell (UK) Yoghurt Shops Young People and Social Services Youth Church Zip Codes in Mexico Zoos Zoo Feeding Time (5 minutes Tutorial) Our NEW UK Data Modelling Course Teaching and Research Ten of my Data Models are featured as Starter Databases for Microsoft SQL Server 2005 Express. My Data Models are helping Teachers and Students at Universities and Colleges around the world :- In Australia at the University of Wollongong In Malaysia in the IT Department at the International Islamic University of Malaysia In New Zealand, by Andrew Reynolds in the University of Canterbury. In Peru at the Catholic University of St.Mary In the States by Tami at University of Nevada at Las Vegas , by Professor Gigi Kelly at the University of Virgina, and by Katarina at Yale University In the UK at the University of Cambridge and North Hertfordshire College. If you are new to Databases, then check out my new Tutorial on Understanding a Database Schema. 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. © Database Answers Ltd. 2016 About Us Contact Us