Page 1 of 1

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
by answerhappygod
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 1
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 1 (45.35 KiB) Viewed 12 times
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