Foundations of Database Design
Foundations of Database Design: Common Sense Design, Create Database Scripts.
Updated
- 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.
- 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.