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.

 

Transcribed Image Text:

Database Description: This homework is based on the following schema Student M# Name Sex GPA Course Course# Section Course# Sect# Semester Year Sid Enroll Name C# of prerequisit credit wwwwwwww M# Sid Grade Database Description: This homework is based on the following schema Student M# Name Sex GPA Course Course# Section Course# Sect# Semester Year Sid Enroll Name C# of prerequisit credit wwwwwwww M# Sid Grade

Answer rating: 100% (QA)

It appears that youre being asked to create tables based on a database schema related to student records courses and enrollment data and then populate ... View the full answer