Lab Exercise

Given the matrix diagram below, construct ERD from it$.$ You are not required to define

attributes for the entities for this question. $[3$ marks$]$

Given the ERD below, write ERD statements. Note that there is dashed line on both sides

of the relationship between Photograph and Subject. However, the dashed line ends

with Camera only in the other relationship. $[2$ marks$]$

Read the given business scenario below. Name the relationship between ORDER and

WAITER, i$.$e$,$ write business rules $($ERD Statements$).$ Include the appropriate optionality

and cardinality. $[2$ marks$]$