📚 Bookstore Database Project

Welcome to the Bookstore Database Project!
This project is a hands-on SQL-based database system for managing all aspects of a bookstore — including books, authors, customers, orders, shipping, and more.

---

🚀 Overview

This MySQL project was built as part of a real-world simulation to design and implement a fully relational database system. It focuses on:

• Structuring normalized tables
• Managing many-to-many relationships
• Ensuring data consistency with foreign keys
• Enabling efficient queries and data retrieval
• Supporting role-based access control

🛠️ Tools & Technologies

• MySQL: For database creation and management
• Draw.io / Diagrams.net: For designing the database schema (ERD)
• Terminal / MySQL Workbench: For interacting with the database
• Git & GitHub: For version control and collaboration

---

📁 Project Structure

---

📦 Tables Included

• book
• author
• book_author
• book_language
• publisher
• customer
• address, country, address_status, customer_address
• cust_order, order_line, order_status, order_history
• shipping_method

---

🧑‍💻 Getting Started

✅ Prerequisites

• MySQL installed on your machine
• MySQL Workbench (optional, but useful)
• Git

---

💡 Contact For questions, suggestions, or improvements, feel free to open an issue.

Happy Coding! 💻📖

---

📝 License This project is open-source and available under the MIT License.

---