Sample Database Design Proposal Download
Design Your Own Database Concept to Implementation or How to Design a Database Without Touching a Computer The following is an aggregation of several online resources with a bit of personal insight and experience thrown in for good measure.m Keys to Successful Database Design Planning, Planning, and Planning. Oh did I mention Planning?
We use the Northwind database as the SQL sample database in all our SQL tutorials. Northwind is a fictitious company that imports and exports food globally.
The Northwind sample database provides you with a good database structure and sales data that help you experiment with SQL statements quickly.
The following database diagram illustrates the Northwind database structure:
You can download the following printable version for A4 paper.
Database tables
Database Design Project Proposal
Example Of Database Design Proposal
The following explains each table in the Northwind database:
Database Proposal Sample
- Customers – stores customer master data
- Orders – stores transaction sale orders from customers
- OrderDetails – stores line items of sale orders
- Products – stores products master data
- Suppliers – stores suppliers master data
- Shippers – stores shippers master data
- Region – stores region master data
- Territories – store territories master data
- Employees – store employees master data
- EmployeeTerritories – store relationship between employee and territory.