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.
The Fifth Edition brings Web and legal issues to the fore in two new chapters, Database Architectures and the Web and Professional, Legal, and Ethical Issues. Students are exposed not only to the foundational theory of databases but also to the most recent developments in the field.
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 comprehensive coverage, this book can also be used as a reference for IT professionals.
-Database design methodology is explicitly divided into three phases based on the widely accepted Entity–Relationship model: conceptual, logical, and physical. Each phase is described in a separate chapter with an example of the methodology working in practice.
-A clear and easy-to-understand presentation supports student learning and retention: definitions are highlighted clearly, chapter objectives are stated succinctly, and chapters are summarized completely.
-Numerous examples and diagrams throughout each chapter illustrate the main concepts, and a realistic case study is integrated throughout the book.
-Extensive treatment of SQL in three tutorial style chapters, covering both interactive and embedded SQL.
-Extensive treatment of the Web as an emerging platform for database applications with many code samples for accessing databases from the Web including JDBC™, SQLJ, ASP, ISP, and Oracle® PSP.
|Introduction to Databases|
|Database Architectures and the Web|
|The Relational Model and Languages|
|The Relational model|
|Relational Algebra and Relational Calculus|
|SQL: Data Manipulation|
|SQL: Data Definition|
|Database Analysis and Design|
|Database System Lifecycle|
|Database Analysis and the DreamHome: Case Study|
|Enhanced Entity-Relationship Modeling|
|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|
|Distributed DBMSs and Replication|
|Distributed DBMSs-Concepts and Design|
|Distributed DBMSs-Advanced Concepts|
|Replication and Mobile Databases|
|Object-Oriented DBMSs-Concepts and Design|
|Object-Oriented DBMSs-Standards and Languages|
|Web and DBMSs|
|Web Technology and DBMSs|
|Semistructured Data and XML|
|Business Intelligence Technologies|
|Data Warehousing Concepts|
|Data Warehousing Design|
|Other Case Studies|
|Alternative Data Modeling Notations|
|Summary of the Database Design Methodology for Relational Databases|
|Introduction to Pyrrho-A Liteweight RDBMS|
|File Organization and Storage Structures|
|When Is a DBMS Relational?|
|Commercial DBMSs: Access and Oracle|
|Estimating Disk Space Requirements|
|Introduction to Object-Orientation|
|Example Web Scripts|
|Table of Contents provided by Publisher. All Rights Reserved.|