Using Visio, redraw B&E Figure 5.10 with the crows foot notation. Make sure to include PKs, FKs, and key attributes. for the cardinalities, modalities, and the multivalued attribute, Dept (you do not need to include Employee as an entity). Crows foot notation has no defined symbol for weak entities. You need to express a weak entity with attributes (rather than with a double rectangle).

Justify each pair of cardinality & modality by providing formal written descriptions of those entity relationships.

Mall name address located_in dept Store manages Store Manager sloc sname snum sm_ssn sm_salary sm_name owns so_address so_ssn so_name Owner so_off_phone FIGURE 5.10 An ER diagram of West Florida Mall with four entities