Consider a relation geq which represents “greater than or equal to”, that is,…
GATE · 2001 · CS · Question 2 subparts
Consider a relation geq which represents “greater than or equal to”, that is, (x, y) ∈ geq only if y ≥ x.
create table geq
( lb integer not null
ub integer not null
primary key lb
foreign key (ub) references geq on delete cascade )Which of the following is possible if a tuple (x, y) is deleted?
- A.
A tuple (z, w) with z > y is deleted
- B.
A tuple (z, w) with z > x is deleted
- C.
A tuple (z, w) with w < x is deleted
- D.
The deletion of (x, y) is prohibited
Attempted by 191 students.
Sign up free to check your answer
Sign up freeLoading lesson…