1.3.2

Question 1

What is a primary key

Answer 1

A unique identifier for each record in a table

Question 2

What is a foreign key

Answer 2

The attribute which links two tables together

Question 3

What is a secondary key

Answer 3

An index other than the primary key used to search and sort through the database with more convince and speed

Question 4

What does ACID stand for

Answer 4

Atomicity
Consistency
Isolation
Durability

Question 5

Atomicity

Answer 5

Completing only part of a transaction can cause things to break. The best way to ensure this is to make transactions atomic. Meaning they cannot be broken down further.

A database management system ensures that every step must succeed before the database is permanently changed

Question 6

Consistency

Answer 6

Every database has a set of rules about the kind of data held within its fields and the relationships between tables and keys.
Consistency means that a transaction must ensure that all database rules are being followed.

Question 7

Isolation

Answer 7

No other transaction can interfere with the data being handled by the current transaction until it has completed its update

Question 8

Durability

Answer 8

Whenever a transaction has taken place the update must remain in place even if there is a system failure, a durable transaction is recorded in such a way that the results cannot easily be lost