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 systemn 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] .docxSubmit SQL script .sql file in text format names as ALY_6030_Assignment_4_[your name].sqlPaperwork file must meet the following requirements:Title Page must have:Class nameClass numberClass CRN numberAssignment nameYour full name as registered in CanvasIntroduction sectionexplain what this assignment is aboutset goals and expectationsexplain the selected datasetintroduce tools and languages you plan to useFinal conclusions sectionExplain if goals and expectations were met or not Explain cons and pros of using the tools, methods and techniques.Explain what would you do differentlyReferences (optional)SQL Script file must meet the following requirements:Only ,sql text format will be acceptedEach line of the SQL code must have a meaningful commentCode should be executed on other computers without any modifications (add extra steps in the comments if necessary)

Assignment: Lab Exercise 7Python: Hi/Low Guessing GamePython AssignmentThe objectives of this lab assignment are as follows:Declare variablesUse commentsReceive input from the userOutput data to the consoleApply conditional logicConvert string value to intUse the Random libraryUse while loopsAssignment User StoryAs a user I want an application that will allow a user to play the hi/low guessing game where the computer picks a number from 1 to a maximum inputted value and your task as a user to guess the number the computer generates.Assignment RequirementsIn this application you will first randomly generate a number unknown to the user, and the user will guess what that number is and will continue to guess until their guess matches the randomly generated number.This assignment combines operations of prompting and receiving input from the user with conditional logic to perform a specific function based on those inputs. This assignment outputs information back to the user, and finally, loops through these operations until the user ends the application.Program flowYou must receive the maximum number that the application will use in choosing its random number. Your application will then generate a random number from 1 to the maximum value the user keyed in (inclusive of that value).The remaining sequence will be contained within a loop where the user will be asked to guess the randomly generated number. If what the user enters is a match, then the user will be congratulated on guessing the correct number. Otherwise, the user will be informed whether their guess is higher or lower than the actual value.Once the user guesses the randomly generated value they will be asked if they wish to play another game. If they answer in the affirmative the game will begin anew, otherwise the application will end.This application contains two loops: one within the other—an inner loop and an outer loop. The outer loop control's subsequent game play in that the user is prompted if they wish to play the game again. The inner loop causes the user to be prompted to guess the randomly generated number. The inner loop continues until the user's guess matches the computers number. The outer loop continues until the user no longer wishes to play the game.Important:When complete, your output should appear as pictured below:Notice that if users affirm they wish to play again, the game starts over from the beginning:Technical/Grading RequirementsYou must ensure that the application you submit meets all the technical/grading requirements. Your grade will be based on how well your application follows these requirements:The name of your application will be HiLoGame.pyYou must have a set of comments at the top of the program that identifies the programmer, date, and name of the program file. Furthermore, you must provide a description of what this program is and what it does. Each of these comments must be on individual lines.Your program must contain two loops: an outer and an inner. Hence, you will be working with the concept of "nested" loops. The outer loop controls the next game play, while the inner loop controls the current game play.You must randomly generate a number from 1 to the maximum value the user enters at the start of the game.OptionalCan you validate that numeric entries made by the user are indeed numeric? This is to say that the program should not end with an exception error due to the user inputting invalid data. Hint: this is accomplished through use of while loops that continue to prompt the user until their entry is valid.This is optional for this assignment but will be a requirement of your next application. As such, this would be a great opportunity to begin exploring this concept.In the screen capture below, you can see that I have protected the application against invalid numeric entry:

Discuss the following in the Discussion Board: Think of a purpose for creating a database and describe the database. Explain why you would want to use a database for this purpose. What example could you offer that would demonstrate using a subquery? What example could you offer that would demonstrate using a join? In your view, would you prefer using subqueries, or joins, and why? What are some performance considerations when determining whether to use subqueries or joins?