Describe the delete set-to-default option (for implementing a referential integrity constraint)
What will be an ideal response?
The delete set-to-default option allows a record to be deleted if its primary key value is referred to by a foreign key value of a record in another relation. As a result, in all of the records where the foreign key value refers to the primary key of the record that is being deleted, the value of the foreign key is set to a predetermined default value.
You might also like to view...
The chair of the Board of Governors is the chair of the __________
Fill in the blank(s) with the appropriate word(s).
Wally owns 40 acres along a river. He is planning to build a home near the river, and a friend
has just informed him that the land where Wally is planning to build the house is on wetlands. In this circumstance, what must Wally do in order to be able to fill in the wetlands for the construction of his house? A) Nothing, so long as the house will not emit any pollutants into the nearby river B) File an environmental impact statement C) Obtain a permit from the Army Corps of Engineers D) Nothing, because this is the action of a private individual on private land E) File an environmental impact statement and obtain a permit from the Army Corps of Engineers