(a) Relational database concepts Flashcards
1
Q
What is a relational database?
A
A database where separate tables are made for each entity, relationships between entities are represented by a foreign key
2
Q
What is a flat file database?
A
A database where data is stored in only one table with no relationships
3
Q
What is a primary key
A
A unique identifier for each record in a table.
4
Q
What is a foreign key?
A
A field in one table that refers to the primary key in another table to create a relationship.
5
Q
What is a secondary key?
A
A non-unique attribute used to improve search performance.
6
Q
What is a composite key?
A
7
Q
What is entity relationship modelling (ERM)?
A
8
Q
What is normalisation?
A
The process of dividing larger tables into smaller interlinked tables
9
Q
What is indexing in databases?
A
