Question: Consider a database with two tables, created with the following commands: CREATE TABLE T 1 ( X INT NOT NULL, PRIMARY KEY ( X )
Consider a database with two tables, created with the following commands:
CREATE TABLE TX INT NOT NULL,
PRIMARY KEYX
;
CREATE TABLE TY INT NOT NULL, Z INT NOT NULL,
PRIMARY KEYY
FOREIGN KEYY REFERENCES TX ON DELETE CASCADE
;
Assume many rows have been added to each of the tables.
Which of the following is guaranteed to be true? Select all that apply.
Hint: consider how the foreign key and both primary keys limit what rows are valid in the tables.
Group of answer choices
The number of rows in T is the number of rows in T
The number of rows in T is the number of rows in T
The maximum number of unique Z values is equal to the number of X values
The minimum number of unique Z values is
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
