QUESTION 30 Doctor Doctor ID 01 02 03 Name Yuan Oberhoff Shastri Specialty Neurology Internal Internal Building A A B For The Doctor Relation Shown Here, Answer The Following Questions. 1) If You Are Going To Select A Primary Key For This Relation, Which One Is Better, Doctor ID Or Name? (3 Pts) Explain Why Pts) 2) If Dr. Oberhoff Is In Building C, Can We

 

QUESTION 30 Doctor Doctor ID Name Specialty Building 01 Yuan Neurology A 02 03 Oberhoff Shastri Internal A Internal B For the Doctor relation shown here, answer the following questions. 1) If you are going to select a primary key for this relation, which one is better, Doctor ID or Name? (3 pts) Explain why pts). 2) If Dr. Oberhoff is in Building C, can we use (Building) as the primary key? (3 pts) Explain why (7 pts)