Databases Reference
In-Depth Information
Appendix D
A n s w e r s t o E x e r c i s e s
Science offers the best answers
─Richard Dawkins: Break the Science Barrier
Note: All mistakes in this appendix are deliberate <joke> .
CHAPTER 1
1.1 Yes, it is. Good design benefits the user, and to some extent the DBMS as well, but the relational model as
such doesn't care how the database happens to be designed, just so long as it doesn't violate any of the precepts of
the relational model─in particular, so long as the objects it has to deal with are indeed relations and not something
else (which, sadly, they often are in SQL).
1.2
See Chapter 15.
1.3
See Chapters 4 and 5.
1.4
Yes (see Chapters 4 and 5).
1.5
No. (Actually, it's not even true that every binary relvar is in 2NF. See Exercise 4.6.)
1.6
No (see Chapters 9 and 10).
1.7
No a fortiori, given the answer to Exercise 1.5.
1.8
No (see Chapter 13).
1.9
No (see Chapter 13).
1.10
See Chapter 10.
1.11
No (see Chapters 9 and 15).
1.12
See Chapter 8.
1.13
See Chapter 5.
1.14
See Chapter 14.
1.15
See Chapter 11.
 
Search WWH ::




Custom Search