Datamine question
include the URL of question 7 and 8. Your submission date is based on the timestamp of your email. This is an individual homework - Write SQL statements to solve the questions. The SQL statements and results should be saved in your 2019S_xxxx database on imc.kean.edu where xxoxx is your Kean email ID Questions based on table Zipcode_info in datamining database. Only use the valid records -ZipcodeType is STANDARD', LocationType 'PRIMARY' and EstimatedPopulation cannot be null. . . 1. (10 points)reate a table tww1 Q1 with two columns (id, answer) that explains 2 main differences between a view and a table. Data type Id: int type and auto_increment, answer: varchar(255). Each difference should be inserted as a row 2. (10 points) Create a table tHW1 Q2 with two columns (id, answer) that give 2 real examples to show the difference between a SQL report and data mining. Data type-ld: int type and auto_increment, answer should be text type. Each difference should be inserted as a rovw 3. (10 points) create a view vHW1 Q3 with columns (state, population, NumofZipcode) showing the total population and the number of zip code (NumofZipcode) of each state and DC. The result should be sorted by the population size from high to low. The output should have 51 rows. 4. (10 points) Create a view vHW1 04 with columns (state, avg_wage) showing the average wage of each state and DC and the result should be sorted by the average wage from high to low. The output should have 51 rows. 5a. CPS4921, min wage) showing the state that has the minimum wage (15 points) Based on question 4, create a view vHW1 Q5 with columns (state, 5b. CPS5921, wage) showing the state that has the minimum wage and maximum wage (15 points) Based on question 4, create a view vHW1_Q5 with columns (type, state, 6. (15 points) Create a table tHW1Q6 (state, name, area) and load the data file US state data.csv into the table (20 points) Based on vHw1 Q6, vHW1 Q4, and vHW1 03 please write a PHP program HW1.php that read and display the state name, population, area, density, average wage and the number of zip code on the browser for the 50 states and DC. density = population/area. The result should be aligned using HTML
format. 8. (10 points) What is the correlation between the density and the number of zip code for the 50 states and DC? Please write your conclusions under the result of question 7 Your Q7 result and Q8 answer should be available to view at the URL: include the URL of question 7 and 8. Your submission date is based on the timestamp of your email. This is an individual homework - Write SQL statements to solve the questions. The SQL statements and results should be saved in your 2019S_xxxx database on imc.kean.edu where xxoxx is your Kean email ID Questions based on table Zipcode_info in datamining database. Only use the valid records -ZipcodeType is STANDARD', LocationType 'PRIMARY' and EstimatedPopulation cannot be null. . . 1. (10 points)reate a table tww1 Q1 with two columns (id, answer) that explains 2 main differences between a view and a table. Data type Id: int type and auto_increment, answer: varchar(255). Each difference should be inserted as a row 2. (10 points) Create a table tHW1 Q2 with two columns (id, answer) that give 2 real examples to show the difference between a SQL report and data mining. Data type-ld: int type and auto_increment, answer should be text type. Each difference should be inserted as a rovw 3. (10 points) create a view vHW1 Q3 with columns (state, population, NumofZipcode) showing the total population and the number of zip code (NumofZipcode) of each state and DC. The result should be sorted by the population size from high to low. The output should have 51 rows. 4. (10 points) Create a view vHW1 04 with columns (state, avg_wage) showing the average wage of each state and DC and the result should be sorted by the average wage from high to low. The output should have 51 rows. 5a. CPS4921, min wage) showing the state that has the minimum wage (15 points) Based on question 4, create a view vHW1 Q5 with columns (state, 5b. CPS5921, wage) showing the state that has the minimum wage and maximum wage (15 points) Based on question 4, create a view vHW1_Q5 with columns (type, state, 6. (15 points) Create a table tHW1Q6 (state, name, area) and load the data file US state data.csv into the table (20 points) Based on vHw1 Q6, vHW1 Q4, and vHW1 03 please write a PHP program HW1.php that read and display the state name, population, area, density, average wage and the number of zip code on the browser for the 50 states and DC. density = population/area. The result should be aligned using HTML format. 8. (10 points) What is the correlation between the density and the number of zip code for the 50 states and DC? Please write your conclusions under the result of question 7 Your Q7 result and Q8 answer should be available to view at the URL
