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