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.
SELECT S.Name, avg(S.Transcript.Grade.value())
FROM Student S
Computer Science & Information Technology
You might also like to view...
A ________ enables users to view or enter data one record at a time
A) form B) field C) report D) query
Computer Science & Information Technology
The ability to generate ___________________ is important for some types of applications, particularly games and simulations.
Fill in the blank(s) with the appropriate word(s).
Computer Science & Information Technology