Database Modeling & Design: The Fundamental Principles (Morgan Kaufmann Series in Data Management Systems)

Database Modeling & Design is a comprehensive guide to DB design for commercial database products and their applications. Throughout, Toby Teorey offers practical and immediately usable techniques for transforming the ER model into SQL data structures. New to this Edition: A simple introduction to the terms and concepts of relational databases for those new to DB application programming; a complete description of SQL with 20 sample queries; object data modeling and its relationship to ER modeling for easy conversion when needed; figures and examples utilize standard Chen notation; new coverage of DB tuning; and a new case study: an intuitive employee database example that allows the reader to concentrate on concepts rather than on the specifics of the database. Also includes solutions to selected exercises for those who want a taste of practical experience in DB design.