Home / Database Examples

Database Examples

Browse through these database design examples including ERDs with Crow's Foot notation, normalization examples, and database design case studies.

E-Commerce ERD

Entity Relationship Diagram for an e-commerce system showing Customers, Orders, Products, and OrderItems with Crow's Foot notation.

ERD Example
Customer ──< Order
Product  ──< OrderItem
Order    ──< OrderItem

One-to-Many relationships

Normalization Example

Example of normalizing a table from 1NF to 3NF to eliminate data redundancy.

Before Normalization
Orders (order_id, customer_name, product_name, quantity, price)

Contains redundant customer and product data

University Database Design

Database design for a university system with Students, Courses, and Enrollments using many-to-many relationships.