Download - Taller Refuerzo Juan Carlos Velasquez MuñOz
![Page 1: Taller Refuerzo Juan Carlos Velasquez MuñOz](https://reader036.vdocuments.co/reader036/viewer/2022081702/55a04abd1a28ab190b8b46a2/html5/thumbnails/1.jpg)
JUAN CARLOS VELASQUEZ MUÑOZ
CODIGO: 2307015
TALLER DE REFUERZO
5to SEMESTRE DE ING. SISTEMAS
BASES DE DATOS
UCEVA
![Page 2: Taller Refuerzo Juan Carlos Velasquez MuñOz](https://reader036.vdocuments.co/reader036/viewer/2022081702/55a04abd1a28ab190b8b46a2/html5/thumbnails/2.jpg)
TABLAS Y RELACIONES EN BD DESIGNER
![Page 3: Taller Refuerzo Juan Carlos Velasquez MuñOz](https://reader036.vdocuments.co/reader036/viewer/2022081702/55a04abd1a28ab190b8b46a2/html5/thumbnails/3.jpg)
1. Identificar las llaves primarias y foráneas.
BLOQUE (COB, NOMBRE)
SALON (COS, NOMBRE, COB)
ASIGNATURA (COA, NOMBRE, CREDITO, HTI, AC, HP, COS, COP, COD, COAR)
FACULTAD (COF, NOMBRE)
PROGRAMA (COP, NOMBRE, COF)
AREA (COAR, NOMBRE)
DOCENTE (COD, NOMBRE, FECHADENACIMIENTO, PREGRADO, POSGRADO, FECHADEINGRESO)
PREREQUISITOS (COPRE, NOMBRE)
ASIGNAT_PRERREQ (COA, COPRE)
![Page 4: Taller Refuerzo Juan Carlos Velasquez MuñOz](https://reader036.vdocuments.co/reader036/viewer/2022081702/55a04abd1a28ab190b8b46a2/html5/thumbnails/4.jpg)
CODIGO FUETE
CREATE TABLE "AREA"
( "COAR" NUMBER NOT NULL ENABLE,
"NOMBRE" CHAR(35),
CONSTRAINT "AREA_PK" PRIMARY KEY ("COAR") ENABLE
)
/
CREATE TABLE "DOCENTE"
( "COD" NUMBER NOT NULL ENABLE,
"NOMBRE" CHAR(20),
"FECHADENACIMIENTO" CHAR(20),
"PREGRADO" CHAR(100),
"POSGRADO" CHAR(100),
"FECHAINGRESO" CHAR(20),
CONSTRAINT "DOCENTE_PK" PRIMARY KEY ("COD") ENABLE
)
/
CREATE TABLE "PROGRAMA"
( "COP" NUMBER NOT NULL ENABLE,
"NOMBRE" CHAR(30),
"COF" NUMBER NOT NULL ENABLE,
CONSTRAINT "PROGRAMA_PK" PRIMARY KEY ("COP") ENABLE,
CONSTRAINT "PROGRAMA_FK" FOREIGN KEY ("COF")
REFERENCES "FACULTAD" ("COF") ENABLE
)
/
CREATE TABLE "SALON"
( "COS" NUMBER NOT NULL ENABLE,
"NOMBRE" CHAR(60),
"COB" NUMBER,
CONSTRAINT "SALON_PK" PRIMARY KEY ("COS") ENABLE,
CONSTRAINT "SALON_FK" FOREIGN KEY ("COB")
REFERENCES "BLOQUE" ("COB") ENABLE
)
/
CREATE TABLE "ASIGNATURA"
( "COA" NUMBER NOT NULL ENABLE,
"NOMBRE" CHAR(30),
"CREDITO" CHAR(12),
"THI" CHAR(1),
"AC" CHAR(1),
"HP" CHAR(1),
"COP" NUMBER,
"COD" NUMBER,
"COAR" NUMBER,
"COS" NUMBER,
CONSTRAINT "ASIGNATURA_PK" PRIMARY KEY ("COA") ENABLE,
CONSTRAINT "ASIGNATURA_FK" FOREIGN KEY ("COP")
REFERENCES "PROGRAMA" ("COP") ENABLE,
CONSTRAINT "ASIGNATURA_FK2" FOREIGN KEY ("COD")
REFERENCES "DOCENTE" ("COD") ENABLE,
CONSTRAINT "ASIGNATURA_FK3" FOREIGN KEY ("COAR")
REFERENCES "AREA" ("COAR") ENABLE,
![Page 5: Taller Refuerzo Juan Carlos Velasquez MuñOz](https://reader036.vdocuments.co/reader036/viewer/2022081702/55a04abd1a28ab190b8b46a2/html5/thumbnails/5.jpg)
CONSTRAINT "ASIGNATURA_FK4" FOREIGN KEY ("COS")
REFERENCES "SALON" ("COS") ENABLE
)
/
CREATE TABLE "PRERREQUISITOS"
( "COPRE" NUMBER NOT NULL ENABLE,
"NOMBRE" CHAR(30),
CONSTRAINT "PRERREQUISITOS_PK" PRIMARY KEY ("COPRE") ENABLE
)
/
CREATE TABLE "ASIG_PRERRE"
( "COA" NUMBER,
"COPRE" NUMBER,
CONSTRAINT "ASIG_PRERRE_FK" FOREIGN KEY ("COA")
REFERENCES "ASIGNATURA" ("COA") ENABLE,
CONSTRAINT "ASIG_PRERRE_FK2" FOREIGN KEY ("COPRE")
REFERENCES "PRERREQUISITOS" ("COPRE") ENABLE
)
/
CREATE TABLE "BLOQUE"
( "COB" NUMBER NOT NULL ENABLE,
"NOMBRE" CHAR(20),
CONSTRAINT "BLOQUE_PK" PRIMARY KEY ("COB") ENABLE
)
/
CREATE TABLE "FACULTAD"
( "COF" NUMBER NOT NULL ENABLE,
"NOMBRE" CHAR(30),
CONSTRAINT "FACULTAD_PK" PRIMARY KEY ("COF") ENABLE
)
/
![Page 6: Taller Refuerzo Juan Carlos Velasquez MuñOz](https://reader036.vdocuments.co/reader036/viewer/2022081702/55a04abd1a28ab190b8b46a2/html5/thumbnails/6.jpg)