- SQL and Relational Theory
- Dedication
- Preface to the First Edition
- Preface to the Second Edition
- 1. Setting the Scene
- 2. Types and Domains
- 3. Tuples and Relations, Rows and Tables
- 4. No Duplicates, No Nulls
- 5. Base Relvars, Base Tables
- 6. SQL and Relational Algebra I: The Original Operators
- SOME PRELIMINARIES
- MORE ON CLOSURE
- RESTRICTION
- PROJECTION
- JOIN
- UNION, INTERSECTION, AND DIFFERENCE
- WHICH OPERATORS ARE PRIMITIVE?
- FORMULATING EXPRESSIONS ONE STEP AT A TIME
- WHAT DO RELATIONAL EXPRESSIONS MEAN?
- EVALUATING SQL TABLE EXPRESSIONS
- EXPRESSION TRANSFORMATION
- THE RELIANCE ON ATTRIBUTE NAMES
- EXERCISES
- 7. SQL and Relational Algebra II : Additional Operators
- 8. SQL and Constraints
- 9. SQL and Views
- 10. SQL and Logic
- 11. Using Logic to Formulate SQL Expressions
- SOME TRANSFORMATION LAWS
- EXAMPLE 1: LOGICAL IMPLICATION
- EXAMPLE 2: UNIVERSAL QUANTIFICATION
- EXAMPLE 3: IMPLICATION AND UNIVERSAL QUANTIFICATION
- EXAMPLE 4: CORRELATED SUBQUERIES
- EXAMPLE 5: NAMING SUBEXPRESSIONS
- EXAMPLE 6: MORE ON NAMING SUBEXPRESSIONS
- EXAMPLE 7: DEALING WITH AMBIGUITY
- EXAMPLE 8: USING COUNT
- EXAMPLE 9: JOIN QUERIES
- EXAMPLE 10: UNIQUE QUANTIFICATION
- EXAMPLE 11: ALL OR ANY COMPARISONS
- EXAMPLE 12: GROUP BY AND HAVING
- EXERCISES
- 12. Miscellaneous SQL Topics
- A. The Relational Model
- B. SQL Departures from the Relational Model
- C. A Relational Approach to Missing Information
- D. A Tutorial D Grammar
- E. Summary of Recommendations
- F. Answers to Exercises
- G. Suggestions for Further Reading
- Index
- About the Author
- Copyright
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.