Database Design

Relational databases are organized into tables that are related to each other. Creating a well-organized database requires planning. A good database design helps optimize storage and improve query performance.

Updated

Foundations of Database Design

  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.