Library Management System (SQL Project)

Overview

This project is a SQL-based Library Management System designed to manage books, customers, authors, and orders efficiently.

---

Objectives

• Design normalized database (1NF, 2NF)
• Implement relationships using foreign keys
• Perform data analysis using SQL queries

---

Database Design

Tables:

• Customers
• Authors
• Books
• Orders

---

Features

• Manage customer and book data
• Track orders and inventory
• Perform analytical queries

---

SQL Concepts Used

• DDL (CREATE, ALTER)
• DML (INSERT, UPDATE)
• Joins (INNER, LEFT)
• Aggregate Functions (SUM, AVG)
• Window Functions (RANK, ROW_NUMBER)
• TCL (COMMIT, ROLLBACK)
• Normalization (1NF, 2NF)

---

Key Insights

• Top-selling books
• Highest spending customers
• Sales trends over time

---

Screenshots

Outputs are posted as images

---

Future Improvements

• Add dashboard using Power BI
• Integrate with Python