Programming Homework Help

Story:

Alcohol Use and Alcohol Use Disorders Among Adolescents and College Age Populations:

Researchers estimate that each year:

• 1,825 college students between the ages of 18 and 24 die from alcohol-related unintentional injuries, including motor-vehicle crashes.
• 696,000 students between the ages of 18 and 24 are assaulted by another student who has been drinking.
• 97,000 students between the ages of 18 and 24 report experiencing alcohol-related sexual assault or date rape.
• Roughly 20 percent of college students meet the criteria for an alcohol use disorder (AUD).
• About 1 in 4 college students report academic consequences from drinking, including missing class, falling behind in class, doing poorly on exams or papers, and receiving lower grades overall.

Data:

• You will use the data from BRFSS files provided to propose methods to identify expected concentrations of heavy drinking among adolescents.
• The BRFSS is the nation’s premier system of health-related telephone (land line and cellular) surveys.
• It collect state data about U.S. residents regarding their health-related risk behaviors, chronic health conditions, and use of preventive services.
• Established in 1984 with 15 states, BRFSS now collects data in all 50 states as well as the District of Columbia and three U.S. territories.
• BRFSS researchers complete more than 400,000 adult interviews each year, making it the largest continuously conducted health survey system
• n the world.
• BRFSS data BRFSS_OK.xlsxand demographic data Demographixlsxand demographics data in Oklahoma Demographics_OK.xlsx 下载 links are provided.
• The BRFSS response data in BRFSS_OK.xlsx 下载 is collected from survey participants when responding to questions about drinking, coded as a “Yes” for “Heavy drinkers (adult men having more than two drinks per day and adult women having more than one drink per day)”.
• The column marked Data_Value gives the number of people who responded “Yes” to the survey question.
• The column marked Sample_Size gives the total number of people who were asked the question.
• The groups are defined in terms of zip code.
• The time period will be 2009 and the questions pertain to the state of OK.

Task:

• Explore and gain an understanding of the data available from Behavioral Risk Factor Surveillance System (BRFSS) data warehouse.
• Explore survey responses (“Y”) that are relevant to adolescent alcohol consumption.
• The time period will be 2009 for the state of Oklahoma (OK).
• Propose method(s) to identify (anonymous) groups of adolescents who may be at highest risk for alcohol abuse.
• Perform an initial design of a SQL database by constructing an ERD including table relationships.
• Find the areas of OK have highest and lowest number of respondents for adolescent alcohol abuse.
• Write a SQL query that would answer this question and provide screen shots of executing the query and results:
  • By city.
  • By county.

Submission requirements:

• Submit paperwork using .docx file in Microsoft Word format named as ALY6030_Assignment_4_[your name] .docx
• Submit SQL script .sql file in text format names as ALY_6030_Assignment_4_[your name].sql

Paperwork file must meet the following requirements:

• Title Page must have:
  • Class name
  • Class number
  • Class CRN number
  • Assignment name
  • Your full name as registered in Canvas
• Introduction section
  • explain what this assignment is about
  • set goals and expectations
  • explain the selected dataset
  • introduce tools and languages you plan to use
• Final conclusions section
  • Explain if goals and expectations were met or not
  • Explain cons and pros of using the tools, methods and techniques.
  • Explain what would you do differently
  • References (optional)

SQL Script file must meet the following requirements:

• Only ,sql text format will be accepted
• Each line of the SQL code must have a meaningful comment
• Code should be executed on other computers without any modifications (add extra steps in the comments if necessary)