Library Management System (SQL)

📚 Project Overview

This project implements a Library Management System using MySQL, designed to manage books, authors, library members, and book loans. The database is fully normalized and includes proper relational constraints to maintain data integrity.

The system supports:

• Managing books and their authors (many-to-many relationship)
• Tracking library members
• Recording book loans
• Enforcing primary and foreign key constraints for consistency

This project fulfills the Week 8 Final Project Assignment for database design and normalization.

---

📝 Assignment Details

Objective:
Design and implement a relational database with well-structured tables, relationships, and constraints.

Instructions Followed:

• Created a relational schema for a Library Management System.
• Implemented PRIMARY KEY, FOREIGN KEY, NOT NULL, and UNIQUE constraints.
• Defined relationships:
  • One-to-Many (Members → Loans)
  • One-to-Many (Books → Loans)
  • Many-to-Many (Books ↔ Authors)
• Provided sample data for quick testing.
• Delivered as a single .sql file containing CREATE DATABASE and CREATE TABLE statements.

---

🗂️ Database Schema

Tables:

1. Members – Stores library member information
2. Authors – Stores author details
3. Books – Stores book information
4. BookAuthors – Resolves the many-to-many relationship between Books and Authors
5. Loans – Tracks which books are loaned to which members and their loan status

---