I5. Write the SQL commands for creating each of the relations shown below. Specify the primary key(s) and foreign key(s) (if necessary) constrains for each relation in the commands. (9%) Assume the following attribute data types: StudentID (integer, primary key) StudentName (25 characters) FacultylD (integer, primary key) FacultyName (25 characters) CourselD (8 characters, primary key) CourseName (15 characters) DateQualied (date) SectionNo (integer, primary key) emester (7 characters STUDENT (StudentiD, StudentName) QUALIFIED (FacultyID, CourselD, DateQualified) StudentiD StudentName 38214 54907 Faculity D ISM 3112 2005 2143 2143 3467 3467 4756 4756 19/200s M 31 13 ISM 4212 66324 /2012 9/2008 2008 ISM 4930 9/2013 ISM 3113 ISM 3112 FACULTY (FacultyD, FaoultyName) SECTION (SectionNo, Semester, CourelD) SectionNio SemesterCounselD 2143 3467 4756 Birkin 2712 2713 2714 2715 I-2015 I-2015 1-2015 l-2015 ISM 3113 ISM 3113 ISM 4212 SM 4930 COURSE (CourselD, CourseName) REGISTRATION (StudentiD, SectionNo) oul CourneNiame StudentioSectionNe ISM 3113 ISM 3112 ISM 4212 ISM 4030 Syst Analysis Syst Design 38214 54907 54907 68324 2714 2714 2715 2713