top of page

A CHALLENGING PROJECT

Many states have laws implemented into them where the salary of government workers is pasted allowing use to use that data to understand and investigate how much they are being paid and what stands out amongst the numbers.


Implementing a database for the government salaries allow for the data to be analyzed and investigated to find trends and abnormalities in the data. This also allows the viewer to see where their skills would be rewarded the most.


Our objective for this project was to create and implement a working Database that holds the yearly salaries of five state public records. After selecting the five states we implemented them into a single database allowing us to analyze the data in a streamlined manner.

Event_020720_LogoReveal_JG27.jfif
Project Overview: About My Project

MILE STONES

MILE STONE 1

  • Compare and choose database system solutions and hosting solutions for project. 

  • Research and select additional datasets to be used

  • begin documentation of the database

  • research data that can be implemented in to the database

MILE STONE 2

  • initiate and implement the database 

  • Test data Migrations scripts to implement data into the database

  • Test data analyzation on the database

  • begin testing and training of the database amongst the team

MILESTONE 3

  • Finalize the implementation of the data in the database

  • Consolidate the data into a single table for convenience and to compare the data

  • Began analyzing the data to identify abnormalities

  •  Start finalizing the report

Project Overview: List

©2021 by Payroll KSU Capstone. Proudly created with Wix.com

bottom of page