Create the table CourseInfo with the following fields: StudentIdentificationNumb

ID: 329803 • Letter: C

Question

Create the table CourseInfo with the following fields:

StudentIdentificationNumber

RegistrationFee

Tuition

Total

Enter the following for the StudentIdentificationNumber:

ABX-54-93TC

MIP-23-07UP

YKD-61-84RD

IZS-70-62QK

Create the Update Queries to calculate the RegistrationFee based on the following:

If the student is an Undergraduate the Registration Fee is $125. However, if the student is a Graduate the Registration Fee is $250.

Create the table TuitionInfo with the following fields:

CreditsFrom

CreditsTo

Amount

Enter the following data for each of fields:

1 3 350

4 6 300

7 9 250

10 21 200

Create the Update Queries to calculate the Tuition and Total based on the following:

Tuition = SemesterCredits * Amount Total = RegistrationFee + Tuition

Since it is not given if the student is an undergrad or grad, I am assuming situations here

CreditsFrom CreditsTo Amount Tution 1 3 350 3*350 = 1050 4 6 300 6*300 = 1800 7 9 250 9*250 = 2250 10 21 200 21*200 = 4200

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.