Relational Database Design Guides

Build a sound relational model by understanding normalization, cardinality, foreign-key relationships, joins, and the patterns used in real application schemas.

Guides in this topic

Database Normalization: 1NF, 2NF, and 3NF

Remove repeating groups, partial dependencies, and transitive dependencies.

Crow’s Foot Notation and Cardinality

Read optionality and one-to-one, one-to-many, and many-to-many relationships.

SQL JOIN Types Explained

Connect the logical model to INNER, LEFT, RIGHT, FULL, and CROSS JOIN queries.

Database Schema Examples

See keys, constraints, and relationships working together in five schemas.