Questão 33 – Raciocínio Lógico – CESGRANRIO 2022 – Eletrobras Termonuclear S.A. (Analista de Sistemas)

CREATE TABLE JA ( A1 TEXT NOT NULL, A2 TEXT NOT NULL, PRIMARY KEY (A1));

CREATE TABLE KP ( P1 TEXT NOT NULL, P2 TEXT NOT NULL, A1 TEXT NULL, T1 TEXT NULL, PRIMARY KEY (P1), FOREIGN KEY (A1)

REFERENCES JA (A1));

CREATE TABLE JA ( A1 TEXT NOT NULL, A2 TEXT NOT NULL, PRIMARY KEY (A1));

CREATE TABLE KP ( P1 TEXT NOT NULL, P2 TEXT NOT NULL, PRIMARY KEY (P1));

CREATE TABLE T ( P1 TEXT NOT NULL, A1 TEXT NOT NULL, T1 TEXT NOT NULL, PRIMARY KEY (P1, A1), FOREIGN KEY (P1)

REFERENCES KP (P1), FOREIGN KEY (A1)

REFERENCES JA (A1));

CREATE TABLE JA ( A1 TEXT NOT NULL, A2 TEXT NOT NULL, PRIMARY KEY (A1));

CREATE TABLE KP ( P1 TEXT NOT NULL, P2 TEXT NOT NULL, PRIMARY KEY (P1));

CREATE TABLE T ( P1 TEXT NOT NULL, A1 TEXT NOT NULL, T1 TEXT NOT NULL, PRIMARY KEY (P1), FOREIGN KEY (P1)

REFERENCES KP (P1), FOREIGN KEY (A1)

REFERENCES JA (A1));

CREATE TABLE T ( A1 TEXT NOT NULL, A2 TEXT NOT NULL, P1 TEXT NOT NULL, P2 TEXT NOT NULL, T1 TEXT NOT NULL, PRIMARY KEY (P1, A1));

CREATE TABLE JA ( A1 TEXT NOT NULL, A2 TEXT NOT NULL, P1 TEXT NULL, T1 TEXT NULL, PRIMARY KEY (A1)

FOREIGN KEY (P1)

REFERENCES KP (P1));

CREATE TABLE KP ( P1 TEXT NOT NULL, P2 TEXT NOT NULL, PRIMARY KEY (P1));