1. Write an SQL query to answer the following question: Which instructors are qualified to teach ISM 3113?
2. Write an SQL query to answer the following question: Is any instructor qualified to teach ISM 3113 and not qualified to teach ISM 4930?
3. Write SQL queries to answer the following questions:
a. How many students were enrolled in section 2714 during semester I-2008?
b. How many students were enrolled in ISM 3113 during semester I-2008?

Transcribed Image Text:

STUDENT (StudentiD, StudentName) QUALIFIED (FacultylD, CourselD, DateQualified) StudentID FacultylD CourselD DateQualifie 38214 54907 66324 70542 2143 2143 3467 ISM 3112 ISM 3113 ISM 4212 ISM 4930 ISM 3113 ISM 3112 9/1988 9/1988 9/1995 9/1996 9/1991 9/1991 4756 4756 FACULTY (FacultylID, FacultyName) Facultycuyame SemestCourseID 2143 3467 4756 Birkin Berndt 2712 2713 2714 2715 I-2008 I-2008 I-2008 I-2008 ISM 3113 ISM 3113 ISM 4212 ISM 4930 COURSE (CourselD, CourseName) REGISTRATION (StudentiD, SectionNo, Semester) Coursel D StudentiD SectionNo ISM 31 ISM 3112 ISM 4212 ISM 4930 13 Syst Analysis 38214 54907 54907 66324 2714 2714 2715 2713 -2008 -2008 -2008 -2008 Syst Design Database