Database Of Library

Library Management System Database

This Library Management System database manages employee details, floors, books, users, and transactions.

Employees have unique IDs, names, emails, salaries, bonuses, and work on specific floors. Each floor has a manager with a hiring date.

Users are registered by employees, with each user having a unique SSN, name, email, and phone number.

Books have unique IDs, titles, and are categorized. Each book may have multiple authors and one publisher.

Book Transactions are recorded when a user borrows a book, including borrow date, due date, and amount paid.

Shelves store books and are located on specific floors.

This system ensures efficient management of library operations with clear relationships between employees, users, books, and floor organization.