I need to design an ER diagram for a centralized healthcare management system for my college mini-project.
Firstly, I came up with the following ER diagram.
While designing the tables in the database, I found the patient table to be redundant as every person is a patient in our case so, I came up with the following ER-diagram.
Now, I am confused about which ER diagram shall I use for the project. Can you please me with the ER diagram? Thanks in advance.