"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. 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. This book is ideal for readers interested in database management or database design.
"