[Q.4] Answer the following questions
You are invited as a database architect to develop databaseschema for maintaining patient information for the NYU medicalgroup (make necessary assumptions for the data requirements ifneeded).
Each physician in the Lehman medical group is uniquelyidentified by physicianID o Each physician must have first name,and last name, and phone number
Each patient is identified by patientID
o Each patient must have first name, and last name, phone number,and insurance card number (if the patient has)
Each patient gets a treatment from a physician.
o Each treatment is identified by a unique treatementCode
o Each treatment is described by a simple description
Patients, Physicians, and Treatments are associated by apatientTreatement relationship type. The relationship type has twoattributes to record date and time of the patient visit and patientco-payment (or minimum payment if the patient does not have medicalinsurance)
(a) Design a conceptual schema using ER diagram for storing andmanaging the data as explained above.
(b) Derive the logical database schema from the conceptualschema you designed.
