How does this compare to tarrant county and dallas county

Assignment Help Computer Engineering

Reference no: EM133483081

Question: You will be examining the highest level of education attained by individuals over 25 across the United States. To accomplish this task, you must a VM in GCP running Ubuntu 20.04 LTS, install MySQL, and run the mysql_secure_installation program. Select the strong password option.

a database named edu for this assignment. You will download table B15003 from the American Community Survey (ACS) 2014-2018 (5-Year Estimates) containing data for this table for the entire United States at the county level [CSV]. Download You will download table B15003 from the American Community Survey (ACS) 2014-2018 (5-Year Estimates) containing data for this table for the entire United States at the county level [CSV]. This table is available as a CSV file linked in Homework 3 in Canvas.

Once you have downloaded this CSV file, a table named b15003 in database edu, upload the CSV file to the VM, and load the data from this CSV file into table b15003.

Look at the Table Details and Relevant Documentation available on Social Explorer at this link links to an external site.

You must write SQL queries to assist you in answering the following questions:

How many people 25 and over in Denton County, TX have completed an Associate's Degree, Bachelor's Degree, Master's Degree, or Doctorate Degree? How does this compare to Tarrant County and Dallas County?
Which U.S. county has the highest proportion of individuals 25 or over who have completed a Doctorate Degree?
How many people (age 25 and over) in the U.S. have not attained education past the 2nd grade?
Which state in the U.S. has the highest number of people who have not completed any schooling?

The SQL queries you write to answer these questions must do all of the calculations. Your answer to the above questions cannot involve doing additional calculations outside of the query after looking at the results of a query. Use MySQL to do the calculations, but do not simply use MySQL as a calculator.

In your Linux user home folder, create a text file named answers.txt that contains answers to each of the questions above as well as the SQL queries you used to find these answers. Clearly state which answer in this file corresponds to which question. During grading, the SQL queries you include in this file will be tested on the database you created.

Reference no: EM133483081

Questions Cloud

Develop a process to manage stock replenishment : Develop a process to manage stock replenishment when the quantity falls below a certain threshold. This could involve querying products with low stock

Briefly describe how this game works : Briefly describe how this game works. In the terms of the game, what do 'co-operate' and 'defect' mean

Explain the three learning categories : Explain the three learning categories and how they can be used in patient education.

Cloud migration success stories : Choose one of these success stories and read about it. Next, summarize and cite the story

How does this compare to tarrant county and dallas county : How many people (age 25 and over) in the U.S. have not attained education past the 2nd grade? Which state in the U.S. has the highest number of people who have

Should have been allowed to refuse artificial nutrition : Should Elizabeth Bouvia have been allowed to refuse artificial nutrition and hydration, essentially committing suicide by starvation/thirst?

Build a visualization that would show a distribution : Build a visualization that would show (no map should be used) a distribution of peach manufacturers and the production

Explain how you might improve patients food insecurity : Explain how you might improve the patients' food insecurity and nutritional status to affect their specific health goals or improve their health outcomes.

How to address the professional development needs of staff : How to address the professional development needs of staff, and how to work with other departments in achieving learning goals.

User Account

All Pages