We need to build an ACCESS database using only a subset of the data provided on the ONET website (<[login to view URL]>).? The data? is provided in flat files and? it should not take long to? extact the data we need and place it in some structure in ACCESS.? ?
We DO NOT? need a screen scraping program written? because the data is provided.
?
## Deliverables
We need to build an ACCESS database using only some of data provided on the ONET website ([[login to view URL]][1]).? The data we need to capture is listed below:
1) First we need to capture all jobs and their corresponding SOC codes.? Example: 47-2181.00 - Roofers
2) For each job we need to capture the following (we are calling these items Hard Skills):
? a) Tasks
? b) Tools and Technologies
? c) Work Activities
? d) Skills
? e) Nation Median Wage Amount
? f) Immportance Factor
3) For each job we need to capture the following (we are calling these items Soft Skills):
?
? a) Work Styles
? b) Abilities
? c) Work Values
? d) Importance Factor
An example of a roofer can be seen here... <[login to view URL]>
Example of Tasks would be listed here... <[login to view URL]>
Example of Tools and Technologies ... <[login to view URL]>
Example of Work Activities ... <[login to view URL]>
Example of Skills ... <[login to view URL]>
Example of National Median Wage for a roofer... Median wages (2008) $16.17 hourly, $33,630 annual
Example of Work Styles ...[login to view URL]
?
Example of Abilities ... <[login to view URL]>
Example of Work Values ... <[login to view URL]>
?
The database should include column names using the same terms that ONET uses and the data should be placed in a relational structure in at least third normal form.? Also, we should be able to identify which category each piece of information came from so you will need to store the ONET category name in the database as well (Ex:? Tools and Technology).
Also there needs to be some reports provided that? demonstrate all the data was collected so that we can compare it against the ONET website.
Thanks