LEADER 05562nam 2200685Ia 450 001 9910458966903321 005 20200520144314.0 010 $a1-283-00618-9 010 $a9786613006189 010 $a0-12-382021-9 035 $a(CKB)2560000000061422 035 $a(EBL)667713 035 $a(OCoLC)706453043 035 $a(SSID)ssj0000468265 035 $a(PQKBManifestationID)11973263 035 $a(PQKBTitleCode)TC0000468265 035 $a(PQKBWorkID)10497439 035 $a(PQKB)10670711 035 $a(MiAaPQ)EBC667713 035 $a(CaSebORM)9780123820204 035 $a(Au-PeEL)EBL667713 035 $a(CaPaEBR)ebr10448182 035 $a(CaONFJC)MIL300618 035 $a(EXLCZ)992560000000061422 100 $a20101223d2011 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 00$aDatabase modeling and design$b[electronic resource] $elogical design /$fToby Teorey ... [et al.] 205 $a5th ed. 210 $aAmsterdam ;$aBoston $cMorgan Kaufmann Publishers$dc2011 215 $a1 online resource (347 p.) 225 1 $aThe Morgan Kaufmann series in data management systems 300 $aRev. ed. of: Database modeling & design / Tobey Teorey, Sam Lightstone, Tom Nadeau. 4th ed. 2005. 311 $a0-12-382020-0 320 $aIncludes bibliographical references and index. 327 $aFront 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 Diagrams 327 $aActivity 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 Normalization 327 $aThe 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 Databases 327 $aXMLXML 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; Reporting 327 $aModeling 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 Opener 327 $aChapter 3: Query Optimization and Plan Selection 330 $aDatabase 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 d 410 0$aMorgan Kaufmann series in data management systems. 606 $aRelational databases 606 $aDatabase design 608 $aElectronic books. 615 0$aRelational databases. 615 0$aDatabase design. 676 $a005.75/6 701 $aTeorey$b Toby J$0633722 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910458966903321 996 $aDatabase modeling and design$92204907 997 $aUNINA