---

Database in Depth: Relational Theory for Practitioners

ISBN: 0596100124
EAN: 2147483647

Year: 2006
Pages: 127

Authors: C.J. Date

BUY ON AMAZON

• Database in Depth
• Database in Depth
• Dedicated to the memory of E.F.Codd
• Copyright
• Foreword
• What Makes This Book Different?
• Further Preliminaries
• Conventions Used in This Book
• Using Code Examples
• Safari Enabled
• Comments and Questions
• Acknowledgments
• Chapter One. Introduction
• A Remark on Terminology
• Principles, Not Products
• A Review of the Original Model
• Model Versus Implementation
• Properties of Relations
• Relations Versus Relvars
• Values Versus Variables
• Summary
• Exercises
• Chapter Two. Relations Versus Types
• Domain-Constrained Comparisons
• Data Value Atomicity
• So What s a Type?
• Scalar Versus Nonscalar Types
• Summary
• Exercises
• Chapter Three. Tuples and Relations
• What s a Tuple?
• Some Important Consequences
• What s a Relation?
• Further Important Consequences
• Why Duplicate Tuples Are Prohibited
• Why Nulls Are Prohibited
• TABLE_DUM and TABLE_DEE
• Summary
• Exercises
• Chapter Four. Relation Variables
• Updating Is Set-at-a-Time
• More on Candidate Keys
• More on Foreign Keys
• More on Views
• Relvars and Predicates
• More on Relations Versus Types
• Summary
• Exercises
• Chapter Five. Relational Algebra
• More on Closure
• The Original Operators
• Evaluating SQL Expressions
• Extend and Summarize
• Group and Ungroup
• Expression Transformation
• Relational Comparisons
• More on Relational Assignment
• The ORDER BY Operator
• Summary
• Exercises
• Chapter Six. Integrity Constraints
• Type Constraints
• Database Constraints
• Transactions
• Why Database Constraint Checking Must Be Immediate
• But Doesn t Some Checking Have to Be Deferred?
• Constraints and Predicates
• Miscellaneous Issues
• Summary
• Exercises
• Chapter Seven. Database Design Theory
• The Place of Design Theory
• Functional Dependencies and BoyceCodd Normal Form
• Join Dependencies and Fifth Normal Form
• Two Cheers for Normalization
• Orthogonality
• Some Remarks on Physical Design
• Summary
• Exercises
• Chapter Eight. What Is the Relational Model?
• The Relational Model Defined
• Objectives of the Relational Model
• Some Database Principles
• The Relational Model Versus Others
• What Remains to Be Done?
• Summary
• Exercises
• Appendix A. A Little Bit of Logic
• Propositions
• Predicates
• Quantification
• Free and Bound Variables
• More on Quantification
• Database Constraints
• Queries
• Some Equivalences
• Summary
• Appendix. Suggestions for Further Reading
• Colophon
• ABOUT THE AUTHOR
• COLOPHON
• Index
• index_SYMBOL
• index_A
• index_B
• index_C
• index_D
• index_E
• index_F
• index_G
• index_H
• index_I
• index_J
• index_K
• index_L
• index_M
• index_N
• index_O
• index_P
• index_Q
• index_R
• index_S
• index_T
• index_U
• index_V
• index_W
• index_X