Fundamentals of database systems (6th ed )

Clear explanations of theory and design, broad coverage of models and real systems, and an up-to-date introduction to modern database technologies result in a leading introduction to database systems. Intended for computer science majors, Fundamentals of Database Systems, 6/e emphasizes math models, design issues, relational algebra, and relational calculus.

A lab manual and problems give students opportunities to practice the fundamentals of design and implementation. Real-world examples serve as engaging, practical illustrations of database concepts. The Sixth Edition maintains its coverage of the most popular database topics, including SQL, security, and data mining, and features increased emphasis on XML and semi-structured data.

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 Constraints

Chapter 4: Basic SQL

Chapter 5: Advanced SQL

Chapter 6: Relational Algebra and Relational Calculus

Part 3 (Conceptual Modeling and Database Design):

Chapter 7: Data Modeling Using the Entity-Relationship (ER) Model

Chapter 8: The Enhanced Entity-Relationship (EER) Model

Chapter 9: Relational Database Design by ER- and EER-to-Relational Mapping

Chapter 10: Practical Database Design Methodology and Use of UML Diagrams

Part 4 (Object, Object-Relational, and XML Models):

Chapter 11: Object and Object-Relational Databases

Chapter 12: XML

Part 5 (Database Programming Techniques):

Chapter 13: Introduction to SQL Programming Techniques

Chapter 14: Web Database Programming

Part 6 (Database Normalization Theory):

Chapter 15: Basics of Functional Dependencies and Normalization

Chapter 16: Normalization Algorithms and Theory

Part 7 (File Structures, Indexing, and Hashing):

Chapter 17: Disk Storage, Basic File Structures, and Hash Files

Chapter 18: Indexing Structures for Files

Part 8 (Query Processing, Optimization, and Database Tuning):

Chapter 19: Query Processing Algorithms

Chapter 20: Introduction to Query Optimization Techniques

Chapter 21: Physical Database Design and Database Tuning

Part 9 (Transaction Processing, Concurrency Control, and Recovery):

Chapter 22: Transaction Processing Concepts

Chapter 23: Concurrency Control Protocols

Chapter 24: Database Recovery Techniques

Part 10 (Additional Database Topics):

Chapter 25: Database Security

Chapter 26: Distributed Databases and Client Server Architectures

Part 11 (Advanced Database Models, Systems, and Applications):

Chapter 27: Enhanced Data Models for Advanced Applications

Chapter 28: Keyword-Based Search and Information Retrieval

Chapter 29: Streaming Data Systems and Sensor Data Collection

Chapter 30: Database Mining Concepts

Chapter 31: Overview of Data Warehousing and OLAP

Chapter 32: Emerging Database Technologies and Applications

Appendix A - Alternative Diagrammatic Notations for ER Models
Appendix B - Parameters of Disks
Appendix C - Overview of QBE Language
Appendix D - Overview of the Hierarchical Data Model
Appendix E - Overview of the Network Data ModelAppendices D and E are available on the password-protected Companion Website. An access code for the Companion Website is included with each new textbook purchase of Fundamentals of Database Systems, 6/e