(Solved) : Score Collegeld Hw1 Quiz1 Studentid Hw2 Hw3 Quiz2 Midterm Final 18 1 20 2 15 2 14 1 25 1 3 Q42679759 . . .

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 Coll

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…

Leave a Comment

About

We are the best freelance writing portal. Looking for online writing, editing or proofreading jobs? We have plenty of writing assignments to handle.

Quick Links

Browse Solutions

Place Order

About Us