Cadernos de Questões

Provas Favoritas

Filtros Salvos

Foi encontrada 1 questão.
#2435631

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.

Imagem associada para resolução da questão

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

  • CREATE TABLE XY (Y1    INTEGER NOT NULL,Y2INTEGER NOT NULL,Y3INTEGER,X1INTEGER NOT NULL,X2INTEGER,X3INTEGER,R1INTEGER,S1INTEGER,Z1INTEGERNOTNULL,CONSTRAINTXY_PKPRIMARYKEY(Y1,Y2),CONSTRAINTXY_UK1UNIQUE(X1),CONSTRAINTXY_FK1FOREIGNKEY(Z1)REFERENCES Z(Z1))CREATE TABLE Z (Z1INTEGER NOT NULL,Z2INTEGER,CONSTRAINTZ_PKPRIMARYKEY(Z1))
  • CREATE TABLE X (X1INTEGER NOT NULL,X2INTEGER,X3INTEGER,CONSTRAINT X_PK PRIMARY KEY (x1))CREATETABLEY(Y1INTEGER NOT NULL,Y2INTEGER NOT NULL,Y3INTEGER,X1INTEGER NOT NULL,R1INTEGER,CONSTRAINTY_PKPRIMARYKEY(Y1,Y2),CONSTRAINTY_UK1UNIQUE(X1),CONSTRAINTY_FK1FOREIGNKEY(X1)REFERENCESX(X1))CREATE TABLE Z (Z1 INTEGER NOT NULL,Z2 INTEGER,CONSTRAINTZ_PKPRIMARYKEY(Z1))CREATE TABLE S (X1INTEGER NOT NULL,Z1INTEGER NOT NULL,S1INTEGER,CONSTRAINTS_PK PRIMARYKEY (X1,Z1),CONSTRAINTS_FK1 FOREIGNKEY (X1)REFERENCES X (X1),CONSTRAINTS_FK2 FOREIGNKEY (Z1)REFERENCES Z (Z1))
  • CREATE TABLE X (X1INTEGER NOT NULL,X2INTEGER,X3INTEGER,Z1INTEGER,S1INTEGER,CONSTRAINTX_PK PRIMARYKEY (x1),CONSTRAINTX_FK FOREIGNKEY (Z1)REFERENCES Z (Z1))CREATE TABLE Y (Y1INTEGER NOT NULL,Y2INTEGER NOT NULL,Y3INTEGER,X1INTEGER NOT NULL,R1INTEGER,CONSTRAINTY_PK PRIMARYKEY (Y1,Y2),CONSTRAINTY_UK1 UNIQUE (X1),CONSTRAINTY_FK1 FOREIGNKEY (X1) REFERENCES X (X1))CREATE TABLE Z (Z1INTEGER NOT NULL,Z2INTEGER,CONSTRAINT Z_PK PRIMARY KEY (Z1))
  • CREATE TABLE XY (Y1INTEGER NOT NULL,Y2INTEGER NOT NULL,Y3INTEGER,X1INTEGER NOT NULL,X2INTEGER,X3INTEGER,R1INTEGER,S1INTEGER,Z1INTEGER NOT NULL,CONSTRAINTXY_PKPRIMARYKEY (Y1,Y2,X1),CONSTRAINTXY_FK1FOREIGNKEY (Z1) REFERENCES Z (Z1))CREATE TABLE Z (Z1INTEGER NOT NULL,Z2INTEGER,CONSTRAINT Z_PK PRIMARY KEY (Z1))
  • CREATE TABLE X (X1INTEGER NOT NULL,X2INTEGER,X3INTEGER,CONSTRAINTX_PK PRIMARYKEY (x1))CREATE TABLE Y (Y1INTEGER NOT NULL,Y2INTEGER NOT NULL,Y3INTEGER,X1INTEGER,R1INTEGER,CONSTRAINTY_PK PRIMARYKEY (Y1,Y2),CONSTRAINTY_UK1 UNIQUE (X1),CONSTRAINTY_FK1 FOREIGNKEY (X1) REFERENCES X (X1))CREATE TABLE Z (Z1INTEGER NOT NULL,Z2INTEGER,CONSTRAINTZ_PK PRIMARY KEY (Z1))CREATE TABLE S (X1INTEGER NOT NULL,Z1INTEGER NOT NULL,S1INTEGER,CONSTRAINTS_PKPRIMARY KEY (X1),CONSTRAINTS_FK1FOREIGN KEY (X1) REFERENCES X (X1),CONSTRAINTS_FK2FOREIGN KEY (Z1) REFERENCES Z (Z1))
Fale com IAgo
IAgo - Assistente IAProva
IA
Olá! Sou o IAgo, seu assistente aqui no IAProvatec 😊
Veja como posso te ajudar:
Agora