Normalisation(1.3.2 c)

Question 1

Standards

Answer 1

very important without them communication would be impossible across devices

Question 2

Normal forms

Answer 2

ONF (UNF)
1NF
2NF
3NF

Question 3

0NF conditions

Answer 3

each field must be unique
unique records
each record must have same number of fields
all data in each field must have same domain/type

Question 4

1NF condition

Answer 4

all elements must be atomic

Question 5

What does atomic mean?

Answer 5

indivisible

Question 6

2NF condition

Answer 6

each field must depend on the whole key or not (no partial dependencies)

Question 7

3NF conditions

Answer 7

each must depend on the key (no transitive dependencies)