Database Systems: A Practical Approach to Design, Implementation and Management (5th Edition)

Database Systems: A Practical Approach to Design, Implementation and Management (5th Edition)

<b> </b> 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.<br> <b> <br> </b> <b>Background: </b>Introduction to Databases; Database Environment; Database Architectures and the Web. <b>The Relational Model and Languages: </b>The Relational model; Relational Algebra and Relational Calculus; SQL: Data Manipulation; SQL: Data Definition; Query-By-Example (QBE). <b>Database Analysis and Design: </b>Database System Lifecycle; Database Analysis and the <i>DreamHome</i> Case Study; Entity–Relationship Modeling; Enhanced Entity–Relationship Modeling; Normalization; Advanced Normalization. <b>Methodology: </b>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. <b>Selected Database Issues: </b>Security and Administration; Professional, Legal, and Ethical Issues; Transaction Management; Query Processing. <b>Distributed DBMSs and Replication: </b>Distributed DBMSs—Concepts and Design; Distributed DBMSs—Advanced Concepts; Replication and Mobile Databases. <b>Object DBMSs: </b>Object-Oriented DBMSs—Concepts and Design; Object-Oriented DBMSs—Standards and Languages; Object-Relational DBMSs. <b>Web and DBMSs: </b>Web Technology and DBMSs; Semistructured Data and XML. <b>Business Intelligence Technologies: </b>Data Warehousing Concepts; Data Warehousing Design; OLAP; Data Mining. <b>Appendices: </b>Users' Requirements Specification for <i>DreamHome</i> Case Study; Other Case Studies; Alternative Data Modeling Notations; Summary of the Database Design Methodology for Relational Databases; Introduction to Pyrrho—A Liteweight RDBMS. <b>Web Appendices: </b>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.<br> <b> <br> </b> This book is ideal for readers interested in database management or database design.