Computing‎ > ‎A2 COMP‎ > ‎COMP3‎ > ‎


Relational Database
A structured collection of data that is stored in multiple tables, where attributes are related (or linked).

An object, person, event or thing of interest to an organisation and about which data is recorded (table).

Attribute (Field)
A property or characteristic of an entity (column in a table).

Tuple (Record)
A set of attribute (field) values (a row in a table).

Primary Key
An attribute (field) which uniquely identifies a tuple (record).

Composite Key
A combination of attributes that uniquely identify a tuple.
E.G. Post Code & Door No

Foreign Key
An attribute in one table that is a primary key in another table.

SQL Links