In: Computer Science
In the MedicalVisit table the primary key is defined as (Date, Doctor, Patient).
1. 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.)
2. Please Draw an ER diagram based on the above original Relational Model
PLEASE FIND THE ANSWER(S) and EXPLANATION
BELOW.