Banque Misr Training Project - July 2025
Relational & NoSQL Database Practice with MySQL & MongoDB
BookBazaar is a database project that focuses on designing and integrating a hybrid data solution using both MySQL (for structured relational data) and MongoDB (for flexible document-based data).
It includes schema design, sample data, scripted CRUD operations, and documentation.
- MySQL 8.x
- MongoDB 6.x
- MySQL CLI / Workbench
- Mongo Shell
- dbdiagram.io (ERD Design)
| File / Artifact | Purpose |
|---|---|
schema.sql |
MySQL DDL: tables for authors, books, users + sample data |
crud_demo.sql |
Scripted CRUD operations on MySQL (with transactions) |
reviews_seed.json |
MongoDB collection sample data (at least 5 reviews) |
crud_reviews.js |
Mongo shell script for performing CRUD |
ER_diagram.png |
Visual schema (ERD) |
BookBazaar_Documentation.pdf |
Setup, diagrams, and instructions |