Foundations of Database Design

Foundations of Database Design: Common Sense Design, Create Database Scripts.

Updated

  1. Common Sense Design (Journeyman): Plan a database from the questions it must answer, then split the data into tables of closely related columns, linked by primary and foreign keys.
  2. Create Database Scripts (Journeyman): Build a database in SQL with CREATE DATABASE, CREATE TABLE and ALTER TABLE, including primary keys, default values and foreign key constraints.