# Blood Bank Management System: Database & SQL Design
> Explore a comprehensive Blood Bank Management System database design, featuring ER diagrams, 3NF normalization, and practical SQL implementation queries.

Tags: database-design, sql-implementation, er-diagram, normalization, blood-bank-system, relational-database, dbms-project
## Blood Bank Management System Overview
* **Purpose:** A relational database application to manage the lifecycle of blood donation, screening, and distribution.
* **Scale:** Includes 10 tables, 10+ SQL queries, and supports 8 blood groups across 5 blood banks.

## System Architecture & Entities
* **Key Entities:** Donor, Donation, Screening Test, Blood Unit, Blood Bank, Staff, Hospital, Patient, Request, and Blood Issue.
* **Design Phases:** Conceptual (ER modeling), Logical (relational tables), and Physical (SQL implementation).

## Database Normalization
* **Goal:** Reduce redundancy and improve data integrity.
* **Standard:** Tables are normalized to the Third Normal Form (3NF).

## SQL Implementation & Schema
* **Primary Tables:** 
  * `Donor` (DonorID, Name, BloodGroup, Age, Phone)
  * `Donation` (DonationID, DonorID, DonationDate, Quantity)
  * `Blood_Unit` (UnitID, BankID, BloodGroup, Quantity, ExpiryDate)
* **Logic:** Implements primary and foreign keys to enforce referential integrity.

## SQL Queries & Data Retrieval
* **Basic Queries:** Standard SELECT statements for retrieving donor and patient records.
* **JOIN Operations:** Linking Staff with Blood Banks and Patients with Requests to combine cross-table data.
* **Aggregate Functions:** Using COUNT(), SUM(), and GROUP BY to calculate total donations by donor and available blood units by group.
---
This presentation was created with [Bobr AI](https://bobr.ai) — an AI presentation generator.