4.10 Fundamentals of databases Flashcards
1
Q
What is a database?
A
Is an organised collection of data
Is a dynamic data structure
2
Q
What is an entity?
A
An object, person or event or thing of interest to an organisation about which data has to be stored
3
Q
What is an attribute?
A
A relevant property or characteristic of an entity by which it can be identified and described
4
Q
What is a primary key?
A
A field in a database table that acts as a unique identifier for each record
A primary key can also never be repeated within a table
5
Q
What is a foreign key?
A
A foreign key is the primary key field of one table that appears in another table to make a link between tables
6
Q
What is a composite key?
A
Composite keys are made up of more than one attribute
