Teorey (electrical engineering and computer science, U. of Michigan-Ann Arbor) presents a guide for the novice or ace database practitioner in business, science, or engineering; a supplemental textbook for a graduate or advanced undergraduate course introducing database management; or a core text in a course of the title subject. Earlier editions appeared in 1990 and 1994. Annotation c. Book News, Inc., Portland, OR (booknews.com)
Read More
This new edition of Database Modeling & Design continues to focus on the techniques for relational database design introduced in previous editions, starting with the entity-relationship (ER) approach for data requirements specification and conceptual modeling. Author Toby Teorey then looks ahead to the common properties in data modeling and operations shared among the relational model and advanced database technologies such as the object-oriented, temporal, and multimedia models. A full chapter is devoted to database design techniques for data warehousing and online analytical processing (OLAP).Teorey covers the database life cycle from requirements analysis and logical design to physical design for local, distributed, and multidatabases. The discussion of basic principles is supplemented with a common, running example: a company personnel and project database based on real-life experiences and classroom testing.Written for both the novice and the professional database designer, this book is the essential resource for database modeling, including the building of standard SQL data definitions. The design rules set forth in this book are applicable to any SQL-based system, including IBM DB2, Oracle V8.0, Informix IDS-UDO, Microsoft Access, Microsoft SQL Server, and Sybase Adaptive Server Enterprise.* Continued focus on relational model* Integration of information about data warehouse and OLAP, plus other advanced database technologies, including object oriented, multimedia, and temporal database* Discussion of basic principles is supplemented by examples based on real life cases
Read Less