Entity Relationship Model in DBMS for database design

Entity-relationship model, Database design with ER model, Define ER model, Explain ER modelling, Examples for designing databases using ER modelling, ER model concepts, ER model exercises

Entity-Relationship model

• Introduction

• Entities and Entity Sets

• Strong Entity Set

• Weak Entity Set

• Relationship sets

• Attributes

• Diagrammatic notation for ER model

• Participation constraint - Total participation

• participation constraint - Partial participation

• Reduction (conversion) of ER diagram into relation schema (table)

• Extended ER model

• Strengths (advantages/merits) of ER modelling

• Weaknesses (disadvantages/demerits) of ER modelling

• ER modelling examples

Exercises/Quizzes/Question and Answers

• ER modelling exercises (solved examples)
  

• ER model - Quiz 1

• ER model - Quiz 2

********

Go to Advanced Database Concepts page