The following 3 relation instances exist... Student (SNAME, SNO) with values ( \
ID: 3624144 • Letter: T
Question
The following 3 relation instances exist...Student (SNAME, SNO) with values (
'Jim J', 'S01',
'Bob D', 'S02',
'Calvin S', 'S03',
'Ronald D', 'S04',
'Melody H', 'S05',
'Linda L', 'S06')
Course (CNAME, CNO) with values (
'MTH 104', 'C1',
'PHY 102', 'C2',
'CS 103', 'C3',
'STT 106', 'C4')
Result (SNO, CNO, MARK) with values (
'S01', 'C1', 73,
'S01', 'C2', 89,
'S02', 'C2', 88,
'S02', 'C3', 78,
'S02', 'C4', 92,
'S03', 'C2', 77,
'S03', 'C3', 81,
'S04', 'C2', 78,
'S04', 'C3', 67,
'S04', 'C4', 56,
'S05', 'C1', 44,
'S05', 'C4', 79,
'S06', 'C2', 91,
'S06', 'C3', 76,
'S06', 'C4', 52)
One thing to note; for the result relation, a mark of 60 or greater is considered passing.
Find two queries:
Q1. Find the names of students who did not pass any course that 'Linda L' passed.
Q2. Find the names of students who passed every course that 'Linda L' passed.
Explanation / Answer
Q1. There are no students who did not pass a course that Linda L passes Q2. Bob D Calvin S Ronald D passed every classes Linda L passed