Create at least one more table in your database with state by state employment data per the following:
for each state get every major employment category and record
the state
the occupation major title
the total employment in that field in that state
the 25th percentile salary (lets assume that most college grads earn in the lower 25%) for that field both hourly and annual
the Occupation code instead
Create at least one more table in your database with state by state employment data per the following:
for each state get every major employment category and record the state the occupation major title the total employment in that field in that state the 25th percentile salary (lets assume that most college grads earn in the lower 25%) for that field both hourly and annual the Occupation code instead