Question

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.

          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.

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.

Added by Keith S.

Question

Please give Ace some feedback