Until now, almost all books on logical database design focused exclusively on relational design. However, modern database management systems have added powerful features that have driven a movement away from truly normalized database design. Logical Database Design Principles reflects these recent changes. The book begins by covering traditional logical design principles, followed by an analysis of the normalizing and modeling of data. It then examines designing for specific purposes, such as object-oriented databases, online transaction processing (OLTP), and data warehouses. As the text progresses, it moves from the purely logical into some physical design, as determined by how the features of modern databases are implemented. Because this is a logical-design book, the authors attempt to make the examples database-neutral. Because various vendors implement features in different ways, this volume sometimes offers examples from a specific database management system. When necessary, it highlights a specific application, clearly demonstrating the concept being discussed.... 39, 40, 41 E Employee example constraints, 43 creating, 43, 43 dropping, 43, 43 entity relation diagram, 27a31, 28 first ... diagrams (ERDs) Extensibility, 88 F Favorite example, 60a62, 65 FDD, see Functional decomposition diagram (FDD) anbsp;...
|Title||:||Logical Database Design Principles|
|Author||:||John Garmany, Jeff Walker, Terry Clark|
|Publisher||:||CRC Press - 2005-05-12|