1.3.2 Databases

Question 1

What is a flat file

Answer 1

A single table database

Question 2

0NF

Answer 2

Flat file with no normalisation

Question 3

1NF

Answer 3

All field names must be unique

Values in fields should be from the same domain

Values in fields should be atomic (happening all at once or not at all)

No two records can be identical

Each record needs a primary key

Question 4

2NF

Answer 4

The data is already in 1NF

Any partial dependencies have been removed.

Fix any M:M relationships that ensue

Question 5

3NF

Answer 5

The data is already in 2NF

Any transitive dependencies have been removed (ensure that non-key are not dependent on each other)