Question: g. Construct a new tuple that can be inserted into ADMISSION without violating any constraints. h. Construct a new tuple that cannot be inserted into


g. Construct a new tuple that can be inserted into ADMISSION without violating any constraints.
h. Construct a new tuple that cannot be inserted into ADMISSION because doing so would violate referential integrity (but would not violate any other constraints)
i. Construct a new tuple that can be inserted into UNIT without violating any constraints.
j. Construct a new tuple that cannot be inserted into UNIT because doing so would violate a key constraint (and thus would also violate entity integrity), but would not violate any other constraints.
k. List the tuple(s) in HOSPITAL that can be removed from the table without violating referential integrity, and explain why their removal would not violate referential integrity.
3. Answer the questions below for the following relational database schema and relational database instance containing four relations. Database Schema: PATIENT (PatientID, PatientName, PatientPhone) ADMISSION (PID, UID, Admission Date, DischargeDate) UNIT (UnitID, UnitName, HID, UnitFloor) HOSPITAL (HospitalID, HospitalName, HospitalCity) Database Instance: PATIENT PatientID PatientName 2222 Aldrin 1139 Eriksen 4078 Mosby 6505 Scherbatsky 9977 Stinson Patient Phone 5551111 5551111 5552222 5553333 5554444 ADMISSION PID UID 2222 MAT1 6505 MAT2 4078 PED1 4078 REH1 9977 REH1 Admission Date Discharge Date 01-JAN-20 05-JAN-20 01-JAN-21 04-JAN-21 30-AUG-20 05-SEP-20 05-SEP-20 18-SEP-20 15-APR-20 20-APR-20 UnitFloor 3 HOSPITAL HospitaliD H004 H119 H690 H222 H357 HospitalName HospitalCity Northwestern Chicago Stroger Chicago Advocate Oak Lawn Edward Naperville Condell Mundelein UNIT UnitID MAT1 MAT2 ONC1 PED1 REH1 UnitName HID Maternity H119 Maternity H222 Oncology H004 Pediatric H119 Rehabilitation H357 2 2 3 4
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
