PPT Slide

Example: SQL3 Row Types (plus Sets...)

under Person_t as (

salary Float,

job_description Varchar(100),

department ref(Dept),

projects set(ref(Project)

);

create table IBM_Emps of Emp_t

under IBM_People (...);

name Varchar(20),

birthdate Date)

method age( ) returns Integer language SQL;

create method age( ) for Person_t

return year(current date) - year(birthdate);

create table IBM_People of Person_t (ref is self);

(**Note: this is approximate SQL3 syntax)