(Choose 1 answer)
Select the valid query to declare the foreign key presC# of the relation Studio(name, address, presC#) that references the cert# of the relation MovieExec(name, address, cert#, netWorth):
A. CREATE TABLE Studio (name CHAR(30) PRIMARY KEY, address VARCHAR(256), presC# INT REFERENCES MovieExec(cert#));
B. CREATE TABLE Studio (name CHAR(30) PRIMARY KEY, address VARCHAR(256), presC# INT FOREIGN KEY);
C. CREATE TABLE Studio (name CHAR(30) PRIMARY KEY, address VARCHAR(256), presC# INT UNIQUE KEY REFERENCES MovieExec);
D. All of the others.
Exit 39
