Computer Science
Define a 'database'
An organised collection of data stored in a computer
Define a 'Flat File'
A simple data base where all data is on one table
Define a 'Relational Database'
A database where data is organised into multiple tables.
Define an 'attribute'
Describes the detail/characteristics of an object
Define a 'Primary Key'
A unique identifier for a record in a table, consisting of one or more attributes
Define a 'Composite primary key'
Where a unique identifier must consist of more than 1 attribute
Define a 'Foreign Key'
An attribute that links 2 tables together
Define a 'Secondary key'
An attribute used to build an index for faster searching
Define 'Referential Integrity'
Where no foreign key in one table can reference a non-existent record in a related table
Define a 'Record'
All the info held about a single object( a row in a table)