Library Management Database

This project is a MySQL-based relational database system designed to manage a library.
It covers librarians, members, books, and loan records, with well-structured tables and proper constraints.

Features

• Tracks librarians and members with unique email constraints
• Manages book catalog with availability status
• Records book loans including borrow and return dates
• Enforces relationships using primary and foreign keys

Setup

1. Clone this repository
2. Import the library_management.sql file into MySQL

   mysql -u root -p < library_management.sql

See full docs

https://hackmd.io/@I5OyzHQDSGWGWqeLjg1tSg/Hkc34_fnll