LEADER 05492nam 2200673 a 450 001 9910455026903321 005 20200520144314.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(MiAaPQ)EBC535142 035 $a(CaSebORM)9780123747303 035 $a(PPN)183978196 035 $a(Au-PeEL)EBL535142 035 $a(CaPaEBR)ebr10378991 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$b[electronic resource] $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 608 $aElectronic books. 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 $a9910455026903321 996 $aRelational database design and implementation$92176773 997 $aUNINA LEADER 01728oam 2200457zu 450 001 9910872793503321 005 20241212214825.0 035 $a(CKB)111026746705914 035 $a(SSID)ssj0000451009 035 $a(PQKBManifestationID)12160299 035 $a(PQKBTitleCode)TC0000451009 035 $a(PQKBWorkID)10445725 035 $a(PQKB)11745190 035 $a(EXLCZ)99111026746705914 100 $a20160829d1992 uy 101 0 $aeng 181 $ctxt 182 $cc 183 $acr 200 10$aIEEE International Conference on Systems Engineering, Septebmer 17-19, 1992, Kobe International Conference Center, Kobe, Japan 210 31$a[Place of publication not identified]$cInstitute of Electrical and Electronics Engineers$d1992 300 $aBibliographic Level Mode of Issuance: Monograph 311 08$a9780780307346 311 08$a0780307348 606 $aSystems engineering$vCongresses 606 $aMechanical Engineering$2HILCC 606 $aEngineering & Applied Sciences$2HILCC 606 $aIndustrial & Management Engineering$2HILCC 615 0$aSystems engineering 615 7$aMechanical Engineering 615 7$aEngineering & Applied Sciences 615 7$aIndustrial & Management Engineering 676 $a620/.001/1 712 02$aIEEE Aerospace and Electronic Systems Society 712 02$aWright State University Department of Electrical and Computer Engineering. 712 12$aIEEE International Conference on Systems Engineering 801 0$bPQKB 906 $aBOOK 912 $a9910872793503321 996 $aIEEE International Conference on Systems Engineering, Septebmer 17-19, 1992, Kobe International Conference Center, Kobe, Japan$92541416 997 $aUNINA