Draw the Entity Relationship diagram $($Crow$$s Foot Model$)$ for the following situation. Guidelines to follow when you are drawing the diagram:

$1.$ Show the connectivity.

$2.$ Identify the primary key and the foreign key.

$3.$ Add at least two attributes to each class, in addition to the primary key$/$foreign key.

$4.$ Show the cardinality.

A hospital has many doctors. Each doctor is assigned a specific department. A department includes a minimum of $2$ doctors. Each doctor has one specialization. Each patient can schedule one or more appointments. A doctor can have between $12$ and $15$ appointments. A doctor writes many prescriptions. A patient can have one or more prescriptions. A prescription has at least one drug. Each drug belongs to one drug category. Use software to draw this model