Database Management Systems

  1. Database Design
    1. Database Design Process
      1. Requirements Analysis
        1. Stakeholder Identification
          1. Requirements Gathering Techniques
            1. Use Case Analysis
              1. Functional Requirements
                1. Non-Functional Requirements
                2. Conceptual Design
                  1. ER Model Creation
                    1. Entity Identification
                      1. Relationship Identification
                        1. Attribute Assignment
                        2. Logical Design
                          1. ER-to-Relational Mapping
                            1. Schema Refinement
                              1. Normalization
                              2. Physical Design
                                1. Storage Structure Design
                                  1. Index Design
                                    1. Performance Optimization
                                  2. Entity-Relationship Modeling
                                    1. Basic ER Concepts
                                      1. Entities and Entity Sets
                                        1. Entity Types
                                          1. Entity Instances
                                          2. Attributes
                                            1. Simple Attributes
                                              1. Composite Attributes
                                                1. Single-Valued Attributes
                                                  1. Multi-Valued Attributes
                                                    1. Derived Attributes
                                                      1. Key Attributes
                                                      2. Relationships
                                                        1. Relationship Types
                                                          1. Relationship Instances
                                                            1. Relationship Attributes
                                                            2. Relationship Characteristics
                                                              1. Degree of Relationships
                                                                1. Unary Relationships
                                                                  1. Binary Relationships
                                                                    1. Ternary Relationships
                                                                      1. N-ary Relationships
                                                                      2. Cardinality Ratios
                                                                        1. One-to-One
                                                                          1. One-to-Many
                                                                            1. Many-to-One
                                                                              1. Many-to-Many
                                                                              2. Participation Constraints
                                                                                1. Total Participation
                                                                                  1. Partial Participation
                                                                                2. Advanced ER Concepts
                                                                                  1. Weak Entity Sets
                                                                                    1. Identifying Relationships
                                                                                      1. Partial Keys
                                                                                      2. Enhanced ER Model
                                                                                        1. Specialization
                                                                                          1. Generalization
                                                                                            1. Aggregation
                                                                                              1. Inheritance
                                                                                                1. Constraints on Specialization
                                                                                            2. ER-to-Relational Mapping
                                                                                              1. Mapping Strong Entities
                                                                                                1. Mapping Weak Entities
                                                                                                  1. Mapping Binary Relationships
                                                                                                    1. One-to-One Relationships
                                                                                                      1. One-to-Many Relationships
                                                                                                        1. Many-to-Many Relationships
                                                                                                        2. Mapping Multi-Valued Attributes
                                                                                                          1. Mapping Composite Attributes
                                                                                                            1. Mapping Specialization and Generalization
                                                                                                            2. Functional Dependencies and Normalization
                                                                                                              1. Functional Dependencies
                                                                                                                1. Definition and Notation
                                                                                                                  1. Trivial and Non-Trivial Dependencies
                                                                                                                    1. Full Functional Dependency
                                                                                                                      1. Partial Functional Dependency
                                                                                                                        1. Transitive Functional Dependency
                                                                                                                        2. Inference Rules
                                                                                                                          1. Armstrong's Axioms
                                                                                                                            1. Reflexivity Rule
                                                                                                                              1. Augmentation Rule
                                                                                                                                1. Transitivity Rule
                                                                                                                                2. Additional Rules
                                                                                                                                  1. Union Rule
                                                                                                                                    1. Decomposition Rule
                                                                                                                                      1. Pseudotransitivity Rule
                                                                                                                                    2. Closure of Functional Dependencies
                                                                                                                                      1. Canonical Cover
                                                                                                                                        1. Database Anomalies
                                                                                                                                          1. Insertion Anomaly
                                                                                                                                            1. Deletion Anomaly
                                                                                                                                              1. Update Anomaly
                                                                                                                                              2. Normal Forms
                                                                                                                                                1. First Normal Form
                                                                                                                                                  1. Atomic Values
                                                                                                                                                    1. Elimination of Repeating Groups
                                                                                                                                                    2. Second Normal Form
                                                                                                                                                      1. Full Functional Dependency
                                                                                                                                                        1. Elimination of Partial Dependencies
                                                                                                                                                        2. Third Normal Form
                                                                                                                                                          1. Elimination of Transitive Dependencies
                                                                                                                                                          2. Boyce-Codd Normal Form
                                                                                                                                                            1. Stronger Key Constraints
                                                                                                                                                            2. Higher Normal Forms
                                                                                                                                                              1. Fourth Normal Form
                                                                                                                                                                1. Fifth Normal Form
                                                                                                                                                                  1. Domain-Key Normal Form
                                                                                                                                                                2. Normalization Process
                                                                                                                                                                  1. Denormalization Considerations

                                                                                                                                                                Previous

                                                                                                                                                                3. The Relational Model

                                                                                                                                                                Go to top

                                                                                                                                                                Next

                                                                                                                                                                5. SQL (Structured Query Language)