Unit 2: Relational Model (16 hrs.)
Entity Relationship Modeling: Introduction - Entity Types, Entity Sets, Attributes and Keys - Relationship Types, Relationship Sets, Roles, and Structural Constraints - Weak Entity Types - Notation for ER diagrams - Sample ER diagrams.
Relational Model Concepts: Domains, Attributes, Tuples, and Relations - Characteristics of Relations - Relational Model Constraints and Relational Database Schemas : Domain Constraints, Key Constraints, Relational Database Schemas, Entity Integrity, Referential Integrity, and Foreign Keys.
ER model is a high-level conceptual data model. The goal is to create a simple description of the data that closely matches how users and developers think of the data.
It is widely used to develop an initial design of a database.