problem 1: using create table statement create tables for : student: sid, gpa, major major is either cs or eecs. gpa is between 0 and 4. course: cid, level level is either introductory or advanced taken courses: sid, cid sid refers to student.sid and cid to courses.cid. if a student record is deleted from the student table, its record must also be deleted from taken courses table, however if a course is deleted from the course table, records associated with that cid in taken courses table should not change. furthermore, if the course cid is changed in the course table, the change should be reflected in the taken course table. write the create table statements for each of the above tables with the above mentioned constraints. after creating tables, create an assertion that disallows students with a gpa below 3.0 from taking more than 2 advanced courses, i.e., a tuple cannot be in the taken courses table, if sid corresponds to a student whose gpa is below 3.0, the cid corresponds to an advanced level course, and the student has already taken 2 advanced courses.
