An Introduction to Relational Database Theory
Publisher: Bookboon.com
Published: 2013
ISBN-13: 9788740307771
Table of contents: title: Obsah; title: Introduction; title: Introduction; title: What Is a Database?; title: “Organized Collection of Symbols”; title: “To Be Interpreted as a True Account”; title: “Collection of Variables”; title: What Is a Relational Database?; title: “Relation” Not Equal to “Table”; title: Anatomy of a Relation; title: What Is a DBMS?; title: What Is a Database Language?; title: What Does a DBMS Do?; title: Creating and Destroying Variables; title: Taking Note of Integrity Rules; title: Taking Note of Authorisations; title: Updating Variables; title: Providing Results of Queries; title: Values, Types, Variables, Operators; title: Introduction; title: Anatomy of A Command; title: Important Distinctions; title: A Closer Look at a Read-Only Operator (+); title: Read-only Operators in Tutorial D; title: What Is a Type?; title: What Is a Type Used For?; title: The Type of a Relation; title: Relation Literals; title: Types and Representations; title: What Is a Variable?; title: Updating a Variable; title: Conclusion; title: Predicates and Propositions; title: Introduction; title: What Is a Predicate?; title: Substitution and Instantiation; title: How a Relation Represents an Extension; title: Deriving Predicates from Predicates; title: Relational Algebra—The Foundation; title: Introduction; title: Relations and Predicates; title: Relational Operators and Logical Operators; title: JOIN and AND; title: RENAME; title: Projection and Existential Quantification; title: Restriction and AND; title: Extension and AND; title: UNION and OR; title: Semidifference and NOT; title: Concluding Remarks; title: Building on The Foundation; title: Introduction; title: Semijoin and Composition; title: Aggregate Operators; title: Relations within a Relation; title: Using Aggregate Operators with Nested Relations; title: SUMMARIZE; title: GROUP and UNGROUP; title: WRAP and UNWRAP; title: Relation Comparison; title: Other Operators on Relations and Tuples; title: Constraints and Updating; title: Introduction; title: A Closer Look at Constraints and Consistency; title: Expressing Constraint Conditions; title: Useful Shorthands for Expressing Constraints; title: Updating Relvars; title: Database Design I: Projection-Join Normalization; title: Introduction; title: Avoiding Redundancy; title: Join Dependencies; title: Fifth Normal Form; title: Functional Dependencies; title: Keys; title: The Role of FDs and Keys in Optimization; title: Boyce-Codd Normal Form (BCNF); title: JDs Not Arising from FDs; title: Database Design II: Other Issues; title: Group-Ungroup and Wrap-Unwrap Normalization; title: Restriction-Union Normalization; title: Surrogate Keys; title: Representing “Entity Subtypes”