Question: Consider the schema R(A, B, C) and S(C, D, E) and the database given below (R has 4 tuples, S has 3). Table R

Consider the schema R(A, B, C) and S(C, D, E) and the database given below (R has 4 tuples, S has 3). Table R A B2 C UMM 1 2 3 2 2 3 2 1 3 3 4 4 Table S C () D E 1 2 3 2 3 4 3 4 2 Indicate which of the following are true or false. A) R(A,C) may be declared as a key for R (meaning the instance True does not violate this key). B) If S(D) is a key for S, then S(E) may be a foreign key for S. True C) select max(A) from R, S group by B, D contains nine tuples. True D) RS contains 3 tuples. True E) BA=D (R S) - II (R) contains a single tuple. False 1=.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
