ER Diagram Examples | Database Management System

ER Diagram Examples | Database Management System

(1) The following ER-diagram illustrates a relationship “depositor” between “customer” and “account” entity. Note that both entities have attributes and also the “depositor” relationship has “access date” attribute (relationship attribute).

 

 

The primary key of customer is “customer-id” & “account-number” of account entity.

(2) ER Diagram for an institute

This example assumes that in an institute there are many course in which a student can enroll/register. Each Course has number of Subjects and those subjects are taught by faculty members.

 

(3) The following ER Diagram illustrates a Snapshot of an organization where many persons are working in different departments.