Library Management System – SQL Database Project

Library Management System – SQL Database Project

This project is a relational database designed to manage a library system using SQL Server.

The system manages:

Books

Authors

Categories

Library Members

Staff

Book Loans

Features

• Track books and their authors

• Organize books by categories

• Manage library members

• Record borrowing and returning books

• Track overdue books

• Analyze staff activity and member borrowing history

Database Tables

Authors

Categories

Books

Members

Staff

Loans

Technologies

SQL Server

T-SQL

Relational Database Design

Joins and Aggregation Queries