> For the complete documentation index, see [llms.txt](https://docs.arkannis.net/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.arkannis.net/database/general-sql/sql-database-design.md).

# SQL Database Design

## Database Design Principles

* Duplicate information is bad
* Accuracy & Completeness is good

## The Design Process

* Determine the database purpose
* Discover and collect information
* Divide the entities into tables
* Turn the data points into columns
* Identify primery & forign keys
* Normalize & refine