05562nam 2200685Ia 450 991045896690332120200520144314.01-283-00618-997866130061890-12-382021-9(CKB)2560000000061422(EBL)667713(OCoLC)706453043(SSID)ssj0000468265(PQKBManifestationID)11973263(PQKBTitleCode)TC0000468265(PQKBWorkID)10497439(PQKB)10670711(MiAaPQ)EBC667713(CaSebORM)9780123820204(Au-PeEL)EBL667713(CaPaEBR)ebr10448182(CaONFJC)MIL300618(EXLCZ)99256000000006142220101223d2011 uy 0engur|n|---|||||txtccrDatabase modeling and design[electronic resource] logical design /Toby Teorey ... [et al.]5th ed.Amsterdam ;Boston Morgan Kaufmann Publishersc20111 online resource (347 p.)The Morgan Kaufmann series in data management systemsRev. ed. of: Database modeling & design / Tobey Teorey, Sam Lightstone, Tom Nadeau. 4th ed. 2005.0-12-382020-0 Includes bibliographical references and index.Front Cover; Database Modeling and Design; Copyright; Dedication; Contents; Preface; Organization; Typographical Conventions; Acknowledgments; Solutions Manual; About the Authors; Chapter 1: Introduction; Data and Database Management; Database Life Cycle; Conceptual Data Modeling; Summary; Tips and Insights for Database Professionals; Literature Summary; Chapter 2: The Entity-Relationship Model; Fundamental ER Constructs; Advanced ER Constructs; Summary; Tips and Insights for Database Professionals; Literature Summary; Chapter 3: The Unified Modeling Language; Class DiagramsActivity DiagramsSummary; Tips and Insights for Database Professionals; Literature Summary; Chapter 4: Requirements Analysis and Conceptual Data Modeling; Introduction; Requirements Analysis; Conceptual Data Modeling; View Integration; Entity Clustering for ER Models; Summary; Tips and Insights for Database Professionals; Literature Summary; Chapter 5: Transforming the Conceptual Data Model to SQL; Transformation Rules and SQL Constructs; Transformation Steps; Summary; Tips and Insights for Database Professionals; Literature Summary; Chapter 6: Normalization; Fundamentals of NormalizationThe Design of Normalized Tables: A Simple ExampleNormalization of Candidate Tables Derived from ER Diagrams; Determining the Minimum Set of 3NF Tables; Summary; Tips and Insights for Database Professionals; Literature Summary; Chapter 7: An Example of Logical Database Design; Requirements Specification; Logical Design; Summary; Tips and Insights for Database Professionals; Chapter 8: Object-Relational Design; Object Orientation; Object-Oriented Databases; Object-Relational Databases; Summary; Tips and Insights for Database Professionals; Literature Summary; Chapter 9: XML and Web DatabasesXMLXML Design; Web-Based Applications; Summary; Tips and Insights for Database Professionals; Literature Summary; Chapter 10: Business Intelligence; Data Warehousing; Online Analytical Processing; Data Mining; Summary; Tips and Insights for Database Professionals; Literature Summary; Chapter 11: CASE Tools for Logical Database Design; Introduction to the CASE Tools; Key Capabilities to Watch for; The Basics; Generating a Database from a Design; Database Support; Collaborative Support; Distributed Development; Application Life Cycle Tooling Integration; Design Compliance Checking; ReportingModeling a Data WarehouseSemistructured Data-XML; Summary; Tips and Insights for Database Professionals; Literature Summary; Appendix: The Basics of SQL; SQL Names and Operators; Data Definition Language; Data Manipulation Language; References; References; Exercises; ER and UML Conceptual Data Modeling; Conceptual Data Modeling and Integration; Transformation of the Conceptual Model to SQL; Normalization and Minimum Set of Tables; Logical Database Design (Generic Problem); OLAP; Solutions to Selected Exercises; Glossary; Index; Bonus Chapter OpenerChapter 3: Query Optimization and Plan SelectionDatabase systems and database design technology have undergone significant evolution in recent years. The relational data model and relational database systems dominate business applications; in turn, they are extended by other technologies like data warehousing, OLAP, and data mining. How do you model and design your database application in consideration of new technology or new business needs? In the extensively revised fifth edition, you'll get clear explanations, lots of terrific examples and an illustrative case, and the really practical advice you have come to count on--with dMorgan Kaufmann series in data management systems.Relational databasesDatabase designElectronic books.Relational databases.Database design.005.75/6Teorey Toby J633722MiAaPQMiAaPQMiAaPQBOOK9910458966903321Database modeling and design2204907UNINA