Database Design

Database Design Documentation

Overview

This document describes the database design implementation for our project. The design follows database normalization principles to ensure data integrity and optimize storage.

Visual representation of our database structure

Design Implementation

Normalization Approach

The database structure follows the following normalization rules:

1. First Normal Form (1NF): Each column stores single, atomic values. Each row must be unique (e.g. by being given a unique ID).
2. Second Normal Form (2NF): Each data column must depend on the WHOLE primary key (not just part of it).
3. Third Normal Form (3NF): Non-key columns cannot depend on other non-key columns (no transitive dependencies).