other · academic · 2022
Book Shop Management System
Role: Database Designer & Query Builder - Academic Project
About the project
A backend-focused SQL project to manage a book shop's inventory, authors, and pricing logic. It covers CRUD operations, complex joins, subqueries, and pricing strategies like 1p, 2p, 3p based on book categories or author levels.
<
Features
>Create, read, update, delete (CRUD) operations on books and authors
Advanced SQL queries using joins, group by, and subqueries
List books by author, price range, and genre
ER diagram & schema creation
Data normalization and indexing practices
</>
<
Tech Stack
/>MySQL
SQL Queries
ER Modeling