Assinale o script SQL de criação das tabelas T, R e S, que esteja correto sintaticamente e seja compatível com as respectivas instâncias exibidas anteriormente.

Tabela T:
A | B | C
10 | LPG Participa

Question

Assinale o script SQL de criação das tabelas T, R e S, que esteja correto sintaticamente e seja compatível com as respectivas instâncias exibidas anteriormente.

Tabela T:
A | B | C
10 | LPG Participações | N
20 | Serviços & Gerenciamento Remoto | S
50 | Academia Americana | S
70 | Distribuidora São João de Artigos para Festas | S

Tabela R:
D | E | F
12040 | 21/06/2021 | 200,00
12041 | 23/06/2021 | 548,00
1497 | 15/06/2021 | 147,10
1498 | 15/06/2021 | 85,00
214 | 18/06/2021 | 99,00
215 | 19/06/2021 | 997,45

Tabela S:
G | H | I
10 | 12040 | 12
10 | 12041 | 12
50 | 1497 | 12
50 | 1498 | 10
70 | 214 | 20
20 | 50 | 215
|  | 12 |

Accepted Answer

create table T(A int not null, B varchar(64), primary key (A))
create table R(D int not null, E datetime, F money, primary key (D))
create table S(G int not null, H int, I int, primary key(G,H), foreign key (G) references T(A), foreign key (H) references R(D))

Answer

create table T(A int not null, B varchar(32), primary key (A))
create table R(D int not null, E datetime, F money, primary key (D))
create table S(G int not null, H int, I int, primary key(G), primary key(H), foreign key (G) references T(A), foreign key (H) references R(D))

Answer

create table T(A int not null, B varchar(64), primary key (A))
create table R(D int not null, E datetime, F money, primary key (D))
create table S(G int not null, H int, I int, primary key(G,H), foreign key (H) references T(A), foreign key (G) references R(D))

Answer

create table T(A int not null, B varchar(32), primary key (A))
create table R(D int not null, E datetime, F money, primary key (D))
create table S(G int not null, H int, I int, primary key(G), primary key(H), foreign key (G) references T(A), foreign key (H) references R(D))

Answer

create table T(A int not null, B varchar(32), primary key (A))
create table R(D int not null, E datetime, F money, primary key (D))
create table S(G int not null, H int, I int, primary key(G,H), foreign key (G) references T(1), foreign key (H) references R(2))

Questão 1277 — Informática

Comentários