Design an Entity Relationship (ER) Model to represent the above requirements

Design an ER diagram for the following Dental Clinic database. Your diagram should have all the needed details. You may make any reasonable assumptions but you have to state them clearly.

 

  1. Design an Entity Relationship (ER) Model to represent the above requirements.  (2 Marks)
  2. Convert the ER Diagram that presented in part-1 to Rational Schema. (2 Marks)