University of Iowa 2018 - Database Management Course Project

Overview

  • Developed a web application that can track trends in the United States Market for basketball shoes based on NBA player’s performance.
  • Built a ER diagram and a relational schema from scratch.
  • Collected both real data (NBA player performance statistics) and synthetic data (Customer Information) and inserted the data into the Oracle Database to manipulate into information.
  • Wrote SQL queries to display the relevant information such as total sales per player and region, and how they correlated with the players performance.

Technologies Used

  • Oracle APEX (Oracle Application Express)
  • SQL
  • HTML
  • CSS

TAKE A CLOSER LOOK