Data Models and Abstraction
1 Topics
Data Models and Architecture
10 Sub-topics
Three-Level Database Architecture - External, Conceptual, Internal
Data Independence - Physical and Logical
Schema vs Instance Concepts
Relational Data Model Introduction
Object-Oriented Data Model
Entity-Relationship Model Basics
Comparing Different Data Models
Relational Database (RDBMS) Concepts
1 Topics
Relational Model Fundamentals
15 Sub-topics
Introduction to Relational Model
Understanding Tables (Relations)
Rows (Tuples) and Records
Columns (Attributes) and Fields
Domain and Data Types Concept
Keys in Relational Databases - Overview
Primary Key Concept and Purpose
Foreign Key Concept and Relationships
Candidate Keys and Alternate Keys
Relational Constraints Overview
Entity Integrity Constraint
Referential Integrity Constraint
Relationships and Cardinality
1 Topics
Database Relationships
10 Sub-topics
Understanding Database Relationships
Many-to-Many Relationship
Cardinality in Relationships
Participation - Total and Partial
Weak Entities and Strong Entities