Normal Forms

Question 1

Redundancy in a bad DB means many facts are _______

Answer 1

repeated

Question 2

Update anomalies in a bad DB means that _______ a DB is difficult and convoluted

Answer 2

updating

Question 3

In a good DB, every ____ defines a ___

Answer 3

FD, key

Question 4

Bad designs are caused by FDs X -> Y where X is not a ___

Answer 4

key

Question 5

What is the definition of BCNF?

Answer 5

A relation with FDs F is in BCNF if for every X -> Y in F

• The FD is trivial, or
• X is a key

Question 6

A DB is in BCNF if all ______ are in BCNF

Answer 6

relations

Question 7

Good decomposition should be ________ and __________ dependencies

Answer 7

lossless, preserve