# Grade can be: A(4.0), B(3.0), C(2.0), D(1.0), and F(0). Your grade point average (GPA) is calculated with

Fantastic news! We've Found the answer you've been seeking!

## Question:

Grade can be: A(4.0), B(3.0), C(2.0), D(1.0), and F(0). Your grade point average (GPA) is calculated with the following formula:

SUM(grade of each course*credit hours of the course)/SUM(credit hours of each course)

If a course was taken multiple times, use the one with the highest grade.

The grade point average may range from 0.0 to 4.0.

In this assignment, you need to

Create the above tables.

Insert sample data for testing.

Sample data should cover all different cases such as grade is not assigned yet in Enroll table, a course is repeated multiple times with different grades by the same student.

**Related Book For**

## A Survey of Mathematics with Applications

ISBN: 978-0134112107

10th edition

Authors: Allen R. Angel, Christine D. Abbott, Dennis Runde