QUESTION $1$

Both ER Model and Chen's ERD notation type were developed by Peter Chen in $1976.$

True

False

$10$ points

QUESTION $2$

Steps of designing database using ER Model and ERD:

$-$

Check the ERD against Business Rule and Requirements again, and repeat all the steps several rounds to make sure if any new information can be figured from Business rule so the ERD needs to be revised, until everything is confirmed.

$-$

Identify entity sets, attributes, relationships set between entity sets, primary key.

$-$

Analyze Business Rule and Requirements $($From your clients or From your group discussions for team project$).$

$-$

Drawing in the ERD the proper relationship type $($Binary or Ternary or N$-$ary or Recursive or $...)$

$-$

Drawing an ERD with entity sets, attributes, primary key.

$10$ points

QUESTION $3$

Which statements below is$/$are correct?

ER Model is a high$-$level data model.

ERD is a graphical representation of the component defined in ER Model.

ER Model helps to describe and model how to organize data, and ERD provide a way to visualize the design of certain organization of data.

$"$ER Model" is short for "Entity$-$Relationship Model".

"ERD" is short for "Entity$-$Relationship Diagram".

$10$ points

QUESTION $4$

Consider this ERD in Chen's notation type below:

There are $3$ Ternary relationship set.

There are $3$ Entity Sets.

There are $3$ Binary relationship set.

There are $2$ Ternary relationship set.

There are $2$ Entity Sets.

There is a descriptive attribute in this ERD.

No customer has same customer No$.$

There are $2$ Binary relationship set.