To display records that meet one or more specific conditions, you must use ________ to limit the data

The circles in a sociogram are referred to as sociogram ______.

Fill in the blank(s) with the appropriate word(s).

Write a method that, for each student, computes the average grade. This method requires the value() method that you constructed for the previous problem.

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.