The Book Store Management System is a database-driven project built using PostgreSQL to manage book inventories, customer information, and order transactions efficiently. It demonstrates practical use of SQL concepts such as table creation, relationships, data manipulation, and analytical queries to extract meaningful insights from the data.
• To design a normalized and relational database for bookstore operations. • To perform advanced SQL operations like joins, aggregations, and filtering. • To analyze sales, revenue, and customer behavior efficiently.
The system includes three main tables:
- Books – Stores details such as title, author, genre, price, and stock.
- Customers – Contains customer information like name, contact, and location.
- Orders – Tracks purchase details, quantities, and total amounts. All tables are connected through Primary and Foreign Keys, ensuring data integrity.
• Developed and tested using PostgreSQL. • Data imported through the COPY command from CSV files. • Queries demonstrate: o Data retrieval and filtering o Revenue calculation and stock tracking o Customer and sales analysis through joins