Using the following information to answer the questions that…

Using the following information to answer the questions that follow: You are invited to design a database system for the Mountain View Community Hospital. The entity-relationship diagram for the designed system is attached below. The tables designed for (a part of) the above database are given below: (primary keys are underlined, foreign keys are in italic, and attributes appearing in both primary and foreign keys are marked with bold.) Physician_T: PhysicianID, PhysicianName, PhysicianSalary Patient_T: PatientID, PatientName, PatientAge, WardID Order_T: OrderID, PatientID, PhysicianID, OrderTime Drug_T: DrugID, DrugName, DrugPrice IsFor_T: OrderID, DrugID, PrescribedVolume Ward_T: WardID, WardCapacity, FacilityLocation WardAssignment_T: WardID, PhysicianID, StartTime, EndTime