Databases Flashcards
What is a database?
A collection of data or information which is held together in an organised or logical way.
What is a table?
A table stores all the records for a particular category.
What is a Field?
A ‘field’ is one piece of data or information about one person or thing.
What is a record?
A record is all of the data or information about one person or thing.
What’s a Relational Database?
A database comprised of multiple entities.
What’s a Flat File Database?
A database consisting of a single table.
What is a Primary Key
The column that contains values that identify each row in a table.
What is a Foreign Key?
Used to link two tables together.
What is Referential Integrity?
A table into which an enumerated set of possible values of a certain field type is divested.
What is a simple Primary Key?
A key in relational database that is unique for each record.
What is a Compound Primary Key?
It is always made up of two or more primary keys from other tables.
What is a Secondary Key?
An additional key, or alternate key, which can be used in addition to the primary key to locate specific data.
