a) which students are enrolled in database and networking? ( hint: use sectionNo

Question

a) which students are enrolled in database and networking? ( hint: use sectionNo for each class so you can determine the answer from the registration table by itself)
b) which instructors cannot teach both syst analysis and syst design?
c) which courses were taught in the first semester of 2008 but not in the second semester of 2008?

38214 54907 SM 3112 2143 3467 3487 4756 ISM 3113 SM 4212 SM 4930 /1088 91996 91998 Aben 70542 ISM 3113 SM 3112 | 1001 FACULTY Fac SECTION Section Semester Course 2712 2713 2714 ISM 3113 SM 3113 ISM 4212 isM 4930 Birkon 2143 3467 4756 -2008 Golins 2008 REGISTRATION (StudentiD. SectionNo, Sme COURSE (CourselD, Cour CourselD SM 3113 SM 4212 38214 -2008 2714 271a 715 2713 Syst 4907 08324 200 SM 4900

Explanation / Answer

a) SQL query :

Select REGISTRATION.StudentID

from SECTION,REGISTRATION

where SECTION.CourseID in (Select CourseID from COURSE where CourseName = "Database" or CourseName = "Networking" );

First inner query will be executed resulting in couresid ISM 4212 and ISM 4930 then outer query will be executed.

b)

Select FacultyID,count(*)

from QUALIFIED

where CourseID in("ISM 3113" ,"ISM 3112")

group by FacultyID

having count(*)<2 ;

This query will result in FacultyID that cannot teach both syst analysis and syst design.

FacultyID having count(*) =2 means that they can teach both syst analysis and syst design. Therefore,select those facultyid whose count(*)<2.

c) Select CourseName fron COURSE where CourseID

in (Select CourseID

from SECTION

where Semester = "I-2008" and CourseID not in (Select CourseID from SECTION where Semester = "II-2008"));

First inner query will be executed resulting in courseid where Semester ="II-2008" then outer query will be executed.

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.