Description

A Comprehensive Solution Manual for Fundamentals of Database Systems, 6/E By Ramez Elmasri, Shamkant Navathe, ISBN-10: 0136086209 ISBN-13: 9780136086208

Part 1: Introduction to Databases
Chapter 1 Databases and Database Users
Chapter 2 Database System Concepts and Architecture

Part 2: Relational Data Model and SQL
Chapter 3 The Relational Data Model and Relational Database Constraints
Chapter 4 Basic SQL
Chapter 5 More SQL: Complex Queries, Triggers, Views, and Schema Modification
Chapter6 The Relational Algebra and Relational Calculus

Part 3: Conceptual Modeling and Database Design
Chapter 7 Data Modeling Using the Entity-Relationship (ER) Model
Chapter8 The Enhanced Entity-Relationship (EER) Model
Chapter 9 Relational Database Design by ERand EER-to-Relational Mapping
Chapter 10 Practical Database Design Methodology and Use of UML Diagrams

Part 4: Object, Object-Relational, and XML Models
Chapter11 Object and Object-Relational Databases
Chapter12 XML: Extensible Markup Language

Part 5: Database Programming Techniques
Chapter13 Introduction to SQL Programming Techniques
Chapter14 Web Database Programming Using PHP

Part 6: Database Normalization Theory
Chapter15 Basics of Functional Dependencies and Normalization for Relational Databases
Chapter16 Relational Database Design Algorithms and Further Dependencies

Part 7: File Structures, Indexing, and Hashing
Chapter17 Disk Storage, Basic File Structures, and Hashing
Chapter18 Indexing Structures for Files

Part 8: Query Processing, Optimization, and Database Tuning
Chapter 19 Algorithms for Query Processing and Optimization
Chapter20 Physical Database Design and Tuning

Part 9: Transaction Processing, Concurrency Control, and Recovery
Chapter 21 Introduction to Transaction Processing Concepts and Theory
Chapter 22 Concurrency Control Techniques
Chapter 23 Database Recovery Techniques

Part 10: Additional Database Topics: Security and Distribution
Chapter24 Database Security
Chapter25 Distributed Databases

Part 11: Advanced Database Models, Systems, and Applications
Chapter26 Enhanced Data Models for Advanced Applications
Chapter 27 Introduction to Information Retrieval and Web Search
Chapter 28 Data Mining Concepts
Chapter29 Overview of Data Warehousing and OLAP