Make the following from the data model design for the Garden glory questions.

Use this data model to complete the following tasks:

$-.$ Transform the data model to a physical model $($database design$).$ Note:

a$.$ Draw the entity$-$relationship diagram $($ERD$)$ in Crow's foot notation using MS Visio, you can only use the crow's foot database notation $($template$)$ in MS Visio.

b$.$ There must be no many$-$to$-$many relationships $($to place FKs appropriately$).$

c$.$ The ERD must include not only tables, foreign keys and relationships with cardinalities but also all columns and their data types $($do not use char type only; choose the appropriate data types for each column instead$)$ and also display data types in the Visio file.

d$.$ The names must be the same as provided in the data model; clearly label the primary keys and foreign keys.

e$.$ All foreign keys

are required, i$.$e$.,$ cannot be null. :