1. Write the SQL statements that create the Student Enrollment Database as described in the following table Null Remarks No PK No No No No PK No No No Yes No PK No No No PK No No No No No No No No PK No Yes No Yes No Table Column Name Data Type Character Character Integer Character Character Character Integer Integer Character Inte ize COURSE NUM COURSE TITLE CREDIT HR DEP CODE Fixed 8 Up to 40 Course Fixed S Fixed 5 Up to 40 FK Department DEP CODE DEP NAME ST ID FK FK FK Enrollment CRN GRADE INSTRUCTOR ID Fixed 2 Instructor INSTRUCTOR NAME Character Up to 30 DEP CODE CRN COURSE NUM SEMESTER INSTRUCTOR ID MAX ENROLLMENT ROOM DAYS TIME ST ID ST NAME ST GPA ST DOB ST ADDRESS DEP CODE Character Fixed 5 Inte Character Fixed 8 Character Fixed 15 Inte Inte Character Fixed 8 Character Fixed 4 Character Fixed 20 Integer Character Up to 30 Floatin Date Character Up to 50 Character Fixed 5 FK FK Offering FK Student FK