SQL Server — Library Management System

Project 03 — Database Engineering

SQL Server — Library Management System

A full Library Management System built on SQL Server, covering database schema design, CRUD operations, a borrow/return tracking system, stored procedures, and statistical queries for book and member activity.

Library Database Authors Table Books and Categories Table Members and Borrowing Table Insert Table 1 & 2 Insert Table 3 & 4 Table Relationships Borrow Book Return Book

Platform ► SQL Server (SSMS)

Language ► T-SQL

Features ► CRUD · Stored Procedures · Views · Borrow/Return System · Statistics

Database Design

Designed a normalized database schema to handle books, authors, categories, members, borrowing transactions, and inventory. Implemented referential integrity with foreign keys and built joins across all tables.

Add Book Stored Procedure Return Book Stored Procedure Book Recovery Procedures 1 Book Statistics by Category Most Active Members Search Available Books Overdue Books View Member Activity Summary

Technologies ► SQL Server · T-SQL · Stored Procedures · Views · Joins · SSMS

Challenges & Skills

Gained experience in database design and normalization. Developed complex queries for inventory management, statistics, and book tracking — including overdue books, most borrowed titles, and member activity reports.

← Back to projects