Normal Forms

Question 1

1st Normal Form

Answer 1

Mandatory Normal Form
Disallow multivalued and composite attributes
Allow only atomic values

Question 2

What’s a prime attribute

Answer 2

Attribute that is part of candidate key

Question 3

Atomic Values

Answer 3

Either some ONE value or NULL value

Question 4

Normalization

Answer 4

Normalize by removing multivalued and composite attributes

Question 5

2nd Normal Form

Answer 5

Non Prime attribute partially functionally dependent on key

Question 6

Partial Functional Dependency

Answer 6

If no non key attribute depending on PART of a key attribute

Question 7

Full Functional Dependency

Answer 7

non key attribute depending on COMPLETE key attribute

Question 8

If key is one attribute

Answer 8

Definitely 2NF because no PFD is possible

Question 9

3rd Normal Form

Answer 9

N2 and no non prime attribute transitively dependent on key

Question 10

Transitive dependency

Answer 10

key –> non key –> some attribute
some attribute transitively dependent on key