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 T1(X INT NOT NULL,
PRIMARY KEY(X)
);
CREATE TABLE T2(Y INT NOT NULL, Z INT NOT NULL,
PRIMARY KEY(Y),
FOREIGN KEY(Y) REFERENCES T1(X) 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 T1 is <= the number of rows in T2
The number of rows in T2 is <= the number of rows in T1
The maximum number of unique Z values is equal to the number of X values
The minimum number of unique Z values is 0

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!