Suppose you work at a hospital and are assigned the work of…
Suppose you work at a hospital and are assigned the work of designing a database for the hospital. You designed two tables: the facility table, with information of the facilities, wards and patients, and the physician table, with information of the physicians and patients. You may assume that Each physician treats multiple patients and each patient may be assigned to multiple physicians; Each facility may contain multiple wards but each ward only belongs to a unique facility; Each ward hosts multiple patients but each patient is hosted in a unique ward. Suppose your designed facility table consists of the following attributes: facility_ID, ward_ID, patient_ID, admit_time, discharge_time. Which of the attribute(s) should be designated as the primary key(s) in this table?