Streamlining ABC Foodmart's Operations
The project involved designing the database schema and creating the SQL queries to go through the initial concept of the database to a live data-source that can efficiently and reliably support analytics applications for the local grocery chain.
Overview
As a team, we designed an integrated system for efficient data management. The database we created targeted several challenges that ABC Foodmart was facing:
-
Inconsistent data formatting
-
Difficulty in executing data analysis
-
Lack of accountability in terms of data management
Using SQL, normalization of the data provided on ABC Foodmart was carried out; data redundancy, inconsistencies, and dependencies were spotted; table structure for the database was established based on data relationships, and a third-normal form was applied to all data. Data was then extracted from CSV files, transformed, and loaded onto the database we designed using SQL queries. The result was a database that optimized data management and empowered ABC Foodmart's store management.
Take a look at the project below.