/Retail-Application-using-DBMS---SQL

Database Management System For Retail Application

Primary LanguageRMIT LicenseMIT

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

333

Data Vizualization using R

rplot rplot01