- Data Analysis
- Relational Constraints
- DB Life Cycle
- Relational Notation
- Data Modeling
- Table Characteristics
- Table Column Rules
- Table Row Rules
- Columns Entity Attributes
- Calculate Domain Types
- RDBMS Calculations
- Database Null Values
- Key Column Descriptors
- Primary Key
- Surrogate Keys
- Concatenated Keys
- Primary Foreign Key
- Defining Foreign Keys
- Referential Integrity
- Relational Constructs Conclusion
- Normal Forms
- Reduce Data Redundancy
- Normalization Defined
- Normalization Objective
- Normalization Process - Quiz
- First Normal Form
- Achieving First Normal
- First NF Limitations
- Second Normal Form
- Define Functional Dependencies
- Identify Functional Dependencies
- Achieving 2nd Normal Form
- Second NF Limitations
- DB Normalization Conclusion
- Normalization - Quiz
- Third Normal Form
- 2NF Limitations
- Transitive Dependencies
- Eliminate Dependencies
- 1st, 2nd, 3rd NF
- Achieve 3rd Normal Form
- Codds Twelve Criteria
- (BCNF) Four Important Rules
- Beyond 3rd Normal Form
- Boyce Codd Normal Form
- Denormalizing Tables
- 3rd Normal Form
- Joins, User Views
- SQL Joining Tables
- SQL Inner Join
- Table Join Explanation
- Create Equi Join
- Business Requirements
- Store View Definitions
- Creating SQL Views
- Permissions Design Role
- Requirements Analysis
- Table Joins User Views
- Physical Design
- Physical DB Design
- Create index SQL
- Drawbacks Field Indexing
- Database Clustering
- Data Clustering Trade-off
- Database Partitioning
- Horizontal Partition
- Drawbacks Horizontal Partitioning
- DB Vertical Partitioning
- Drawbacks Vertical Partitioning
- Create DB via SQL
- Create Table via SQL
- Use SQL to Build DB
- Data Dictionary Entries
- Data Dictionary
- Physical Design Conclusion
- DB Design Mistakes
- Common Mistakes
- DB Design Considerations
- Business Objects Rules
- Database Column Mistakes
- Database Key Constraints
- Primary Foreign Key Mistakes
- Referential Integrity
- International DB Mistakes
- Eval Relational DB
- Design Mistakes Conclusion
Database Design Mistakes - Quiz
Each question is worth one point. Select the best answer or answers for each question.