Write SQL queries to compute the following information ( note: you are not allowed to use in, exists, forall, intersect, diff, union, or except):

1- What is the name of faculty member whose ID is 4756?

2- Dispaly the students, including student name and ID, for all students registered for section 2714 of ISM4212.

3- How many students are registered in Section 2714 in the first semester of 2008?

4- Display the faculty ID and name of instructors qualified to teach at least 3 courses.

5- Find the course name and ID for courses that, whes they were taught (i.e. had students registered for them), always had more than 3 sections being taught.

Write SQL queries to compute the following information ( note: you are not allowed to use in, exists, forall, intersect, diff, union, or except):

1- Display the student name and ID of those students who were not regidtered in any course during semester I-2008.

2- Display the course name and ID of all courses that have never been tought (i.e. never had any sudents registered in them)

3- Show the student ID and name of those students who have never registered in more than 2 courses per semester.

Display the counse ID and course name for all courses with an ISM prefix b. Display all courses for which Professor Berndt has been set contionses from Chapter 6 Prolems a prb rogl 15, ulach soee hased on Figoe 612 6. Determine the relationships among the b Figure 7-17. List primary keys for onch e c Display the class rostet, including student name for all students enrolled in section 2714 of ISM 4212 Write an SQL query to answer the following question Which instructors are qualified to teach ISM 3113? Write an SQLquery to answer the following question: Is any instructor qualified to teach ISM 3113 and not qualified to teach ISM 49302 the rel maintain referential integrity Pay particol the data contained in TUTOR REPORTS w foreign keys necessary to its primary key STUDENT (StudentID, StudentName) Studer ID 38214 54907 66324 70542 2143 2143 3467 3467 ISM 3112 91988 SM 3113 9/1988 ISM 4212 9995 ISM 4930 9/1996 ISM 3113 9/199 ISM 3112 9/1991 FACULTY (Faculty D, FacultyNamel 2712 2713 ISM 3113 ISM 3113 3467 Bemdt 1200B 2715 1-2008 ISM 4930 CourseName REGISTRATION (StuderD 2714 2714 54907 54907 66324 -2008 2713 F2008