RDBMS COURSE CONTENTS
DATA MODELS
Database Management Systems
Data Models
Conceptual Model
Understanding Data Redundancy
DATA MODELS
Database Management Systems
Data Models
- Object-Base Logical Model
- Record-Based Logical Model
- Steps for Creating an ER Diagram.
- RESTRICT
- PROJECT
- PRODUCT
- UNION
- INTERSECT
- DIFFERENCE
- JOIN
- DIVIDE
Conceptual Model
- Mapping ER Diagrams to Table
- Attributes
- Keys
- Entities
- Subentities
Understanding Data Redundancy
- Definition of Normalization
- Definition of Denormalization