Library Management System - MySQL Edition

This project implements a comprehensive relational database for a modern library using MySQL. It manages:

• Books, authors, publishers, categories
• Members and librarians
• Borrowings, reservations, inventory
• Events, book reviews, fines, and notifications

How to Run/Setup the Project

Prerequisites

• MySQL Server (e.g., MySQL Workbench, XAMPP, or the mysql CLI)
• The provided .sql schema and data files

Steps

1. Clone or Download the Repository

   git clone https://github.com/Kaballah/Library-Database-Management-System.git
   cd Library-Database-Management-System
   

2. Open MySQL Workbench

3. Import the Schema

4. In MySQL Workbench, go to File > Open SQL Script and select library_management.sql

5. Click the lightning bolt (Run) to execute

Or in CLI:

2. Run the bash command

   mysql -u yourusername -p < library_management.sql
   

3. Login and Explore the Database

   USE library_management;
   SHOW TABLES;
   SELECT * FROM members;
   

Entity-Relationship Diagram (ERD)

ERD Screenshot:

Or view the ERD on dbdiagram.io: ER Diagram

Author Developed by Kabala Ronnie