LEADER 05435nam 2200661 a 450 001 9910778589303321 005 20240111111502.0 010 $a1-282-25841-9 010 $a9786612258411 010 $a0-08-088501-2 035 $a(CKB)1000000000798786 035 $a(EBL)535142 035 $a(OCoLC)459953627 035 $a(SSID)ssj0000386359 035 $a(PQKBManifestationID)11245201 035 $a(PQKBTitleCode)TC0000386359 035 $a(PQKBWorkID)10389028 035 $a(PQKB)10028953 035 $a(Au-PeEL)EBL535142 035 $a(CaPaEBR)ebr10378991 035 $a(CaSebORM)9780123747303 035 $a(MiAaPQ)EBC535142 035 $a(PPN)183978196 035 $a(EXLCZ)991000000000798786 100 $a20090602d2009 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aRelational database design and implementation $eclearly explained /$fJan L. Harrington 205 $a3rd ed. 210 $aAmsterdam ;$aBoston $cMorgan Kaufmann/Elsevier$dc2009 215 $a1 online resource (441 p.) 300 $aRev. ed. of: Relational database design clearly explained. 2nd ed. 2002. 311 $a0-12-374730-9 320 $aIncludes bibliographical references and index. 327 $aFront cover; Half title page; Relational Database Design and Implementation; Copyright page; Table of Contents; Preface to the Third Edition; Changes in the Third Edition; What You Need to Know; Acknowledgments; Part I Introduction; Introduction; Chapter 1 The Database Environment; Defining a Database; Lists and Files; Databases; Data "Ownership"; Service-Oriented Architecture; Database Software: DBMSs; Database Hardware Architecture; Centralized; Client/Server; Distributed; The Web; Remote Access; Other Factors in the Database Environment; Security; Government Regulations and Privacy 327 $aLegacy DatabasesFor Further Reading; Chapter 2 Systems Analysis and Database Requirements; Dealing with Resistance to Change; The Structured Design Life Cycle; Conducting the Needs Assessment; Assessing Feasibility; Generating Alternatives; Evaluating and Choosing an Alternative; Creating Design Requirements; Alternative Analysis Methods; Prototyping; Spiral Methodology; Object-Oriented Analysis; For Further Reading; Part II Database Design Theory; Database Design Theory; Chapter 3 Why Good Design Matters; Effects of Poor Database Design; Unnecessary Duplicated Data and Data Consistency 327 $aData Insertion ProblemsData Deletion Problems; Meaningful Identifiers; Chapter 4 Entities and Relationships; Entities and Their Attributes; Entity Identifiers; Single-Valued versus Multivalued Attributes; Avoiding Collections of Entities; Documenting Entities and Their Attributes; Entities and Attributes for Antique Opticals; Domains; Documenting Domains; Practical Domain Choices; Basic Data Relationships; One-to-One Relationships; One-to-Many Relationships; Many-to-Many Relationships; Weak Entities and Mandatory Relationships; Documenting Relationships; The Chen Method; IE Style Diagrams 327 $aUML Style DiagramsBasic Relationships for Antique Opticals; Dealing with Many-to-Many Relationships; Composite Entities; Documenting Composite Entities; Resolving Antique Opticals' Many-to-Many Relationships; Relationships and Business Rules; Data Modeling versus Data Flow; Schemas; For Further Reading; Chapter 5 The Relational Data Model; Understanding Relations; Columns and Column Characteristics; Rows and Row Characteristics; Types of Tables; A Notation for Relations; Primary Keys; Primary Keys to Identify People; Avoiding Meaningful Identifiers; Concatenated Primary Keys 327 $aAll-Key RelationsRepresenting Data Relationships; Referential Integrity; Foreign Keys and Primary Keys in the Same Table; Views; The View Mechanism; Why Use Views?; The Data Dictionary; Sample Data Dictionary Tables; A Bit of History; For Further Reading; Chapter 6 Normalization; Translating an ER Diagram into Relations; Normal Forms; First Normal Form; Understanding Repeating Groups; Handling Repeating Groups; Problems with First Normal Form; Second Normal Form; Understanding Functional Dependencies; Using Functional Dependencies to Reach 2NF; Problems with 2NF Relations; Third Normal Form 327 $aTransitive Dependencies 330 $aFully revised, updated, and expanded, Relational Database Design and Implementation, Third Edition is the most lucid and effective introduction to the subject available for IT/IS professionals interested in honing their skills in database design, implementation, and administration. This book provides the conceptual and practical information necessary to develop a design and management scheme that ensures data accuracy and user satisfaction while optimizing performance, regardless of experience level or choice of DBMS.The book begins by reviewing basic concepts of databases and database des 606 $aRelational databases 606 $aDatabase design 615 0$aRelational databases. 615 0$aDatabase design. 676 $a005.75/6 700 $aHarrington$b Jan L$0627492 701 $aHarrington$b Jan L$0627492 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910778589303321 996 $aRelational database design and implementation$93782516 997 $aUNINA