Name		Name	Last commit message	Last commit date
Latest commit History 5 Commits
Some_Query_outputs		Some_Query_outputs
ER_Diagram.png		ER_Diagram.png
Online-Book-Store-SQL.sql		Online-Book-Store-SQL.sql
README.md		README.md

Repository files navigation

📚 Online Book Store SQL Project

Overview

This project is a relational database management system for an Online Book Store built using PostgreSQL.

Database

PostgreSQL

Tables

Books
Customers
Orders

SQL Concepts Used

CREATE TABLE
PRIMARY KEY
FOREIGN KEY
JOINS
GROUP BY
HAVING
Aggregate Functions
ORDER BY
DISTINCT
Subqueries

Business Insights

Total Revenue
Top Selling Books
Highest Spending Customer
Remaining Stock
Sales by Genre

Author

Tariful Sk

About

Online Book Store Database Management System built using PostgreSQL. Includes relational database design, CRUD operations, joins, aggregate functions, GROUP BY, HAVING, and business analysis queries such as revenue, top-selling books, customer insights, and stock management.

Report repository

Releases

Packages

Contributors