COMP6240 Midsemester Exam

Question 1

(i) Same as COMP2400 exam
(ii)
   SELECT CourseCode
   FROM Course
   WHERE NOT EXISTS
     (SELECT StudentId FROM Student
      WHERE StudentId NOT IN
        (SELECT StudentId FROM Enrolment
         WHERE Enrolment.CourseCode = Course.CourseCode))
(iii) Same as COMP2400 exam
(iv) Same as COMP2400 exam
(v) Same as COMP2400 exam

Question 2

(a) Same as COMP2400 exam
(b) Same as COMP2400 exam
(c) Same as (d) in COMP2400 exam
(d) Same as (e) in COMP2400 exam
(e) Which authors always had co-authors on their papers, i.e. have no papers of which they are the only author.

Question 3

Same as COMP2400 exam
Last modified: Thu Sep 29 16:02:27 EST 2005