Database Management Systems

  1. The Relational Model
    1. Fundamental Concepts
      1. Relation Structure
        1. Definition of Relation
          1. Relation Schema
            1. Relation Instance
            2. Basic Terminology
              1. Attribute
                1. Tuple
                  1. Domain
                    1. Degree
                      1. Cardinality
                      2. Relational Database Schema
                        1. Mathematical Foundation
                        2. Integrity Constraints
                          1. Domain Constraints
                            1. Data Type Constraints
                              1. Value Range Constraints
                              2. Key Constraints
                                1. Superkey
                                  1. Candidate Key
                                    1. Primary Key
                                      1. Alternate Key
                                        1. Foreign Key
                                        2. Entity Integrity Constraint
                                          1. Referential Integrity Constraint
                                            1. User-Defined Constraints
                                            2. Relational Algebra
                                              1. Fundamental Operations
                                                1. Selection Operation
                                                  1. Projection Operation
                                                    1. Union Operation
                                                      1. Set Difference Operation
                                                        1. Cartesian Product Operation
                                                          1. Rename Operation
                                                          2. Derived Operations
                                                            1. Join Operations
                                                              1. Theta Join
                                                                1. Equi Join
                                                                  1. Natural Join
                                                                    1. Outer Joins
                                                                    2. Intersection Operation
                                                                      1. Division Operation
                                                                      2. Query Optimization Using Algebra
                                                                      3. Relational Calculus
                                                                        1. Tuple Relational Calculus
                                                                          1. Syntax and Semantics
                                                                            1. Tuple Variables
                                                                              1. Formula Construction
                                                                                1. Safety of Expressions
                                                                                2. Domain Relational Calculus
                                                                                  1. Syntax and Semantics
                                                                                    1. Domain Variables
                                                                                      1. Formula Construction
                                                                                        1. Safety of Expressions
                                                                                        2. Equivalence of Algebra and Calculus

                                                                                      Previous

                                                                                      2. Data Models

                                                                                      Go to top

                                                                                      Next

                                                                                      4. Database Design