Given the following statements:
S1: A foreign key declaration can always be replaced by an equivalent check assertion in SQL.
S2: Given the table R(a,b,c)R(a,b,c) where aa and bb together form the primary key, the following is a valid table definition.
CREATE TABLE S (
PRIMARY KEY (d),
FOREIGN KEY (a) references R)
Which one of the following statements is CORRECT?
- S1 is TRUE and S2 is FALSE
- Both S1 and S2 are TRUE
- S1 is FALSE and S2 is TRUE
- Both S1 and S2 are FALSE
FOREIGN KEY (a) references R) .
Does this line mean that it references the first attribute of R?