Database Management Project – Grocery Store Management (SQL)
- Designed and implemented a relational database for managing grocery store op- erations including products, customers, orders, and inventory.
- Wrote optimized SQL queries for data retrieval, sales reports, and inventory track- ing.
- Implemented constraints, joins, aggregate functions, and subqueries to ensure data integrity and efficient reporting.
- Developed queries to identify best-selling products, customer purchase patterns, and stock shortages.