Please complete question 1

Problems and Exercises 1 through 9 are based on the class scheduling 3NF relations along with some sample data shown in Figure 6-11. Not shown in this figure are data for an ASSIGNMENT relation, which represents a many-to-many relationship between faculty and sections. 1. Write a database description for each of the relations shown, using SQL DDL (shorten, abbreviate, or change any data names, as needed for your SQL version). Assume the fol- lowing attribute data types: StudentID (integer, primary key) StudentName (25 characters) FacultyID (integer, primary key) Faculty Name (25 characters) CourseID (8 characters, primary key) CourseName (15 characters) Date Qualified (date) SectionNo (integer, primary key) Semester (7 characters) STUDENT (Student D, StudentName) QUALIFIED (FacultyID, CourselD, Date Qualified) StudentID Student Name FacultyID CourselD Date Qualified 9/1988 9/1988 38214 54907 66324 70542 Letersky Altvater Aiken Marra 9/1995 2143 2143 3467 3467 4756 4756 ISM 3112 ISM 3113 ISM 4212 ISM 4930 ISM 3113 ISM 3112 9/1996 9/1991 9/1991 FACULTY (FacultyID, FacultyName) SECTION (SectionNo, Semester, CourselD) FacultyID Faculty Name Section No Semester CourselD 2143 3467 4756 Birkin Berndt Collins 2712 2713 2714 2715 1-2008 1-2008 I-2008 I-2008 ISM 3113 ISM 3113 ISM 4212 ISM 4930 COURSE (CourselD, CourseName) REGISTRATION (Studenti, SectionNo, Semester) CourselD CourseName Studenti Section No Semester ISM 3113 ISM 3112 ISM 4212 ISM 4930 Syst Analysis Syst Design Database Networking 38214 54907 54907 66324 2714 2714 2715 2713 1-2008 1-2008 1-2008 1-2008