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...
To move a field, click the column heading for the field to be moved to select the field, and then ____________________ the field to the desired position.
Fill in the blank(s) with the appropriate word(s).
Computer Science & Information Technology
Top-down design uses flowcharting to break the program into modules.
Answer the following statement true (T) or false (F)
Computer Science & Information Technology
Which of the following is included in only SOME business letters, not necessarily all?
A) Salutation B) Writer's signature block C) Inside address D) Subject line
Computer Science & Information Technology
A macro is associated with an ActiveX ________
A) Label B) Text Box C) Comment D) Command Button
Computer Science & Information Technology