Skip to content

Database agnostic DB Script to create Northwind Data Model with some sample data

Notifications You must be signed in to change notification settings

mrin9/northwind

Repository files navigation

Basic SQL equivalent of Northwind schema

The Northwind database from Microsoft has a nice and simple schema that deals with with customers, orders, inventory, purchasing, suppliers, shipping, employees, and single-entry accounting.
This project is an attempt to create database agnostic srcript so that it can be reused in various other databases

Naming Convention used

  • Field names are in snake_case instead of CamelCase.
    • To facilitate some ORM frameworks (Hibernate/Spring Data) which uses field names to generate Java method names
    • Some databases and OS combination ignore case in field names therefore CamelCase dont make much sense
  • primary keys named id.
  • foreign keys constrained named as fk_table_name__reference_table_name.
  • All the column data types are valid with most databases

Two Datasets

  • Northwind Small (Few tables more data in each tables)
  • Northwind Extended (More Tables, More references, Less data per table)

Files

  • Northwind Small

    • schema.sql - DDL Statements (Table creation & Foreign Key definations)
    • data.sql - Insert statements to populate with sample data
  • Northwind Extended

    • schema_extended.sql - DDL Statements (Table creation & Foreign Key definations)
    • data_extended.sql - Insert statements to populate with sample data
  • NorthwindModel_MySQLWorkbench.mwb - This File can be opened with MySQLWorkbench, you may use it to generate schema script or model diagram

Schema Diagram

Northwind Small

Northwind Schema

Northwind Extended

Northwind Schema

About

Database agnostic DB Script to create Northwind Data Model with some sample data

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published