The following table has two attributes A and C where A is the primary key and C is the foreign key referencing A with on-delete cascade.

The set of all tuples that must be additionally deleted to preserve referential integrity when the tuple (2,4) is deleted is:

Keep practicing — related questions

• Let R (a, b, c) and S (d, e, f) be the two relations in which d is the foreign key of S that refers to the ...
• Consider a relation geq which represents “greater than or equal to”, that is, (x,y) $\epsilon$geq only if y...
• Consider a relation geq, which represents “greater than or equal to”, i.e. (x, y)$\in$ geq only if y > = x....
• Suppose we are having relation schema as student (name, student-id, degree-level) with primary key as stude...
• An attribute of one table matching the primary key of another table is called as
• In Relation Model, column is referred to as
• The union of primary keys of the related entity sets becomes a _________.
• Which of the following terms in DBMS is the set of all values that can be taken by the attribute in a relat...