$3.$ Use the corrected E$-$R diagram to transform the data model into a database design

model. Use Microsoft Visio and Crows foot method to design your diagrams. In your

database design diagram, each entity class box should contain properties information for

each of the columns including PK$,$ AK$,$ and FK for the entity. You may use the steps

below for transforming data E$-$R model to database design model. $(45$ points$)$

$4.$ Write final schemas for your database design. $(20$ points$)$

Deliverables: Submit one PDF file on CANVAS with the followings:

$-$ Revised case details

$-$ Revised E$-$R diagram

$-$ Database design diagram