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
Beginners Guide to DarkBASIC Game Programming (Premier Press Game Development)
Introduction to Computer Programming
Looping Commands
More Power to the Numbers Data Sequences and Arrays
The Art of Using Animated Sprites for 2D Games
Appendix A Answers to the Chapter Quizzes
101 Microsoft Visual Basic .NET Applications
Working with Microsoft Visual Studio .NET 2003 and Microsoft .NET Framework 1.1
Building Windows Forms User Interfaces
Building Web Applications
Working with Console Applications
Working with the .NET Framework
Service-Oriented Architecture (SOA): Concepts, Technology, and Design
Objectives of this book
Part I: SOA and Web Services Fundamentals
Services (as Web services)
Service-orientation and object-orientation (Part II)
Service-Oriented Design (Part III: Service Design)
Twisted Network Programming Essentials
Accepting Connections from Clients
Managing a Hierarchy of Resources
Representing Users with Different Capabilities
Mail Clients
Downloading Mail from a POP3 Server
User Interfaces in C#: Windows Forms and Custom Controls
Designing with Classes and Tiers
Forms
Data Controls
Dynamic User Interface
GDI+ Controls
Digital Character Animation 3 (No. 3)
Refining Rigs
Animating Walks
Animating the Face
Conclusion
Four-Legged Mammals
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