Database Design Principles

Introduction to Database Design

Database design is the process of structuring data in a way that supports the requirements of an application or system.

CREATE TABLE customers (
 id INT PRIMARY KEY,
 name VARCHAR(255),
 email VARCHAR(255) UNIQUE
);

CREATE TABLE orders (
 id INT PRIMARY KEY,
 customer_id INT,
 order_date DATE,
 FOREIGN KEY (customer_id) REFERENCES customers(id)
);