Given the following relational database schema:

Student = (SSN, Name, Major)

Course = ( CourseNumber, Quarter, CourseTitle, NumberOfUnits, RoomNumber, DayTime), where DayTime is of the form MW 1:0-2:00.

Enrollment = (SSN,CourseNumber, Grade)

Write DDL statements to create the above tables and use appropriate data types for each attribute. The DDL statement must include at least the following constraints:

Every Primary Key;

Every Foreign Key;

For every Foreign Key constraint, specify an appropriate referential integrity constraints as follows:

ON DELETE SET NULL or SET DEFAULT ;

ON UPDATE CASCADE or SET NULL.

0 < NumberOfUnits < 5;

Grade is either A, B, C, D, or F;

The Name and Quarter can not be null;

The Major and Grade may assume the null value.