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