5c Characteristics Of Normal Forms ***

Question 0

The data has been normalised.

(i) Give two characteristics of data in first normal form (1NF). (2)
(ii) Give two characteristics of data in third normal form (3NF). (2)

Answer 0

(i)Two from:
Primary key (1)
Atomic data (1)
No repeating groups (1)
Unique Table name (1)
(ii) In 2nd normal form (1)
All non primary key fields are dependent on the primary key/ No functional dependency between non-key items /
There are no non key dependencies (1)

Question 1

Refer to the table Question 8a June 2012:

Describe how it is known that the data table above is not in third normal form. (2)

Answer 1

All fields must be fully dependent on the primary key (1) 2 Phone is dependent on surgeon (so not in 3NF) (1)

Question 2

Identify two characteristics of data in second normal form (2NF). (2)

Answer 2

Data is in 1st normal form (1)
all its non-key attributes are dependent on the entire primary key /there are no partial key dependencies/all non-key fields can be found using the entire primary key(1)

Question 3

Refer to Question 2a Jan 2009

Identify three characteristics of the data that show that it is not in first normal form. (3)

Answer 3

No primary key/key field (1)
Repeating groups (1)
Data is not atomic/more than one data item in a field (1) Not unique field names (1)