Assignment task: In this project is to design a patient electronic medical record database to support physicians in your medical office to track patients. The database should be able to provide physician information including doctor's ID, name, and contact information; patient information such as patient ID, name, address, phone, date of birth, insurance, and their diseases; you also need to collect the disease information including disease ID, disease name, symptoms, etc. You may add additional information that you think necessary or reasonable. If the database is well designed and implemented, it can be used to generate useful queries, such as displaying all patients with selected doctor, and finding out which disease has the highest occurrence, etc. In addition, your database should also allow you to create various database reports. For example, you may create a list of patients grouped by diseases for each primary care physician.
Design ER diagram without any many to many relationship