- 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
C.1 Give SQL versions of constraints EQD2 and EQD3 from the section CONSTRAINTS in the body of the appendix.
C.2 Give an SQL version of the Tutorial D expression near the end of the section Queries in the body of the appendix.
C.3 Why would it be incorrect to specify CORRESPONDING on the EXCEPT in the final portion of the SQL expression at the end of the section immediately preceding these exercises?
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.