# 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: November 16, 2026

## [Foundations of Database Design](https://www.ask-codey.com/courses/java-full-stack-bootcamp/topics/foundations-of-database-design)

1. [Common Sense Design](https://www.ask-codey.com/lessons/foundations-of-database-design-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](https://www.ask-codey.com/lessons/foundations-of-database-design-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.

Source: https://www.ask-codey.com/courses/java-full-stack-bootcamp/chapters/database-design
