Chapter 3: Data

Question 1

What is the primary key?

Answer 1

A unique identifier (field) for each record in a table

Question 2

What is a foreign key?

Answer 2

A field in one table that uniquely identifies a record in another table (i.e. is the primary key in another table)

Question 3

What is a relational database?

Answer 3

A database that uses foreign keys to link multiple different tables together

Question 4

What is a compound key?

Answer 4

A key that consists of two or more fields used to identify a record uniquely

Question 5

What is unstructured data? (name some examples)

Answer 5

Data without a clear structure (e.g. emails, images, PPTs)