Normal Forms Flashcards
1
Q
Redundancy in a bad DB means many facts are _______
A
repeated
2
Q
Update anomalies in a bad DB means that _______ a DB is difficult and convoluted
A
updating
3
Q
In a good DB, every ____ defines a ___
A
FD, key
4
Q
Bad designs are caused by FDs X -> Y where X is not a ___
A
key
5
Q
What is the definition of BCNF?
A
A relation with FDs F is in BCNF if for every X -> Y in F
- The FD is trivial, or
- X is a key
6
Q
A DB is in BCNF if all ______ are in BCNF
A
relations
7
Q
Good decomposition should be ________ and __________ dependencies
A
lossless, preserve
