Database modeling and design

Mehr zum Buch

This new edition continues to emphasize relational database design techniques, beginning with the entity-relationship (ER) approach for data requirements specification and conceptual modeling. Author Toby Teorey explores common properties in data modeling and operations shared among the relational model and advanced database technologies, such as object-oriented, temporal, and multimedia models. A dedicated chapter addresses database design techniques for data warehousing and online analytical processing (OLAP). Teorey outlines the database life cycle, covering requirements analysis, logical design, and physical design for local, distributed, and multidatabases. The discussion of fundamental principles is enhanced with a practical, running company personnel and project database based on real-life experiences and classroom testing. This resource is tailored for both novice and professional database designers, providing essential insights into database modeling and the creation of standard SQL data definitions. The design rules presented 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. Key features include a continued focus on the relational model and the integration of information about data warehousing, OLAP, and other advanced database technologies.