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
Project Management JumpStart
Developing Project Management Skills
Initiating the Project
Defining the Project Goals
Executing the Project
Appendix C Sample Project Management Checklists
CISSP Exam Cram 2
Multiple-Choice Question Format
Building Defense in Depth
Access-Control Types
LANs and Their Components
Answers to Practice Exam Questions
Oracle Developer Forms Techniques
GUI Development
Obtaining Query Count Without EXECUTE-ing a Query
Tracking QUERY_ONLY Mode
Special Tips for Working with Multi-form Applications
Summary
Secure Programming Cookbook for C and C++: Recipes for Cryptography, Authentication, Input Validation & More
Getting the Minimum and Maximum Values for a Numeric Type
Working with Polar Coordinates
Passing an Argument to a Thread Function
Introduction
Writing an Operator That Isnt a Member Function
Cisco ASA: All-in-One Firewall, IPS, and VPN Adaptive Security Appliance
Sun RPC
Summary
Summary
Remote System Management
Cisco Remote-Access IPSec VPN Setup
802.11 Wireless Networks: The Definitive Guide, Second Edition
Common Features
Using 802.11 on Windows
Rogue Access Points
Planning Access-Point Placement
Network Analyzers
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