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 Chapter 4 and Chapter 5.

1.4 Yes (see Chapter 4 and Chapter 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 Chapter 9 and Chapter 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 Chapter 9 and Chapter 15).

1.12 See Chapter 8.

1.13 See Chapter 5.

1.14 See Chapter 14.

1.15 See Chapter 11.

1.16 See Chapter 7.

1.17 See Chapter 11.

1.18 See Chapter 13, also Appendix B.