SynopsisKEY MESSAGE: This best-selling text introduces the theory behind databases in a concise yet comprehensive manner, providing database design methodology that can be used by both technical and non-technical readers. The methodology for relational Database Management Systems is presented in simple, step-by-step instructions in conjunction with a realistic worked example using three explicit phases-conceptual, logical, and physical database design. KEY TOPICS: Background: Introduction to Databases; Database Environment; Database Architectures and the Web. The Relational Model and Languages: The Relational model; Relational Algebra and Relational Calculus; SQL: Data Manipulation; SQL: Data Definition; Query-By-Example (QBE). Database Analysis and Design: Database System Lifecycle; Database Analysis and the DreamHome Case Study; Entity--Relationship Modeling; Enhanced Entity--Relationship Modeling; Normalization; Advanced Normalization. Methodology: Methodology-Conceptual Database Design; Methodology-Logical Database Design for Relational Model; Methodology-Physical Database Design for Relational Databases; Methodology-Monitoring and Tuning the Operational System. Selected Database Issues: Security and Administration; Professional, Legal, and Ethical Issues; Transaction Management; Query Processing. Distributed DBMSs and Replication: Distributed DBMSs-Concepts and Design; Distributed DBMSs-Advanced Concepts; Replication and Mobile Databases. Object DBMSs: Object-Oriented DBMSs-Concepts and Design; Object-Oriented DBMSs-Standards and Languages; Object-Relational DBMSs. Web and DBMSs: Web Technology and DBMSs; Semistructured Data and XML. Business Intelligence Technologies: Data Warehousing Concepts; Data Warehousing Design; OLAP; Data Mining. Appendices: Users' Requirements Specification for DreamHome Case Study; Other Case Studies; Alternative Data Modeling Notations; Summary of the Database Design Methodology for Relational Databases; Introduction to Pyrrho-A Liteweight RDBMS. Web Appendices: File Organization and Storage Structures; When Is a DBMS Relational?; Commercial DBMSs: Access and Oracle; Programmatic SQL; Estimating Disk Space Requirements; Introduction to Object-Orientation; Example Web Scripts. MARKET: This book is ideal for readers interested in database management or database design., Database Systems is ideal for a one- or two-term course in database management or database design in an undergraduate or graduate level course. With its comprehensive coverage, this book can also be used as a reference for IT professionals. This best-selling text introduces the theory behind databases in a concise yet comprehensive manner, providing database design methodology that can be used by both technical and non-technical readers. The methodology for relational Database Management Systems is presented in simple, step-by-step instructions in conjunction with a realistic worked example using three explicit phases--conceptual, logical, and physical database design. ¿ Teaching and Learning Experience This program presents a better teaching and learning experience-for you and your students. It provides: Database Design Methodology that can be Used by Both Technical and Non-technical Readers A Comprehensive Introduction to the Theory behind Databases A Clear Presentation that Supports Learning, This book is ideal for a one- or two-term course in database management or database design in an undergraduate or graduate level course. With its comprehensive coverage, this book can also be used as a reference for IT professionals. This best-selling text introduces the theory behind databases in a concise yet comprehensive manner, providing database design methodology that can be used by both technical and non-technical readers. The methodology for relational Database Management Systems is presented in simple, step-by-step instructions in conjunction with a realistic worked example using three explicit phases--conceptual, logical, and physical database design. Teaching and Learning Experience This program presents a better teaching and learning experience-for you and your students. It provides: Database Design Methodology that can be Used by Both Technical and Non-technical Readers A Comprehensive Introduction to the Theory behind Databases A Clear Presentation that Supports Learning, Database Systems is ideal for a one- or two-term course in database management or database design in an undergraduate or graduate level course. With its comprehensive coverage, this book can also be used as a reference for IT professionals. This best-selling text introduces the theory behind databases in a concise yet comprehensive manner, providing database design methodology that can be used by both technical and non-technical readers. The methodology for relational Database Management Systems is presented in simple, step-by-step instructions in conjunction with a realistic worked example using three explicit phases--conceptual, logical, and physical database design. Teaching and Learning Experience This program presents a better teaching and learning experience-for you and your students. It provides: Database Design Methodology that can be Used by Both Technical and Non-technical Readers A Comprehensive Introduction to the Theory behind Databases A Clear Presentation that Supports Learning
LC Classification NumberQA76.9.D26C66 2014