Draw the ERM (Crows 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. 4. Show the cardinality.

A health clinic has many doctors. Each doctor is assigned a specific department. A department includes a minimum of 2 doctors. 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.

Notes:

Use a software tool to draw the model.