Database Management for Retail Application

• Designed a relational database schema using TOAD data modeler.
• Created multiple tables and managed the retail stores’ data in MySQL.
• Applied database objects like triggers, stored procedures, views, functions on the database.
• Generated reports which helped the retail organization to evaluate their sales, analyze sales for this season and forecast sales for next season.
• Used R for visuialization

ER Diagram for Retail Application

ER Diagram for Retail Application after Normalization

Data Vizualization using R