Modeling

Revealing their consultancy roots, Stephens and Plew start with methods of determining business requirements and stay focused on business issues throughout their tutorials. The section on data normalization exemplifies the authors' method of explaining technical issues: they present a considerable amount of prose on why normalization (the process by which "Steve Jones," in entered data, is recognized as the same person as "Stephen P. Jones" where it is appropriate to do so) is a good idea, as well as some of its drawbacks and alternatives. They then present a series of table schema that shows how normalization works in practice. It's a worthwhile read for working and soon-to-be-working database designers. --David Wall

Topics covered: Database design for people who haven't designed databases before or who have done so without the background knowledge they should have had. The authors cover business requirements, entities and relationships, normalization, integrity maintenance, and query design. There are also sections on modifying legacy databases and implementing ancillary features such as security.