Questão de Banco de Dados — Modelagem e Mapeamento ER-relacional — CESGRANRIO 2022
Banco de DadosModelagem e Mapeamento ER-relacional
- Código
- cg056694
- Banca
- CESGRANRIO
- Órgão
- ELETRONUCLEAR
- Ano
- 2022
- Cargo
- PNS ( )
Considere o diagrama E-R abaixo. Qual esquema relacional preserva a semântica desse modelo E-R?
- ACREATE 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));
- BCREATE 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));
- CCREATE 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));
- DCREATE 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));
- ECREATE 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));