Number 3 please.

Score: CollegelD HW1 Quiz1 StudentID HW2 HW3 Quiz2 Midterm Final 18 1 20 2 15 2 14 1 25 1 30 1 45 50 3 College CollegelD CollegeName 1 College of Engineering 2 College of Business 3 College of Computing and Informatics (1) Create a mysql database using your first name and create tables “Score” and “College” using the data given above. (2) Generate random number between 40-100 for the blank columns to fill in the fields in the Score table; (3) The weights for each homework is 10%, and each quiz is 15%, midterm and final 20% each. i.) Calculate the Total Score and Grade (A:90-100; B: 80-89; C: 70-79; D: 60-69; F: other) i.) Create two additional columns named “Total Score” and “Grade” and fill in the calculated results correspondingly (4) Analyze the grades: i.) calculate and print average score of the class; i.) Count and print how many students pass the course (Grade is better than F); ii.) Select and print StudentIDs and final exam whose Grade is better than C and sort by final exam grade from the smallest to the largest; iv.) Print the average scores of the students in the three colleges separately. (5) Curving the grades: Multiply all students’ final score by 105% and update the records in the database Show transcribed image text Score: CollegelD HW1 Quiz1 StudentID HW2 HW3 Quiz2 Midterm Final 18 1 20 2 15 2 14 1 25 1 30 1 45 50 3 College CollegelD CollegeName 1 College of Engineering 2 College of Business 3 College of Computing and Informatics (1) Create a mysql database using your first name and create tables “Score” and “College” using the data given above. (2) Generate random number between 40-100 for the blank columns to fill in the fields in the Score table; (3) The weights for each homework is 10%, and each quiz is 15%, midterm and final 20% each. i.) Calculate the Total Score and Grade (A:90-100; B: 80-89; C: 70-79; D: 60-69; F: other) i.) Create two additional columns named “Total Score” and “Grade” and fill in the calculated results correspondingly (4) Analyze the grades: i.) calculate and print average score of the class; i.) Count and print how many students pass the course (Grade is better than F); ii.) Select and print StudentIDs and final exam whose Grade is better than C and sort by final exam grade from the smallest to the largest; iv.) Print the average scores of the students in the three colleges separately. (5) Curving the grades: Multiply all students’ final score by 105% and update the records in the database

## Expert Answer

Answer to Score: CollegelD HW1 Quiz1 StudentID HW2 HW3 Quiz2 Midterm Final 18 1 20 2 15 2 14 1 25 1 30 1 45 50 3 College CollegelD…