1. Write the SQL statements that create the Student Enrollment Database as described in the following table Allow Null Remarks No PK No No No No PK No No No Yes No PK No No No PK No No No No No Table Column Name Data Type ize COURSE NUM COURSE TITLE CREDIT HR DEP COD Character Character Integer Character Character Character Integer Integer Character Inte 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 0 No No PK No Yes No Yes No Student FK