$$ For the Logical IE ERD Include...

$$ Primary Key column$($s$)$

$$ Foreign Key column$($s$)$ marked as $($FK$)$

$$ Cardinality, ID$/$non$-$ID$,$ Optional$/$Mandatory

$$ Name the relationship

$$ For Physical tables Include...

$$ Primary Key column $($underline$)$

$$ Foreign Key column$($s$)$ marked as $($FK$)$

$$ Mark them also as$....$

$$ UNIQUE $($U$)$ or Not Unique $($NU$)$

$$ NULL $($N$)$ or NOT NULL $($NN$)$

$$ Identify the column$($s$)$ the FKs refer to$.($Either write a FK referential constraint, or just make an arrow$)$

$$ Add some example data which demonstrates the cardinalities.

FIRST PICTURE IS A SAMPLE ANSWER

Conceptual Chen ERD

Business Rule: Each member must have a locker.

Logical IE ERD $($in relational database model$)$

Physical Tables $($in relational database model$)$

MEMBERS.L$\_$ID references LOCKERS.L$\_$ID

Conceptual Chen ERD

Business Rule: An employee must belong to a department

Logical IE ERD $($in relational database model$)$

Physical Tables $($in relational database model$)$

Conceptual Chen ERD

Business Rule: None.

Logical IE ERD $($in relational database model$)$

Physical Tables $($in relational database model$)$

Logical IE ERD $($in relational database model$)$

Physical Tables $($in relational database model$)$