1. Write a SQL DDL statement to perform the following operations on the database

a. Add a new course ISM 4950 Computing

b. Make faculty Bernard (ID 1234) to be eligible to teach ISM 4650 wed Jan, 2015

c. Register student Maria (ID 12345) for ISM 4930 during the 1-2008 semester

2. Create views for the following

a. Students registered in each course for the current term.

b. Faculty who are qualified to teach each course

STUDENT (StudentlD, StudentName) QUALIFIED (FacultylD ourselD, DateQualified) FacultylD ourselDDateQualified StudentlD StudentName 38214 54907 66324 70542 Letersky Altvater Aiken Marra 2143 2143 3467 3467 4756 4756 ISM 3112 9/2005 ISM 3113 9/2005 ISM 4212 9/2012 ISM 4930 9/2013 ISM 3113 9/2008 ISM 3112 9/2008 FACULTY (FacultylD, FacultyName) SECTION (SectionNo, Semester, CourselD) FacultylDFacultyName SectionNo Semester CourselD 2143 3467 4756 Birkin Berndt Collins 2712 2713 2714 2715 -2015 -2015 -2015 -2015 ISM 3113 ISM 3113 ISM 4212 ISM 4930 COURSE (CourselD, CourseName) REGISTRATION (StudentlD, SectionNo) CourselD StudentlD SectionNo 38214 54907 54907 66324 2714 2714 2715 2713 Syst Analysis Syst Design ISM 3113 ISM 3112 ISM 4212 ISM 4930 Database FIGURE 7-16 Class scheduling relations (for Problems and Exercises 7-25-7-30)