[prev] 53 [next]

Records vs Tuples

A table is defined by a collection of attributes (schema), e.g. 

create table Employee (
   id#  integer primary key,
   name varchar(20),   -- or char(20)
   job  varchar(10),   -- or char(10)
   dept number(4)
);

Tuple = collection of attribute values for such a schema, e.g. 

    (33357462, 'Neil Young', 'Musician', 0277)

Record = sequence of bytes, containing data for one tuple.