Questão 242618

242618 Ano: 2012
Disciplina: TI - Banco de Dados
Banca: CESGRANRIO
Orgão: Petrobrás

Provas:

Analista de TI - Engenharia de Software
Provas ×

Modelagem de DadosModelo Entidade-Relacionamento

Seja o modelo E-R em que todas as colunas foram definidas como INTEGER, pois os tipos de dados são irrelevantes para o problema.

Qual modelo lógico relacional preserva a semântica do modelo acima?

CREATE TABLE XY (
Y1 INTEGER NOT NULL,
Y2 INTEGER NOT NULL,
Y3 INTEGER,
X1 INTEGER NOT NULL,
X2 INTEGER,
X3 INTEGER,
R1 INTEGER,
S1 INTEGER,
Z1 INTEGER NOT NULL,
CONSTRAINT XY_PK PRIMARY KEY (Y1,Y2),
CONSTRAINT XY_UK1 UNIQUE (X1),
CONSTRAINT XY_FK1 FOREIGN KEY (Z1) REFERENCES Z (Z1))

CREATE TABLE Z (
Z1 INTEGER NOT NULL,
Z2 INTEGER,
CONSTRAINT Z_PK PRIMARY KEY (Z1))

CREATE TABLE X (
X1 INTEGER NOT NULL,
X2 INTEGER,
X3 INTEGER,
CONSTRAINT X_PK PRIMARY KEY (x1))

CREATE TABLE Y (
Y1 INTEGER NOT NULL,
Y2 INTEGER NOT NULL,
Y3 INTEGER,
X1 INTEGER NOT NULL,
R1 INTEGER,
CONSTRAINT Y_PK PRIMARY KEY (Y1,Y2),
CONSTRAINT Y_UK1 UNIQUE (X1),
CONSTRAINT Y_FK1 FOREIGN KEY (X1) REFERENCES X (X1))

CREATE TABLE Z (
Z1 INTEGER NOT NULL,
Z2 INTEGER,
CONSTRAINT Z_PK PRIMARY KEY (Z1))

CREATE TABLE S (
X1 INTEGER NOT NULL,
Z1 INTEGER NOT NULL,
S1 INTEGER,
CONSTRAINT S_PK PRIMARY KEY (X1,Z1),
CONSTRAINT S_FK1 FOREIGN KEY (X1) REFERENCES X (X1),
CONSTRAINT S_FK2 FOREIGN KEY (Z1) REFERENCES Z (Z1))

CREATE TABLE X (
X1 INTEGER NOT NULL,
X2 INTEGER,
X3 INTEGER,
Z1 INTEGER,
S1 INTEGER,
CONSTRAINT X_PK PRIMARY KEY (x1),
CONSTRAINT X_FK FOREIGN KEY (Z1) REFERENCES Z (Z1))

CREATE TABLE Z (
Z1 INTEGER NOT NULL,
Z2 INTEGER,
CONSTRAINT Z_PK PRIMARY KEY (Z1))

CREATE TABLE XY (
Y1 INTEGER NOT NULL,
Y2 INTEGER NOT NULL,
Y3 INTEGER,
X1 INTEGER NOT NULL,
X2 INTEGER,
X3 INTEGER,
R1 INTEGER,
S1 INTEGER,
Z1 INTEGER NOT NULL,
CONSTRAINT XY_PK PRIMARY KEY (Y1,Y2,X1),
CONSTRAINT XY_FK1 FOREIGN KEY (Z1) REFERENCES Z (Z1))

CREATE TABLE Z (
Z1 INTEGER NOT NULL,
Z2 INTEGER,
CONSTRAINT Z_PK PRIMARY KEY (Z1))

CREATE TABLE X (
X1 INTEGER NOT NULL,
X2 INTEGER,
X3 INTEGER,
CONSTRAINT X_PK PRIMARY KEY (x1))

CREATE TABLE Y (
Y1 INTEGER NOT NULL,
Y2 INTEGER NOT NULL,
Y3 INTEGER,
X1 INTEGER,
R1 INTEGER,
CONSTRAINT Y_PK PRIMARY KEY (Y1,Y2),
CONSTRAINT Y_UK1 UNIQUE (X1),
CONSTRAINT Y_FK1 FOREIGN KEY (X1) REFERENCES X (X1))
CREATE TABLE Z (
Z1 INTEGER NOT NULL,
Z2 INTEGER,
CONSTRAINT Z_PK PRIMARY KEY (Z1))

CREATE TABLE S (
X1 INTEGER NOT NULL,
Z1 INTEGER NOT NULL,
S1 INTEGER,
CONSTRAINT S_PK PRIMARY KEY (X1),
CONSTRAINT S_FK1 FOREIGN KEY (X1) REFERENCES X (X1),
CONSTRAINT S_FK2 FOREIGN KEY (Z1) REFERENCES Z (Z1))

Provas

Questão presente nas seguintes provas

Analista de TI - Engenharia de Software

70 Questões

Provas

Analista de TI - Engenharia de Software

Acesse sua Conta

Crie uma Conta