(Solved): Part I: Draw an ER diagram for the following medical database. Make sure you show the participation ...

Part I: Draw an ER diagram for the following medical database. Make sure you show the participation ratios (partial or single lines), the cardinality of each relationship (by showing the 1 or the \( \mathrm{N} \) ), and the (min, max) ratios for as many relationships as you have information for. And, if you have to assume something, please state what you are assuming. Here is the write-up of the medical database. We will create a medical database. We need to keep information about doctors, patients, insurance, and doctor's dependents. A doctor may see a patient and can see up to many patients. A patient must be seen by a doctor and can only be seen by up to 2 doctors. A doctor may have several dependents. A patient may have insurance, and insurance has to belong to a patient. For every doctor we will keep his/her area of specialization, name, ssn, address, phone. The ssn will be used to uniquely identify the doctor. The name can also be used to uniquely identify the doctor. For every patient we will keep: name, ssn, address, phone, age, sex. And, the ssn will be used to uniquely identify the patient. For every insurance we will keep the name of the insurance, insurance_id, insurance_coverage; and, the insurance_id will be used to uniquely identify the type of insurance. The insurance premium will be based on the patient as well as the insurance. Part II: Map the above ER diagram to a relational database. Make sure you show the primary keys and map all the relationships.