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
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 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 PRI
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
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!