Relational Theory for Computer Professionals

Relational Theory for Computer Professionals

by C.J. Date

Paperback(New Edition)

$37.07 $39.99 Save 7% Current price is $37.07, Original price is $39.99. You Save 7%.
View All Available Formats & Editions
Choose Expedited Shipping at checkout for guaranteed delivery by Thursday, March 28

Product Details

ISBN-13: 9781449369439
Publisher: O'Reilly Media, Incorporated
Publication date: 05/29/2013
Edition description: New Edition
Pages: 284
Product dimensions: 7.00(w) x 9.10(h) x 0.40(d)

About the Author

Chris Date has a stature in the database industry that’s unique. He enjoys a reputation that’s second to none for his ability to explain complex technical issues in a clear and understandable fashion. His previous books for O’Reilly include SQL and Relational Theory (2nd edition); Database Design and Relational Theory; and View Updating and Relational Theory. The present book serves as an introduction to those previous ones.

Table of Contents

;
;
About the Author;
Preface;
Who Should Read This Book;
Structure of the Book;
Acknowledgments;
Foundations;
Chapter 1: Basic Database Concepts;
1.1 What’s a database?;
1.2 What’s a DBMS?;
1.3 What’s a relational DBMS?;
1.4 Database systems vs. programming systems;
1.5 Exercises;
1.6 Answers;
Chapter 2: Relations and Relvars;
2.1 Relations;
2.2 Relvars;
2.3 Exercises;
2.4 Answers;
Chapter 3: Keys, Foreign Keys, and Related Matters;
3.1 Integrity constraints;
3.2 Keys;
3.3 Foreign keys;
3.4 Relvar definitions;
3.5 Loading the database;
3.6 Database systems vs. programming systems bis;
3.7 Exercises;
3.8 Answers;
Chapter 4: Relational Operators I;
4.1 Codd’s original algebra;
4.2 Restrict;
4.3 Project;
4.4 Exercises I;
4.5 Answers I;
4.6 Union, intersection, and difference;
4.7 Rename;
4.8 Exercises II;
4.9 Answers II;
4.10 Join;
4.11 Relational comparisons;
4.12 Update operator expansions;
4.13 Exercises III;
4.14 Answers III;
Chapter 5: Relational Operators II;
5.1 MATCHING and NOT MATCHING;
5.2 EXTEND;
5.3 Image relations;
5.4 Aggregation and summarization;
5.5 Exercises;
5.6 Answers;
Chapter 6: Constraints and Predicates;
6.1 Database constraints;
6.2 Relvar predicates;
6.3 Predicates vs. constraints;
6.4 Exercises;
6.5 Answers;
Chapter 7: The Relational Model;
7.1 The relational model defined;
7.2 Types;
7.3 The RELATION type generator;
7.4 Relation variables;
7.5 Relational assignment;
7.6 Relational operators;
7.7 Concluding remarks;
Transactions and Database Design;
Chapter 8: Transactions;
8.1 What’s a transaction?;
8.2 Recovery;
8.3 Concurrency;
8.4 Locking;
8.5 A remark on SQL;
8.6 Exercises;
8.7 Answers;
Chapter 9: Database Design;
9.1 Nonloss decomposition;
9.2 Functional dependencies;
9.3 Second normal form;
9.4 Third normal form;
9.5 Boyce/Codd normal form;
9.6 Concluding remarks;
9.7 Exercises;
9.8 Answers;
SQL;
Chapter 10: SQL Tables;
10.1 A little history;
10.2 Basic concepts;
10.3 Properties of tables;
10.4 Table updates;
10.5 Equality comparisons;
10.6 Table definitions;
10.7 SQL systems vs. programming systems;
10.8 Exercises;
10.9 Answers;
Chapter 11: SQL Operators I;
11.1 Restrict;
11.2 Project;
11.3 Union, intersection, and difference;
11.4 Rename;
11.5 Exercises I;
11.6 Answers I;
11.7 Join;
11.8 Evaluating table expressions;
11.9 Table comparisons;
11.10 Displaying results;
11.11 Exercises II;
11.12 Answers II;
Chapter 12: SQL Operators II;
12.1 MATCHING and NOT MATCHING;
12.2 EXTEND;
12.3 Image relations;
12.4 Aggregation and summarization;
12.5 Exercises;
12.6 Answers;
Chapter 13: SQL Constraints;
13.1 Database constraints;
13.2 Type constraints;
13.3 Exercises;
13.4 Answers;
Chapter 14: SQL vs. the Relational Model;
14.1 Some generalities;
14.2 Some SQL departures from the relational model;
14.3 Exercises;
14.4 Answers;
Appendixes;
A Tutorial D Grammar;
Expressions;
Assignments;
TABLE_DUM and TABLE_DEE;
Set Theory;
What’s a set?;
Subsets and supersets;
Set operators;
Some identities;
The algebra of sets;
Cartesian product;
Concluding remarks;
Relational Calculus;
Sample queries;
Sample constraints;
A simplified grammar;
Exercises;
Answers;
A Guide to Further Reading;
Papers by E. F. Codd;
Books by C. J. Date;
Books by C. J. Date and Hugh Darwen;
Other Publications Related to SQL;
Miscellaneous;

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews