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
You might also like to view...
What is the value of x after the following function call, given the function definition below?
int x; aFunction (3, x); // function call void aFunction (int a, int &b) // function definition { b = a * 5 + 1; }
The width value for a single cell might be overridden by browsers if other cells in the column require a smaller width to display their content.
Answer the following statement true (T) or false (F)
Blackboard is an example of gaming software
Indicate whether the statement is true or false
__________ is a program routine that copies an executable program into memory for execution.
A. Compiler B. Loader C. Instruction set D. Executable code