Create the table Students (sno, sname, dateofbirth, program, cgpa) Fees (sno, date, fee ) Elective (sno, subcode, sub_name) Marks (sno, subcode, marks, grade) Subject ( subcode, subjectname, credit)...

1. Create the table

Students (sno, sname, dateofbirth, program, cgpa)

Fees (sno, date, fee )

Elective (sno, subcode, sub_name)

Marks  (sno, subcode, marks, grade)

Subject ( subcode, subjectname, credit)

Constraints

(dateofbirth  should be less than todays date in student table)

(fee can not zero or negative in fee table)

(Credits can not be zero or less in subject table)

Query

1. List the name of the student who got maximum cgpa.


2. List the maximum, average and minimum CGPA for every program

• List the name of students who have choosed 4 credit subject

1. List the total fee paid by every students