8) Consider the following relational database conceptual schema used to keep track of patient visits in a medical clinic: Person (SSN, Name, DoB, Gender, PlaceOfBirth) Doctor (SSN, Specialty) Patient (SSN, InsurancelD, Insurance Provider, Medical RecordID) Medical Visit (Date. Doctor, Patient, Diagnosis) In the above, primary keys are underlined. The following referential integrity constraints exist: From Doctor. SSN to Person, SSN From Patient.SSN to Person SSN From Medical Visit.Doctor to Doctor, SSN From MedicalVisit.Patient to patient.SSN Answer the following questions based on the above schema. 8a) In the MedicalVisit table the primary key is defined as (Date, Doctor, Patient). If the primary key were to be changed to (Doctor, Patient), how would it affect the design and information in the database? (eg information structure in the database, normal form etc.) (10 Points) 8b) Please Draw an ER diagram based on the above original Relational Model (15 points)