Find all students who have taken more than ve classes in the mathematics department.
Use the following partially dened schema to answer the queries below.
CREATE TABLE Student AS
Id INTEGER,
Name CHAR(20),
...
Transcript TranscriptType MULTISET
CREATE TYPE TranscriptType
Course REF(CourseType) SCOPE Course,
...
Grade CHAR(2)
The type CourseType is defined as usual, with character string attributes such as CrsCode,
DeptId, etc.
FROM Student S
WHERE 5 < ( SELECT count(S1.Transcript->Course)
FROM Student S1
WHERE S1.Transcript->Course.DeptId = 'MAT'
AND S1.Id = S.Id)
Computer Science & Information Technology
You might also like to view...
The Select Case structure in VBA is the simplest kind of decision structure
Indicate whether the statement is true or false
Computer Science & Information Technology
When viewing IPS logs the administrator see systems all over the world scanning the network for servers with port 22 open. The administrator concludes that this traffic is a(N):
A. Risk B. Vulnerability C. Exploit D. Threat
Computer Science & Information Technology