LEADER 05537nam 22006974a 450 001 9910784564903321 005 20200520144314.0 010 $a1-280-96150-3 010 $a9786610961504 010 $a0-08-047077-7 035 $a(CKB)1000000000363581 035 $a(EBL)286668 035 $a(OCoLC)430101403 035 $a(SSID)ssj0000135094 035 $a(PQKBManifestationID)11157924 035 $a(PQKBTitleCode)TC0000135094 035 $a(PQKBWorkID)10056860 035 $a(PQKB)10546864 035 $a(Au-PeEL)EBL286668 035 $a(CaPaEBR)ebr10167029 035 $a(CaONFJC)MIL96150 035 $a(CaSebORM)9780080470771 035 $a(MiAaPQ)EBC286668 035 $a(EXLCZ)991000000000363581 100 $a20050725d2006 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aDatabase modeling & design$b[electronic resource] $elogical design /$fTobey Teorey, Sam Lightstone, Tom Nadeau 205 $a4th ed. 210 $aAmsterdam $cElsevier ;$aBoston $cMorgan Kaufmann Publishers$d2006 215 $a1 online resource (294 p.) 225 1 $aThe Morgan Kaufmann Series in Data Management Systems 300 $aDescription based upon print version of record. 311 $a0-12-685352-5 320 $aIncludes bibliographical references and index. 327 $afront cover; copyright; table of contents; front matter; Preface; Organization; Typographical Conventions; Acknowledgments; Solutions Manual; body; 1 Introduction; 1.1 Data and Database Management; 1.2 The Database Life Cycle; 1.3 Conceptual Data Modeling; 1.4 Summary; 1.5 Literature Summary; 2 The Entity-Relationship Model; 2.1 Fundamental ER Constructs; 2.1.1 Basic Objects: Entities, Relationships, Attributes; 2.1.2 Degree of a Relationship; 2.1.3 Connectivity of a Relationship; 2.1.4 Attributes of a Relationship; 2.1.5 Existence of an Entity in a Relationship 327 $a2.1.6 Alternative Conceptual Data Modeling Notations2.2 Advanced ER Constructs; 2.2.1 Generalization: Supertypes and Subtypes; 2.2.2 Aggregation; 2.2.3 Ternary Relationships; 2.2.4 General n-ary Relationships; 2.2.5 Exclusion Constraint; 2.2.6 Referential Integrity; 2.3 Summary; 2.4 Literature Summary; 3 The Unified Modeling Language (UML); 3.1 Class Diagrams; 3.1.1 Basic Class Diagram Notation; 3.1.2 Class Diagrams for Database Design; 3.1.3 Example from the Music Industry; 3.2 Activity Diagrams; 3.2.1 Activity Diagram Notation Description; 3.2.2 Activity Diagrams for Workflow 327 $a3.3 Rules of Thumb for UML Usage3.4 Summary; 3.5 Literature Summary; 4 Requirements Analysis and Conceptual Data Modeling; 4.1 Introduction; 4.2 Requirements Analysis; 4.3 Conceptual Data Modeling; 4.3.1 Classify Entities and Attributes; 4.3.2 Identify the Generalization Hierarchies; 4.3.3 Define Relationships; 4.3.4 Example of Data Modeling: Company Personnel and Project Database; 4.4 View Integration; 4.4.1 Preintegration Analysis; 4.4.2 Comparison of Schemas; 4.4.3 Conformation of Schemas; 4.4.4 Merging and Restructuring of Schemas; 4.4.5 Example of View Integration 327 $a4.5 Entity Clustering for ER Models4.5.1 Clustering Concepts; 4.5.2 Grouping Operations; 4.5.3 Clustering Technique; 4.6 Summary; 4.7 Literature Summary; 5 Transforming the Conceptual Data Model to SQL; 5.1 Transformation Rules and SQL Constructs; 5.1.1 Binary Relationships; 5.1.2 Binary Recursive Relationships; 5.1.3 Ternary and n-ary Relationships; 5.1.4 Generalization and Aggregation; 5.1.5 Multiple Relationships; 5.1.6 Weak Entities; 5.2 Transformation Steps; 5.2.1 Entity Transformation; 5.2.2 Many-to-Many Binary Relationship Transformation; 5.2.3 Ternary Relationship Transformation 327 $a5.2.4 Example of ER-to-SQL Transformation5.3 Summary; 5.4 Literature Summary; 6 Normalization; 6.1 Fundamentals of Normalization; 6.1.1 First Normal Form; 6.1.2 Superkeys, Candidate Keys, and Primary Keys; 6.1.3 Second Normal Form; 6.1.4 Third Normal Form; 6.1.5 Boyce-Codd Normal Form; 6.2 The Design of Normalized Tables: A Simple Example; 6.3 Normalization of Candidate Tables Derived from ER Diagrams; 6.4 Determining the Minimum Set of 3NF Tables; 6.5 Fourth and Fifth Normal Forms; 6.5.1 Multivalued Dependencies; 6.5.2 Fourth Normal Form; 6.5.3 Decomposing Tables to 4NF 327 $a6.5.4 Fifth Normal Form 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 fourth 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 410 4$aThe Morgan Kaufmann Series in Data Management Systems 606 $aRelational databases 606 $aDatabase design 615 0$aRelational databases. 615 0$aDatabase design. 676 $a005.75/6 700 $aTeorey$b Toby J$0633722 701 $aLightstone$b Sam$0633720 701 $aNadeau$b Tom$f1958-$0627537 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910784564903321 996 $aDatabase modeling & design$93708352 997 $aUNINA