7.1. The Place of Design Theory7.2. Functional Dependencies and Boyce/Codd Normal Form7.2.1. Nonloss Decomposition7.2.2. But Isn't It All Just Common Sense?7.2.3. 1NF, 2NF, 3NF7.3. Join Dependencies and Fifth Normal Form7.3.1. The Significance of 5NF7.3.2. More on 5NF7.4. Two Cheers for Normalization7.5. Orthogonality7.6. Some Remarks on Physical Design7.7. Summary7.8. Exercises7.8.1.7.8.1.1. Exercise 7-17.8.1.2. Exercise 7-27.8.1.3. Exercise 7-37.8.1.4. Exercise 7-47.8.1.5. Exercise 7-57.8.1.6. Exercise 7-67.8.1.7. Exercise 7-77.8.1.8. Exercise 7-87.8.1.9. Exercise 7-97.8.1.10. Exercise 7-107.8.1.11. Exercise 7-117.8.1.12. Exercise 7-127.8.1.13. Exercise 7-137.8.1.14. Exercise 7-147.8.1.15. Exercise 7-157.8.1.16. Exercise 7-167.8.1.17. Exercise 7-177.8.1.18. Exercise 7-187.8.1.19. Exercise 7-197.8.1.20. Exercise 7-207.8.1.21. Exercise 7-217.7.1.22. Exercise 7-227.8.1.23. Exercise 7-237.8.1.24. Exercise 7-247.8.1.25. Exercise 7-257.8.1.26. Exercise 7-267.8.1.27. Exercise 7-277.8.1.28. Exercise 7-28