Entity Relationship Model

Video Lessons & Revision Notes

Entity Relationship Model - Basic Concepts
Entity Relationship Model - Basic Concepts
1. Entity Relationship Model - Basic Concepts
In this 33 mins Video Lesson
Introduction, Entity, Entity Set, Entity Type, Attributes, Null Values, Relationships, and other topics.
Concept of Keys, Strong/Week Entity Sets and Relationship Constraints
Concept of Keys, Strong/Week Entity Sets and Relationship Constraints
2. Concept of Keys, Strong/Week Entity Sets and Relationship Constraints
In this 38 mins Video Lesson
Super keys, Candidiate Keys, Primary Keys, Weak Entity Set, Partial Key / Discriminator, Constraints On Relationships, and other topics.
Converting ER Diagram to Tables
Converting ER Diagram to Tables
3. Converting ER Diagram to Tables
In this 27 mins Video Lesson
ER Notations, ER Model to Tables, Strong Entity Set (Including Multivalued and Composite Attr.), Weak Entity Set, Relationship Set, and other topics.
Extended ER Model - Specialization, Generalization, Hierarchies, Lattices
Extended ER Model - Specialization, Generalization, Hierarchies, Lattices
4. Extended ER Model - Specialization, Generalization, Hierarchies, Lattices
In this 33 mins Video Lesson
Introduction, Specialization, Generalization, Constraints on Specialization, Hierarchies and Lattice, Categories and Unions, and other topics.
Extended ER Model - Aggregation and Conversion to Tables
Extended ER Model - Aggregation and Conversion to Tables
5. Extended ER Model - Aggregation and Conversion to Tables
In this 18 mins Video Lesson
Aggregation, EER Model to tables, Specialization, Category to tables, and other topics.

Revision Notes

Basic Concepts, entity, attributes, relationships, constraints, keys, ER and EER diagrams: Components of ER Model, conventions, converting ER diagram into tables, EER Model components, converting EER diagram into tables

Member's Zone