PROJECT OVERVIEW A demo project for e-commerce data modeling and MongoDB operations. It includes SQL and NoSQL schema design, sample data insertion, aggregation queries, and indexing examples.
Features
- Logical schema design for e-commerce (SQL & MongoDB)
- Sample data insertion for customers and orders
- Aggregation pipeline to calculate total revenue per customer
- Indexing examples for SQLite and MongoDB
How to Run
- Ensure MongoDB is installed and running on localhost:27017.
- Run lab2_mongo.py to insert data and perform queries.
FILES
- schema_design.md: Contains SQL and NoSQL schema documentation.
- lab2_mongo.py: Python script for MongoDB operations.
Requirements
- Python 3.x
- PyMongo
- MongoDB