05492nam 2200673 a 450 991045502690332120200520144314.01-282-25841-997866122584110-08-088501-2(CKB)1000000000798786(EBL)535142(OCoLC)459953627(SSID)ssj0000386359(PQKBManifestationID)11245201(PQKBTitleCode)TC0000386359(PQKBWorkID)10389028(PQKB)10028953(MiAaPQ)EBC535142(CaSebORM)9780123747303(PPN)183978196(Au-PeEL)EBL535142(CaPaEBR)ebr10378991(EXLCZ)99100000000079878620090602d2009 uy 0engur|n|---|||||txtccrRelational database design and implementation[electronic resource] clearly explained /Jan L. Harrington3rd ed.Amsterdam ;Boston Morgan Kaufmann/Elsevierc20091 online resource (441 p.)Rev. ed. of: Relational database design clearly explained. 2nd ed. 2002.0-12-374730-9 Includes bibliographical references and index.Front 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 PrivacyLegacy 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 ConsistencyData 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 DiagramsUML 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 KeysAll-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 FormTransitive DependenciesFully 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 desRelational databasesDatabase designElectronic books.Relational databases.Database design.005.75/6Harrington Jan L627492Harrington Jan L627492MiAaPQMiAaPQMiAaPQBOOK9910455026903321Relational database design and implementation2176773UNINA