1.3.2 Databases Flashcards
What is a relational database?
A database which recognises the difference between entities and uses different tables for each entity.
What is an entity?
An item of interest about which information is stored.
What is a flat file?
A database that consists of a single file, usually about one entity.
What is a primary key?
A unique identifier for each record in a table.
What is a foreign key?
The attribute which links two tables together.
What is a secondary key?
An index other than the primary key used to search and sort through the database with more convenience and speed.
What does capturing data mean?
The process of getting the information that will be stored in the database.
What method do banks use to capture data from cheques?
Magnetic Ink Character Recognition (MICR) is used for all of the details apart from the amount which must be entered manually.
What does selecting data mean?
Selecting data is the process of removing excess information to extract only the data you require.
What does managing the data mean?
To manipulate the information collected in any type of way such as sorting through it or selecting certain parts using SQL.
What is the most common language used to manipulate data in databases?
SQL (Structured Query Language).