The Online Book Store Management System is a SQL-based database project that demonstrates the design and implementation of a relational database for managing customers, books, and orders. The project includes database creation, sample data insertion, and SQL queries to retrieve meaningful insights.
- Design a relational database for an online bookstore.
- Manage customer, book, and order information.
- Perform SQL queries for data analysis.
- Demonstrate the use of joins and aggregate functions.
- MySQL
- MySQL Workbench
- SQL
- Git & GitHub
- CustomerID
- CustomerName
- City
- BookID
- Title
- Author
- Genre
- Price
- OrderID
- CustomerID
- BookID
- Quantity
- OrderDate
Online-Book-Store-SQL/
│── database_schema.sql
│── sample_data.sql
│── queries.sql
│── README.md
└── screenshots/
├── customers_table.png
├── books_table.png
├── orders_table.png
├── customer_book_join.png
├── total_spent.png
├── total_revenue.png
└── most_expensive_book.png
- CREATE DATABASE
- CREATE TABLE
- PRIMARY KEY
- FOREIGN KEY
- INSERT INTO
- SELECT
- WHERE
- INNER JOIN
- GROUP BY
- ORDER BY
- COUNT()
- SUM()
- AVG()
- LIMIT
- Display all customers
- Display all books
- Display all orders
- Customer purchase history using JOIN
- Total amount spent by each customer
- Total revenue generated
- Most expensive book
- Filter books by genre
- Count customer orders
- Sort books by price
- Designed a relational database using MySQL.
- Implemented primary and foreign key relationships.
- Practiced SQL queries for data retrieval and analysis.
- Applied JOIN, GROUP BY, ORDER BY, and aggregate functions.
- Improved database design and SQL problem-solving skills.
- Inventory Management
- Payment Details
- Suppliers Table
- Views
- Stored Procedures
- Triggers
Gouthami Mandapelli
B.Tech Computer Science and Engineering
⭐ Thank you for exploring this project! Your feedback and suggestions are always appreciated.