Week1 - Data Modeling, Entity Relationship Model / Assess

Entity Relationship Diagram Questions

1. Label the missing entities from the ER diagram of Banking system.

(Q0) Entity 1

(a) Customer

(Q1) Entity 2

(a) Employee

(Q2) Entity 3

(a) Branch

(Q3) Entity 4

(a) Loan

(Q4) Entity 5

(a) Account

(Q5) Entity 6

(a) Payment

2. Label the missing attributes of the given entities in ER diagram of College Management System.

(Q0) Attribute 1 for entity Student

(d) FirstName

(Q1) Attribute 2 for entity Student

(d) Address

(Q2) Attribute 1 for entity Admission

(d) Date_of_enrolment

(Q3) Attribute 2 for entity Admission

(d) CourseName

(Q4) Attribute for entity Timetable

(d) Date

(Q5) Attribute for entity Lecturer

(d) First Name

(Q6) Attribute for entity Subjects

(d) SubjectCode