Here are some useful 'Kick-Start' Data Models that I have created since I started 3 years ago. If you would like an Access Database for any of these Models, let me know (but specify a Subject otherwise your email will be treated as spam). Here's a Design Note     I have also added a Data Model Search facility.    Why do I do this for free ? I would appreciate your comments on my new Tutorial on Data Modelling. Accidents at Work Accommodation (Long-term) Act! Contact Management Afghanistan Rainfall Aircraft Parts and Orders Airline Booking Apartment Rentals Area Regulations Archeology Ars Digita BootCamp Assets Maintenance Asylum Seekers and Refugees Athletes and Events Athletes and Teams ATM Machines Auction Web Site Avon Cosmetics 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 Bankrupts Basel II Accord Best Practice Bidders and Buyers Bill of Materials BMEWS Bookstore Bookstore and Warehouses Books and Libraries Business 2 Business e-Commerce Business 2 Consumer e-Commerce Call Centers Car Dealership Car Hire Car Parts Suppliers Car Sales Car Service Center Case Management Casinos CD Collection Charities Childrens National Database Chess Tournaments Church Members (Visio) Cinema Bookings (Dezign) City Licences City Tourist Guide Click Stream Analysis Clients and Consultants Clients and Fees Clients and Locations Clinical Trials Clown Registry Club Members Coach Trips Commercial Web Sites ... Avon Cosmetics eBay Deals Raiser's Edge Charities SalesForce Shrek 2 Movie Ticketmaster Communities ... FAQs and Newsletters Personalization Philip Greenspun Publish/Subscribe & KPI Portal User Registration Construction and Manufacturing Consultants and Clients Consultant Search Web Site Contacts Contract Management Corporate Intranet Cosmetics Home Sales Crisis Call Centers CRM and Personalization CRM - Microsoft's Data Model (looks terrible). CSR Framework CVs and Job Histories (Visio) Data Architecture Data Dictionary Data Warehouses ... eCommerce Data Warehouse Loading a Data Warehouse Snowflake Design for Transaction Star Design for Teaching Schedule Star Design for Transaction (Conceptual) Star Design for Transaction (Physical) Dating Sites Day Care Centers Department Store Dietician's Consulting Practice Dictionaries for Foreign Languages Doctor's Practice Document Management - Generic Document Management - Specific Document Publication Driving School Education and Students :- School Management System Student Assignments Student Athletes and Teams Student Exams Student Loans Student Work Placements Customers :- Clients and Fees Clients and Locations CRM Customer Metrics CRM and Personalization CRM Top-Level Architecture CRM Top-Level Overview 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 e-Commerce Customers and Car Hire Customers and Car Sales Customers and Car Servicing Customers and Dept Stores Customers and Deals (UML) Customers and Deliveries Customers and Games Shops Customers and Hairdressers Customers and Hardware Store Customers and a Health Center Customers and Insurance Customers and Loans Customers and Orders Customers and Phone Bills Customers and Products Customers and Services Customers Card Transactions Customers Comm & Personal Customer Data Customer Data Catalog Customers (Commercial & Personal) Customer MetaData Repository Customer Metrics Customer Order Tracking Generic Customer Model (Popkin) eBay Deals e-Commerce Games Web Site Orders & Shipments Photo Catalogs e-Government Employment Agencies Enterprise Information Repository Data Migration Mapping Generation of Entities Glossary of Business terms Glossary with Queries EPOS ERP Event Reservations Father of all Data Models. Financial Information Portal Foreign Language Dictionaries Franchise Operators Fund Raising Games Features Games Store Genealogy Family Tree Generic Data Models Customers and Services Document Management Father of All Models Generic Foundation Organisations and People Organisations and Transactions Patient Care Places, Players & Events (1) Places, Players & Events (2) Reservations Transport User-defined Hierarchies George Orwell's 1984 Global Accountability Global Community Global Consulting Global Law Firm Global Reference Database Golf Club Management Golf Tournaments GRI Indicators GRI Repository Hairdressers Appointments Hardware Sales Health Centers Health Clubs Health Insurance Claims Help Desk Hierarchies & Trees Employees Organization Hierarchies Preferences Product Hierarchies Reference Data Manager User-Defined Hierarchies Vehicle Parts Manufacture World Language Classification (with Oracle CONNECT BY) Hospice Patient Care Hospital Admissions Hotel Reservations HR or Personnel Department Houses and Rooms IAA Insurance Party Inheritance Models Charities City Tourist Guide Customers Commercial and Personal Games Store Insurance Brokers Libraries for Lawyers National Trust (UK) Photo Catalogs School Management System Shrek 2 Movie Insurance Brokers Inventory Control Inventory Control (Files in Boxes) Inventory Control (Manuals) Inventory Control (Publishing) Inventory Control (Retail Store) Inventory Control (Sports Centers) Inventory of Servers Investment Banking Job Scheduling Job Scheduling (2) Justice Department Key Performance Indicators Kitchen Cabinets Knowledge Management Land Registry Landscape Gardening Law Enforcement Case Management Justice Department Lawyers, Cases and Bills Libraries for Lawyers Prisons and Prisoners Tracking Evidence Traffic Cops and Tickets Legal Case Management Libraries Libraries and Books Libraries for Lawyers Libraries for Teachers Loan Management System Local Govt (UK) Long Term Accommodation Mail System Maintenance Contracts :- For Products with no Parts For Products with Parts (Dezign) Manuals at Locations Medical :- Dietician Practice Doctor's Practice Health Center Health Insurance Claims Hospice Patient Care Hospital Admissions Nursing Home Patient Care Pharmacies and Generics Pharmacies and Prescriptions Pharmaceutical Supplies Message Board for a Web Site MetaData Management Modelling Agency MP3 Music Site Museums (Simple) Museums (Complex) Musicians in Newspapers Musicians in a Band National Trust (UK) Newsagents Newsletters Not For Profits (NPOs) Nursing Home Offshore Drilling Equipment Olympic Sports Oracle Data Dictionary Oracle Database Rpt Oracle PL/SQL Orders and Parts Organisations and People Organisations and Transactions Package Delivery Service Parking Space Registration Parties and Products Partners in a Firm Patient Care Payrolls Performance Monitoring Personalization Personal Insurance Pharmacies and Generics Pharmacies and Prescriptions Pharmaceutical Supplies Philip Greenspun's Communities Phone Bills Photo Catalogs (e-Commerce) Picture Library Pizza Deliveries Popkin System Architect :- Data Warehouse Data Dictionary Generic Customer Model Hotel Reservations National Trust Visitors Portals Portals and KPIs Prisons and Prisoners Products :- Bill of Materials Product Catalogs Product Categories Product Characteristics Product Distribution Product Hierarchies Product Servicing Products and Security Project Planning Project Staff Properties (National Trust) Properties (Real Estate) Proposals, Projects & Donors Pub Quiz League Pubs and Parties Questionnaire - Complex Analysis Questionnaire Health History Questionnaire - Analysis Questionnaire - Simple Analysis Questionnaire - Very Simple Railway Reservations Real Estate Agents Real Estate Rentals Real Estate Sales Real World Series Generic Real World Real World of CSR Real World of Entertainment Real World of Insurance Real World of Sports Recipes Record Label Recruitment Agencies Reference Database Reference Data Manager Refugees & Asylum Seekers Removals Companies Reservations :- Apartment Rentals Car Hire Cinema Bookings Coach Trips Driving School Event Reservations Hairdressers Appointments Health Centers Hotel Reservations Railway Reservations Restaurant Bookings Sports Centers Ticketmaster Vehicle Rental Resources Requesters Restaurant Bookings Restaurant Delivery Service Risk Management (UML) Sailing Club Sales Force.com (ERWin) Sales Promotion Analysis School Management System Search Engine Search for a Data Model Search for Musicians in Articles Search for Items in Newspapers Service Assessment Show Business Ballet Companies CD Collection Circus Clown Registry Talent Agency ticketmaster Shrek2 Movie Snowflake Design Sports Centers Star Design for Teaching Schedule Star Design for Transaction Stock Control Stock Control (Retail Store) Stock Control (Sports Centers) Stockmarket Data Student Assignments Student Athletes Student Exams Student Loans Student Work Placements Talent Agency Tax Receipts Taxi Service Technical PC Support Telephone Bills Tenant Contact Tracking Theater Company Ticketmaster Tracking Customer Orders Tracking Evidence Tracking Software Problems Tracking Tenant Contacts Traffic Cops and Tickets Transportation and Shipments UML Class Diagrams UN Global Compact Used Flutes Exchange User-Defined Hierarchies User Portals User Portals and KPIs User Profiles Vehicle Mileage Tracking Vehicle Parts Manufacture Vehicle Rental Video Purchase Video Rental Volcanoes (Visio & Dezign) Web Site for a Community Web Site for DBA Site Web Site Analysis Web Site Pages WebSite Registration Web Site Traffic Analysis Workflow Worksheets World Health Organization STD World Language Classification 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 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.