1. Create a student table with the following columns:
• id - fixed-length string with 9 characters, primary key
• name - variable-length string with up to 50 characters
• birthdate - date
• gpa - decimal value representing the grade point average, with 2 decimal digits.
Create a course table with the following columns:
• crn - course reference number, fixed-length string with 5 characters, primary key.
• courseName - variable-length string with up to 20 characters
• days - variable-length string with up to 5 characters
• time - time
• capacity - integer with range 0 to 100
Add two constraints:
• gpa must be greater than 0 and less than or equal to 4.0.
• capacity must be less than or equal to 35.
2. Create a studentCourse table with the following columns:
• studentID - fixed-length string with 9 characters, partial primary key, foreign key references to student(id).
• courseID - fixed-length string with 5 characters, partial primary key, foreign key references to course(crn)
• grade - fixed-length string with a single character.
If a row is deleted from the student table, the rows with the same student id should be deleted from studentCourse automatically.
If a row is deleted from the course table, the same course id should be set to NULL in the studentCourse table automatically.
