Question

R a b c 1 2 3 2 3 NULL 5 2 2 6 NULL 1

S d a 1 NULL 2 5 4 1 6 1

O conjunto de comandos de definição de dados que criam corretamente as tabelas R e S de acordo com as instâncias mostradas acima é:

Accepted Answer

C) create table R(
a int not null primary key, b int, c int);
create table S(
d int not null primary key, a int,
constraint c1 foreign key (a) references R);

Answer

A) create table R( a int not null primary key, b int, c int not null); create table S( d int not null primary key, a int, constraint c1 foreign key (a) references R);

Answer

B) create table R( a int not null primary key, b int, c int not null); create table S( d int not null primary key, a int, constraint c1 foreign key references R(a));

Answer

D) create table R(
a int not null primary key, b int, c int);
create table S(
d int not null, a int primary key,
constraint c1 foreign key (a) references R);

Answer

E) create table R( a int not null primary key, b int not null, c int); create table S( d int not null primary key, a int, constraint c1 foreign key (a) references R);

Mais questões de SQL