OR

Question 1

Typendefinition

Answer 1

create type Adress_Typ as
(ort varchar(30),
plz integer,
strasse varchar(30))

Question 2

Erstelle Tabelle aus Typ

Answer 2

create table Adresse of Adress_Typ(

ref OID is system generated);

Question 3

Vererbung

Answer 3

create type Geschäftsadresse_Typ under Adress_Typ
as (gebiet varchar(30))
ref is system generated;

create table Geschäftsadresse of Geschäftsadresse_Typ(
ref OID is system generated);

Question 4

Referenzen

Answer 4

create type Assistent_Typ under Angestellter_Typ 
as (
fachgebiet varchar(30),
boss ref Professor_Typ scope Professor)
ref is system generated;

create table Assistent of Assistent_Typ (
personalNr primary key,
ref OID is system generated);