Database-wk8-assignment

📚 Library Management System (MySQL Project)

💡 Description

A complete relational database system for managing a library’s operations including books, authors, members, categories, and loans.

🛠️ Features

• Track books and their authors
• Manage categories and availability
• Handle book borrowing (loan system)
• Maintain member records
• Optional: librarian user tracking

📁 Deliverables

• library_management.sql — SQL file with all CREATE TABLE statements and constraints.

🖼️ ERD Diagram

[Insert screenshot here or link to dbdiagram.io]

📦 How to Run

1. Open your MySQL interface.
2. Run the library_management.sql file.
3. Start adding data using INSERT statements or use a GUI like phpMyAdmin.

✅ Requirements

• MySQL Server
• Any SQL editor or CLI (e.g., MySQL Workbench, DBeaver)