Tham khảo tài liệu 'giáo trình sql bài 11', công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả | 1 6 Exercises Suppose each of the following update operations is applied directly to the database of Figure . Discuss all integrity constraints violated by each operation if any and the different ways of enforcing these constraints a Insert Robert F Scott 943775543 21-JUN-42 2365 Newcastle Rd Bellaire TX M 58000 888665555 1 into EMPLOYEE. b Insert ProductA 4 Bellaire 2 into PROJECT. c Insert Production 4 943775543 01-OCT-88 into DEPARTMENT. d Insert 677678989 null into WORKS_ON. e Insert 453453453 John M 12-DEC-60 SPOUSE into DEPENDENT. f Delete the WORKS_ON tuples with ESSN 333445555 . g Delete the EMPLOYEE tuple with SSN 987654321 . h Delete the PROJECT tuple with PNAME ProductX . i Modify the MGRSSN and MGRSTARTDATE of the DEPARTMENT tuple with DNUMBER 5 to 123456789 and 01-OCT-88 respectively. j Modify the SUPERSSN attribute of the EMPLOYEE tuple with SSN 999887777 to 943775543 . k Modify the HOURS attribute of the WORKS_ON tuple with ESSN 999887777 and PNO 10 to . Consider the AIRLINE relational database schema shown in Figure which describes a database for airline flight information. Each FLIGHT is identified by a flight NUMBER and consists of one or more FLIGHT_LEGs with LEG_NUMBERs 1 2 3 etc. Each leg has scheduled arrival and departure times and airports and has many LEG_INSTANCEs--one for each DATE on which the flight travels. FARES are kept for each flight. For each leg instance SEAT_RESERVATIONs are kept as is the AIRPLANE used in the leg and the actual arrival and departure times and airports. An AIRPLANE is identified by an AIRPLANE_ID and is of a particular AIRPLANE_TYPE. CAN_LAND relates AIRPLANE_TYPEs to the AIRPORTs in which they can land. An AIRPORT is identified by an AIRPORT_CODE. Consider an update for the AIRLINE database to enter a reservation on a particular flight or flight leg on a given date. a Give the operations for this update. b What types of constraints would you expect
