8) Consider the following relational database conceptual schema used to keep track of patient visits in a medical clinic: Person (SSN, Name, DoB, Gender, PlaceQfRirth) Doctor (SSN, Specialty) Patient (SSN, InsurancelD, InsuranceProvider, MedicalRecordlD) MedicalVisit (Date. Doctor, Patient, Diagnosis) In the above, primary keys are underlined. The following referential integrity constraints exist: .From Dector.SSN to Person.SSN .From Patient.SSN to Pers.on.SSN . From MedicalVisit Doctor to Doctor.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) 8) Consider the following relational database conceptual schema used to keep track of patient visits in a medical clinic: Person (SSN, Name, DoB, Gender, PlaceQfRirth) Doctor (SSN, Specialty) Patient (SSN, InsurancelD, InsuranceProvider, MedicalRecordlD) MedicalVisit (Date. Doctor, Patient, Diagnosis) In the above, primary keys are underlined. The following referential integrity constraints exist: .From Dector.SSN to Person.SSN .From Patient.SSN to Pers.on.SSN . From MedicalVisit Doctor to Doctor.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)