(Solved) : Given Following Relational Database Schema Student Ssn Name Major Course Coursenumber Quar Q31044585 . . . .

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 useappropriate data types for each attribute. The DDL statement mustinclude at least the following constraints:

Every Primary Key;

Every Foreign Key;

For every Foreign Key constraint, specify an appropriatereferential 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