[prev] 3 [next]

Records vs Tuples

A table is defined by a schema, e.g. 

create table Employee (
   id   integer primary key,
   name varchar(20) not null,
   job  varchar(10), 
   dept number(4) references Dept(id)
);

where a schema is a collection of attributes  (name,type,constraints)

Schema information (meta-data) is stored in the DB catalog