1.3.2 Databases Flashcards
1
Q
what is a relational database?
A
a database which recognises the
difference between entities and uses different tables for each entity
2
Q
what is an entity?
A
an item of interest about which
information is stored
3
Q
what is a flat file?
A
a database that consists of a single file
(usually about one entity)
4
Q
what is a primary key?
A
a unique identifier for each record in a table
5
Q
what is a foreign key?
A
the attribute which links two tables
together
6
Q
what is a secondary key?
A
an index other than the primary key used to search and sort through the database with more convenience and speed
7
Q
what does capturing data mean?
A
the process of getting the information that will be stored in the database
