create a medical database. We need to keep information about doctors, patients,

insurance, and doctors 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 relationship