8. Here are declarations of two relations R and S: CREATE TABLE S( C INT PRIMARY KEY, d INT ); CREATE TABLE R( a INT PRI
Posted: Thu May 26, 2022 9:11 am
8. Here are declarations of two relations R and S: CREATE TABLE S( C INT PRIMARY KEY, d INT ); CREATE TABLE R( a INT PRIMARY KEY, b INT REFERENCES S(c) ); R(a,b) currently contains the four tuples (0,1), (7,1), (3,3), and (9,9). S(c,d) currently contains the four tuples (1,4), (7,8), (9,4), and (3,1). Which of the following modifications will not violate any constraint: a) Inserting (1,5) into R b) Inserting (2,3) into S c) Inserting (3,9) into R O d) Deleting (9,4) from S