This assignment is about to draw and ER diagram for CQMC (CQ Specialist Medical Centre). Where patient book their appointments and all data related to the patients, doctors, appointments etc. stored...

This assignment is about to draw and ER diagram for CQMC (CQ Specialist Medical Centre). Where patient book their appointments and all data related to the patients, doctors, appointments etc. stored in the database. How data is fetch from database showing in following ER diagram and show 3NF about ER diagram.

2.    ER Diagram
an Entity relationship graph is a specific reasonable shape that depicts the associations between components in a database. ER plots consistently use pictures to address three sorts of information: components (or thoughts), associations and properties. In industry, standard ER graphs, boxes are used to address substances. Valuable stones are used to address associations, and ovals are used to address attributes.