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?

Consider an index implemented using simple linear indexing,…

Consider an index implemented using simple linear indexing, with stored index as follows: 34,   56,   60,   65,   80,   103,   140,   150,  173,  192,  202,   231,   253,   270,  299 How many comparisons are needed, respectively, for finding the index 192 and 140 using binary search:

Suppose A is an attribute that is a foreign key in table T1,…

Suppose A is an attribute that is a foreign key in table T1, which references the same primary key in table T2. Consider the following two operations: A row (record) is deleted from table T1, with a non-null value of attribute A; A row (record) is deleted from table T2, with a non-null value of attribute A.    Which of the following statement is true?