Library Management System

This is an intermediate-level SQL project that implements a full-featured Library Management System. The project demonstrates your ability to design a relational database, perform complex queries, and build reports and stored procedures. It serves as a practical example of working with real data scenarios and database operations.

Key Features & Components

Database Schema / Setup

Created tables to represent entities like branches, employees, members, books, issued_status, and return_status. Included full DDL scripts for creating tables, setting data types, constraints, and relationships.

CRUD Operations

Performs standard data operations (Create, Read, Update, Delete) on multiple tables:

Insert new books, members, etc.

Update member or book details.

Delete old or irrelevant records.

Querying issued books, filtering based on conditions.

Advanced Queries & Reporting

Several tasks that go beyond basic CRUD, such as:

Aggregations (e.g. number of books issued per category, revenue per category).

Use of GROUP BY, HAVING, JOINs, subqueries.

Reports like books not yet returned, overdue books, branch performance.

CTAS (Create Table As Select)

Usage of CTAS to build summary tables (e.g. a table for issue count per book). Helps in optimizing reports or storing summary stats.

Stored Procedures

Implementation of procedures (for example, to mark a book as returned) to encapsulate logic inside the database.

Dashboard / Visual Representation

Included Power BI dashboard (or reference to one) to visualize data, track metrics, and illustrate trends like issue counts, member activity, branch revenue.