1. Construct an E-R diagram for a database that allows a hospital to associate a set of patients and a set of medical doctors. A patient may have more than one doctor, and a doctor may treat many patients. Also, associate each patient with a record of the various procedures (tests, surgeries, and examinations) conducted while they are staying in the hospital. You can draw it by hand (neatly) and scan and upload the drawing to canvas, or use powerpoint or microsoft word shapes to draw it (preferred).

2. Implement the E-R diagram for the hospital in Question 1 to database schema in the 3rd normal form. Show the tables that you created, and indicate primary keys for each table. List any necessary constraints. Include the following example data in your tables: 3 doctors treating 4 patients (one doctor treats two patients, and one of the patients is seen by 2 doctors). Two of the patients have 1 procedure while staying in the hospital, and two other patients have more than one procedure while staying in the hospital.

need answer for 2nd question