Designing effective database systems /
Rebecca M. Riordan.
- Upper Saddle River, N.J. ; London : Addison-Wesley, c2005.
- xix, 353 p. : ill. ; 24 cm.
Includes bibliographical references (p. 335-336) and index.
Part I - Relational database theory -- 1.Basic concepts -- 2.Database structure -- 3.Relationships -- 4.Data integrity -- 5.Relational algebra-- Part II.Dimensional database theory -- 6.Basic dimensional concepts -- 7.Fact tables -- 8.Dimesion tables -- Part III - Designing database systems -- 9.The design process -- 10.Defining the system parameters -- 11.Defining the work processes -- 12.The conceptual data model -- 13.The database schema -- 14.Communicating the design -- Part IV.Designing the user interface -- 15.The interface as mediator -- 16.Using interface architectures -- 17.Representing entitites in form design -- 18.Choosing windows control -- 19.Maintaining database integrity -- 20.Reporting -- 21.User assistance.
Riordan presents a clear, easy-to-follow guide to the messy practice of building an effective database, using lots of real-world examples.