The following tables are modified and abbreviated versions of the database prese

Question

The following tables are modified and abbreviated versions of the database presented in our textbook: Instructors Table Last Name First Name Instructor ID Rank Woodward Jean Carson Scott 1252234 Professor LePorter Lucy Hamme Emanuel 1566543 Professor Valerie Jonese 1578223 Professor 1228964 Professor 1478893 Associate Professor ScheduleTable Schedule ID Subject Instructor ID Roomt 40198 ACC 1252234 H210 40211 ACC 1566543 H212 40243 ACC 1228964 H220 40344 BUS 1566543 H212 40496 ACC 1578223 H210 40603 BUS 1228964 H210 40759 BUS 1566543 H220 40804 BUS 40875 ACC 1566543 H212 40912 BUS 1578223 H220 40996 BUS 1252234 H212 1252234 H210 If a one-to-many relationship is established between the tables and referential integrity is enforced with neither Cascade option selected, what will happen if you attempt to delete Course 40912 from the Schedule table? Course 40912 will be deleted

Explanation / Answer

Option 1 : Course 40912 will be deleted.

Because deleting a foreign key row (in this case Instructor ID is foreign key ) does not break referential integrity rules so row with Schedule ID= 40912 will easily get deleted without affecting the other table primary key value.

As per Referential Integrity rules you cannot delete the primary key row from parent table which is foriegn key in child table in this case we have to add Cascade option On Delete Cascade so that both the tables row get affected.

But in this case we are deleting base table ie ScheduleTable row which has foreign key, deleting this row does not affect the referential integrity rules. So Course with 40912 will be deleted.

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.