Database Projects

This repository is a collection of relational database design exercises built around real-world application scenarios. Each project demonstrates core database engineering principles across different domains, including entity-relationship modeling, relational schema design, normalized SQL implementations, performance optimization, and supporting documentation.

• Entity-Relationship Diagrams (ERD) & Relational Schemas
• Normalized Database Architecture (1NF to 3NF)
• SQL Implementation Scripts (DDL, DML, Indexes, Views)
• Database Backup Files & Runnable Samples

Project Timeline

---

Workspace Overview

The repository is organized as a collection of independent project folders. Each folder contains ERD and relational diagrams, SQL scripts (schema creation, seed data, views, indexes), project documentation, and working database backup deliverables.

Currently, Project 1 (Simple Clinic), Project 2 (Simple Library), Project 3 (Karate Club), Project 4 (Car Rental), and Project 5 (Online Store) are fully completed and serve as comprehensive reference designs.

---

Projects Summary

Project	Status	Description
Project 1 – Simple Clinic	Complete	Healthcare clinic database managing patients, doctors, appointments, medical records, prescriptions, and billing/payments.
Project 2 - Simple Library	Complete	Library management system tracking books, physical copies, authors, user profiles, borrowing history, holds/reservations, and fine tracking.
Project 3 - Karate Club	Complete	Karate club database managing members, instructors, belt ranks, testing, subscriptions, and financial payments.
Project 4 - Car Rental	Complete	A relational database design for a Car Rental management system managing vehicles, customers, rental bookings, vehicle returns, and transactions.
Project 5 - Online Store	Complete	Online store database managing products, customers, orders, payments, shipping, and reviews.

---

Completed Projects at a Glance

Project 1: Simple Clinic Database

A complete healthcare provider system implemented in SQL Server, centered around patient care and appointment workflows.

• Core Domains: Shared identity (Person), Patients, Doctors, Appointments (6 status states), Medical Records, Prescriptions, and Payments.
• Key Deliverables:
  • README
  • DDL.sql
  • DML.sql
  • Index.sql
  • Views.sql
  • Simple_Clinic_Database.bak
  • ERD Diagram | Relational Schema

Project 2: Simple Library Database

A relational database system modeling library inventory management, member borrowing, and overdue penalty calculations.

• Core Domains: Catalog (Books, Authors, AuthorWritings), Physical Inventory (BookCopies), Member Management (Users, Phones, Email), BorrowingRecords, Reservations, Overdue Fines (Fine), and Policy Settings.
• Key Deliverables:
  • README
  • DDL.sql
  • DML.sql
  • View.sql
  • Simple_Library Database
  • ERD Diagram | Relational Schema

Project 3: Karate Club

A relational database system modeling Karate Club membership, instructor assignments, belt testing, and payment tracking.

• Core Domains: Membership (Persons, Members, Emails, Phones), Instructors (Instructors, Qualifications, MemberInstructors), Ranks and Testing (BeltRanks, BeltTests), and Financials (Payments, Subscriptions).
• Key Deliverables:
  • README
  • DDl.sql
  • DML.sql and DML2.sql
  • Views.sql
  • Karate_Club Database.bak
  • ERD Diagram | Relational Schema

Project 4: Car Rental Database

A relational database design for a Car Rental management system managing vehicles, customers, rental bookings, vehicle returns, and transactions.

• Core Domains: Vehicle Management (Vehicles, VehicleCategories, FuelTypes, Maintenances), Customer Management (Customers), Rental Booking (RentalBookings, VehicleReturns), and Billing (RentalTransactions).
• Key Deliverables:
  • README
  • DDL.sql
  • DML.sql
  • Views.sql
  • Car_Rental Database.bak
  • ERD Diagram | Relational Schema

Project 5: Online Store Database

A relational database design for an online store management system managing products, customers, orders, payments, shipping, and reviews.

• Core Domains: Product Catalog (Products, ProductCategories, Images), Customer Management (Customers, Reviews), Order Management (Orders, OrderItems, OrderStatuses), and Logistics/Financials (PaymentTransactions, Shippings, ShippingStatuses).
• Key Deliverables:
  • README
  • DDL.sql
  • DML.sql
  • Views.sql
  • Online_Store Database .bak
  • ERD Diagram | Relational Schema

---

Standard Project Structure

Every project in this repository follows a consistent layout to enable clear comparison across business domains:

• README.md — Detailed requirements coverage, entity definitions, and design notes.
• DDL.sql — Schema definition script (tables, primary/foreign keys, constraints, default values).
• DML.sql — Seed script populating realistic test data across all tables.
• Index.sql / View.sql — Performance indexes and views for reporting/abstractions.
• Diagrams (.drawio.svg) — Visual ERD and Relational Schema representations.
• Database Backups / Files — Pre-built database instances ready for restoration/testing.

---

Notes

• This README.md serves as the central landing page and index for all projects.
• Each project directory is self-contained and isolated from other exercises.