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. There are over 900 very useful 'Kick-Start' Data Models that I have created since I started about 10 years ago,   and here's the Top 20 My Data Models are used in teaching Databases at the University of Cambridge 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 Accident Management Accident Reports and Tickets Accidents at Work Accommodation (Long-term) Accounting Systems 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 Air Transport Aircraft Parts and Orders Airline Reservations Airport Management Aircraft Parts and Orders Airline Reservations Airport Management Allotments Amazon and Starbucks Animal Shelters Animal Welfare Apartment Rentals Aquarium Stores Area Regulations Archeology Archeological Site Conservation Portable Antiquities Scheme Archimate Model for Insurance Claims Ars Digita BootCamp Art Exhibitions Art Galleries Art Galleries (Online) Asbestos Surveys Assets Maintenance Association Management Asylum Seekers and Refugees Athletes and Events Athletes and Teams ATM Machines Auction Web Site Audit of Projects 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 Customers and Orders Customers and Services Marriages (Contemporary) Marriages (Traditional) Organisations, People and Events Partnerships and Relationships Product Catalogs Reservations Bank and Branches Banking Acquisitions Banking Data Warehouses Banking (Online) Banking (Private) Bankrupts Baseball Umpire Scheduling Basel II Accord BBC (UK) Behavior Monitoring Best Practice Best Practice and User Events Bicycle Rental Bidders and Buyers Bikes and Customisation Bill of Materials Bills - Telephone Bills - for Utilities Bird Research Births, Deaths and Marriages 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 Breeding Cattle Breeding Dog Breeding Pigeon Breeding Brookfield Global Relocation Services Business 2 Business e-Commerce Business 2 Consumer e-Commerce Business Directories Call Centers Canal Trips Cancer Screening Canonical Data Models Car Dealership Car Hire Car insurance and Claims Car Park Security Car Parking Enforcement Car Parts Suppliers Car Sales Car Service Center Cardiac Catherization Registry Carphone Warehouse Case Management (Lawyers) 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 Results Charities and Appeals Charities (Just Giving) Chemical Dependency Providers Chess Tournaments Children ... Children and Families Support Children in Institutions (UNICEF) Children's Aid Rcds Mgt Children's Charities Flights Children's Clinics Children's Common Assessment Framework Childrens Lives Children's National Database Children's Playgroup Church Donations Church Members (Visio) Church Missionaries 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 Clinics and Pharmacies Cloud Computing Clown Registry Club Members CMDB - Configuration Mgt DB Coach Trips Coding 4 Fun Projects Commercial Web Sites ... Avon Cosmetics Brookfield Global Relocation Services Cirque du Soleil Dice (Job Seekers Web Site) Dog Whisperer eBay Deals Financial Services Authority Gearhead Outfitters Gumtree IMDB (Internet Movie DB) Just Giving (Charity) Linked In MyLifeBits Research NewEgg Regus Office Accommodation SalesForce Shrek 2 Movie Star Craft 2 Game Ticketmaster Woot Yell (UK) 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 Complex Event Processing Computer Sales (Dell) Conference Centers Conference Proceedings Conference Proceedings Management Conservation of Historic Objects Construction and Manufacturing Construction Jobs Bidding Consultants and Clients Consultant Search Web Site Consumer Packaged Goods (CPG) Contacts and Products Contact Management Container Shipping Contract Management Contract Staff Agencies Corporate Intranet Cosmetics Home Sales Course Catalogs Cow's Events CraigsList Credit Accumulation (Europe) Criminal Record Keeping Crisis Call Centers CRM CRUD - Create,Read,Update,Delete Cruise Liners and Passengers Cruise Ship Adminstration CSR Framework CVs and Job Histories (Visio) Dance School Data Architecture Data Dictionary Data Management ... Data Integration Data Mart Case Studies Data Mashups Data Warehouse ... Customers and Purchases eCommerce Data Warehouse Loading a Data Warehouse Data Warehouse Loading (Alt) 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 Dell Computer Sales Department Store Diabetes Diagnosis and Treatment Diet Decision Support System Dietician's Consulting Practice Dictionaries for Foreign Languages Digital Challenge (UK) Diseases and Symptoms Doctor's Practice Document Control Systems Document Management (Basic) Document Management Generic Document Management (Specific) Document Publication Document Template Management Document Workflow Dog Breeding Dog Kennels Dog Whisperer Domestic Violence Centers Donations :- Church Donations Library Donations Drinks in a Sports Bar Driver Recruitment Agencies Drivers Citations Log Drivers Education Driving School Driving Test Scores Database Dry Cleaners Earth-Moving Equipment Education :- Educational Networks 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 eBay Deals e-Commerce B2B e-Commerce B2C e-Commerce Customers, Campaigns and e-Commerce e-Commerce Games Web Site Online Art Galleries 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 Data Models Air Travel BMEWS BI Container Shipping Insurance Investment Banks Local Government Retail Enterprise Information Repository Data Migration Mapping Generation of Entities Glossary of Business Terms Glossary with Queries Entertainment Entity-Attribute-Value (EAV) Environmental Impact Assessment EPOS Equipment Maintenance Equipment Repair Estimating Development Costs ERP ERWin Models Circus Job Scheduling 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 Event Planning Event Processing (Complex) Event Registrations Event Reservations Events and Staff Training Events in a Cow's Life Experts and Questions Facebook and Social Networking Sites Facebook App Invitations Facilities Assignment Facilities and Inspections FAQs Families and Wills Family Advocacy Farm Management Farms and Cow's Events Fashion Boutiques Father of all Data Models Father of all Data Warehouses FBI Global Database Feedback Feedback and Complaints File Archiving Systems Financial Global Custody Financial Portals Financial Services Authority 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 Future of Databases 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 Management Systems 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 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 Jobs Customers and Loans Customers and Loyalty Customers and Memberships 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 (Basic) Customers and Services (Advanced) Customers and Shoppers Recommendations Customers and Telemarketing Customers and Water Bills Customer Class Scheduling Customers Comm & Personal Customer Data Customer Data Catalog Customer Journey Mapping Customers (Commercial & Personal) Customers (Retail) Customer MetaData Repository Customer Metrics Customer Order Tracking Generic Customer Model (Popkin) Gambling (Online) Gaming Games Features Games Store Gaming - Generic Gaming Leagues Gaming - Specific - Gears of War Gaming - Specific - Table Top Gaming Web Sites Shrek Movie Garbage Collection and Recycling Genealogy and Family Trees Generic Data Models Childrens Lives 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 & Events Organisations,Members & Meetings Patient Care Reservations Retail 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 Custody Global Law Firm Global Project Management Global Relocation Services Global Reference Database Global Retail Marketing Golf Club Management Golf Course Maintenance Golf Course Maintenance Employee Tasks Golf Memorabilia Golf Tournaments Google AdSense Google Analytics Google Android Phone Platform Greyhound Training GRI Indicators GRI Repository GRI User's Portal Grocery Store Grocery Store Shelves Gumtree 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 Games 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 Hotels and Tourist Attractions HR or Personnel Department Houses and Rooms IAA Insurance Party Icons of the Western World IMDB (Internet Movie DB) Import/Export Logistics Importing Client Data Indigenous Peoples Industry Specific CRM and Customers e-Commerce Education Entertainment Health and Fitness Law Enforcement Students Transport and Travel Inheritance Models Births, Deaths and Marriages Charities City Tourist Guide CMDB - Configuration Mgt DB Customers Commercial and Personal Event Registrations Games Store Icons of the Western World 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 Union Grievances Vehicle Imports Inspections of Facilities Insurance Insurance Applications Insurance Brokers Insurance and eClaims Insurance Policies - Car, Home and Life Insurance Claims (in Archimate) Insurance Data Warehouses Insurance (General) Insurance (Personal) Insurance Policies and Claims Intelligent Environments Intelligent Transport Systems 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 Furniture Inventory of IT Assets Inventory of Rental Equipment Inventory of Servers Inventory of Ship's Stores Inventory of Tooling Equipment Investment Banking Accounts Customers Financial Services Authority FX Deals Global Custody Settlements 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 Mobile Apps Stores 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 Media Items Library for Haidar Salim in Iraq 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 Linked In Limousine Services Loading a Data Warehouse Loading a Data Warehouse (Alternate) Loan Management System Loan Management Consolidation Local Favourites Local Govt (UK) Local History Societies Logistics :- Corporate Defense Freight Forwarders Movements Shipments Ships Stores Long Term Accommodation Lost and Found Pets Loyalty and Customers LSC Framework for Excellence Machinery Diagnostics 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 Manufacturers Vehicle Parts Manufacture Maritime Models :- Freight Forwarders Harbour Management Marine Archeology Maritime Museums Scuba Diving Swimming Clubs US Navy Marriages Mashups Matching Writers Names Master Data Management Me and Mommy Me and Mommy (a Tutorial) Media Libraries 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 Clinics and Pharmacies Medical Laboratories Medical Laboratories with Payments Mortuaries Natural Disease Treatments Nurses Roster Nursing Home Patient Care Patient Data Warehouse Patient Tests Patients Visits to the Doctor Pharmacies and Generics Pharmacies and Prescriptions Pharmaceuticals Data Warehouse Pharmaceutical Supplies Prescriptions Database Stop Smoking Services Symptoms and Diseases Medical Laboratories Mentoring Naval Officers Message Board for a Web Site MetaData Management MetaData Repositories MetaData Repository (Customer Data) Middle East Conflict Missionaries Mobile Police Application Modelling Agency Money Exchange for Students Mortuaries MP3 Music Site Movie Making Multi-Level Marketing Multi-Media Publication Multi-Resource Scheduling 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 Musicians Uniforms MVC Model-View-Controller myDBA User Interface 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 Newsstands Night Clubs Nomadic Tribes Not For Profits (NfPs/NPOs) Nurses Roster Nursing Home My Life Offenders and Movements Office Accommodation (Regus) Offshore Drilling Equipment Olympic Games 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, Meetings and Minutes Organisations,Members & Meetings Package Delivery Service Paintings on Loan Parking Space Registration Parking Tickets Parties and Products Partners in a Firm Partnerships and Relationships Parts and Distributers Passengers on a Cruise Patient Care Patient Tests 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 Pigeon Breeding Pizza Deliveries Plane Spotting Planets in the Solar System 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 Printer Cartridge Tracking Prisons and Prisoners Private Banking Products :- Bill of Materials Product Catalogs (Simple) Product Catalogs (Complex) Product Catalogs for Paint Product Categories Product Characteristics Product Distribution Product Hierarchies Product Servicing Products and Manufacturers Products and Pricing Products and Security Products for Hire Products, Orders and Deliveries Product Catalogs (Commercial) :- Hotel Chocolat Comvita TK Maxx Wine Lists Project Audits Project Mgt Methodologies Project Planning Project Staff Properties (National Trust) Properties (Real Estate) Property Development Property Tax Appeals Proposals, Projects & Donors Pub Quiz League Pubs and Parties Public Transport Publish and Subscribe (Simple) Publish and Subscribe (Complex) Purchase Orders Purchase Orders for Cars 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 Recruitment Agencies (Drivers) Recycling and Garbage Collection Reference Database Reference Data Manager Refugees & Asylum Seekers Removals Companies Repair of Equipment Report Generators Reservations :- Apartment Rentals Airline Reservations Car Hire Cinema Bookings Coach Trips 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 Ticketmaster Vehicle Rental Resources Requesters Restaurant Bookings Restaurant Delivery Service Restaurant Events Bookings Retail Banks Retail Customers Reviews and Ratings Risk Management (UML) Roles Inheritance and Subtypes Rose's Cantina Sailing Club Sales Commissions Sales (Computer - Dell) 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 Call Tracking Service Magic Professionals Service Request Calls Services Job Scheduling Sewing Rooms Shipping Companies Shipment Logistics Ships Stores Logistics Shoppers Recommendations Shopping Malls Show Business Ballet Companies CD Collection Circus Clown Registry Dance School Talent Agency Theater Company Theme Park and Visitor Activity ticketmaster Showpiece Models Generic Retail Inventory of Furniture Shrek2 Movie Single View of a Customer Skills and Authorisations Stamps Skills Tracking 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 Soil Type Classifications Spam and Junk Mail Spatial Temporal Databases Special Needs Placements Sperm Banks Sports Card Collecting Sports Centers Spreadsheet Reports SQL Server 2008 Staff Movements Starcraft 2 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 :- Achievements and Assessments Behavior Monitoring Church Sunday Schools Class Scheduling Credit Accumulation (Europe) e-Learning High School Football 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 Information Systems Student Internships Student Loans Student Placements Student Questionnaires Student Registration Student Rosters Student Transcripts Tracking Student Work Placements University Course Catalogs University Gymnastics Surveyors and Contacts Suggestions Schemes Swimming Clubs Swiss Census Symptoms and Diseases System Architect :- Data Warehouse Data Dictionary Generic Customer Model Hotel Reservations National Trust Visitors Talent Agency Tanning Salons Task Logs (Knowledge Management) Tax Receipts Taxi Service Technical PC Support Telecomms Telemarketing Telephone Bills Tenant Contact Tracking Tennis Club Management Theater Company Theme Park and Visitor Activity Ticketmaster Timesheets Tour Guides Tracking :- Tracking Customer Orders Tracking Evidence Tracking Grants for Research Tracking Grants for Skills Development Tracking Machines and Counters Tracking Manufactured Items Tracking Manufacturers Orders Tracking Printer Cartridges Tracking Property Tax Appeals Tracking Share Transactions Tracking Software Problems Tracking Software Registration Tracking Tenant Contacts Traffic Cops and Tickets Travel and Transport :- Container Shipping Tour Guides Transport (Public) Transportation and Shipments Travel Agencies Travel and Tourism Worldwide Travel Company Complaints Treatments for Natural Diseases Trouble Tickets TV Electronic Programme Guides (EPGs) TV Talk Shows Tutorial on Database Schema Ubiquitous Data UK e-Govt Standard Data UML Class Diagrams UN Global Compact Uniforms on Loan Union Grievances University Course Catalogs University Gymnastics 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 Groups 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 Manufacturers 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 Virus Research 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 Wine, Food and Merchants Wine Lists Wiring Diagrams Woot Workflow Worksheets World Health Organization STD World Language Classification Yell (UK) 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