Data Warehouse Preliminary Design

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 (you do not have to execute it).
By city.
By county.