A relational database system designed and implemented for managing a bookstore.
The project includes the SQL schema, ER diagram, and example queries for data analysis.
This database supports bookstore operations such as:
- Managing books, authors, and publishers
- Tracking customers and their purchases
- Handling employees, managers, and store branches
- Running useful queries for insights (e.g., total purchases, number of books per publisher)
- Database: MySQL
- IDE: VS Code
- Design Tools: Figma (ER Diagram), DrawSQL (Table Design)
Additional SQL queries are provided to:
- Calculate total purchases per customer
- List managers and employees
- Count books per publisher
- And more!
👉 Check them out here: Queries.md