Grocery Store Database Design

Relational database system for grocery store operations with EER and SQL.

About this project

Designed and implemented a relational database system to manage grocery store operations using a sample dataset of purchases and sales. Transformed raw, unstructured data into a normalized schema with an Extended Entity-Relationship (EER) diagram, SQL schema, and test queries. Built an EER diagram to model entities (Items, Vendors, Customers, Purchases, Sales, Inventory) and their relationships. Created a normalized SQL schema with primary keys, foreign keys, and appropriate datatypes. Wrote SQL queries to validate relationships and answer business questions (e.g., vendor supply analysis, sales reporting). Addressed data anomalies and demonstrated how the new design ensures scalability, integrity, and business growth.