Flylib.com
Database in Depth: Relational Theory for Practitioners
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
Database in Depth: Relational Theory for Practitioners
ISBN: 0596100124
EAN: 2147483647
Year: 2006
Pages: 127
Authors:
C.J. Date
BUY ON AMAZON
Adobe After Effects 7.0 Studio Techniques
Conclusion
Optimizing Tracking Using 3D
Tracking for Rotoscoping
Looping Animations
Heat Distortion
Visual C# 2005 How to Program (2nd Edition)
Logical Operators
Default and Parameterless Constructors
Self-Review Exercises
Regular Expressions and Class Regex
Summary
Cisco Voice Gateways and Gatekeepers
Circuit Options
Digital Trunks
Dial Peers
Verifying and Troubleshooting MGCP Gateway Fallback
Configuring Directory Gatekeepers
An Introduction to Design Patterns in C++ with Qt 4
C++ Simple Types
Implicitly Shared Classes
Review Questions
Introduction to MySQL
Inheritance in Detail
Twisted Network Programming Essentials
Installing from Source Files
Adding Twisted Utilities to Your Path
Uploading a File
Calling XML-RPC Functions
Providing IMAP Access to Mailboxes
PMP Practice Questions Exam Cram 2
Project PlanningFacilitating Processes
Answers and Explanations
Exam Prep Questions
Project Control
Answers and Explanations
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies