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
Explanation / Answer
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