Week1 - Data Modeling, Entity Relationship Model / Assess

The questions can come in any order, so make sure you are selecting right option for all 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