Name:
CS 487 Test 2
October 21, 2004
Student
SID: int major: int email : text name : text
Exam
EID: int QID : int
Question
SID: int QID : int Answer : text Grade : int
Grade
SID: int Eid : int Grade : int
{s.name q.grade |Student(s)∧Question(q)∧E xam(e)∧e.id = 2 ∧e.q id =q.qid ∧q .sid =s.sid ∧
((∀r)(not(Question(r)) ∨q.qid 6=r.qid ∨q.grade ≥r.grade ∨((∀t)not(S tudent(t)) ∨t.major 6=s.maj or))) }
What does the above query do?
Write the same query in SQL.
Assume that there are four questions on test 2. Could the division operator be used to identify students who
correctly answered questions 1, 2, and 4 on test 2? If so, demonstrate, else describe why not?
