Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*
- Created: 26/05/2015
- Modified: 26/05/2015
- Model: Oracle 10g
- Database: Oracle 10g
- */
- -- Create tables section -------------------------------------------------
- -- Table CURSO
- CREATE TABLE "CURSO"(
- "codigo_curso" INTEGER NOT NULL,
- "nombre_curso" Varchar2(30 ),
- "creditos" INTEGER,
- "codigo_catedratico" INTEGER NOT NULL
- )
- /
- -- Add keys for table CURSO
- ALTER TABLE "CURSO" ADD CONSTRAINT "Key1" PRIMARY KEY ("codigo_curso","codigo_catedratico")
- /
- -- Table ESTUDIANTE
- CREATE TABLE "ESTUDIANTE"(
- "carne" INTEGER NOT NULL,
- "nombre_estudiante" Varchar2(30 ),
- "apellido_estudiante" Varchar2(30 ),
- "direccion" Varchar2(30 ),
- "fecha_nacimiento" DATE
- )
- /
- -- Add keys for table ESTUDIANTE
- ALTER TABLE "ESTUDIANTE" ADD CONSTRAINT "Key2" PRIMARY KEY ("carne")
- /
- -- Table CATEDRATICO
- CREATE TABLE "CATEDRATICO"(
- "codigo_catedratico" INTEGER NOT NULL,
- "nombre_catedratico" Varchar2(30 ),
- "apellido" Varchar2(30 ),
- "genero" Varchar2(30 ),
- "direccion" Varchar2(30 )
- )
- /
- -- Add keys for table CATEDRATICO
- ALTER TABLE "CATEDRATICO" ADD CONSTRAINT "Key3" PRIMARY KEY ("codigo_catedratico")
- /
- -- Table ASIGNACION
- CREATE TABLE "ASIGNACION"(
- "codigo_asignacion" INTEGER NOT NULL,
- "ciclo" Varchar2(30 ),
- "año" Varchar2(30 ),
- "carne" INTEGER NOT NULL,
- "codigo_curso" INTEGER NOT NULL,
- "codigo_catedratico" INTEGER NOT NULL,
- "numero_detalle_factura" INTEGER NOT NULL,
- "numero_factura" INTEGER NOT NULL,
- "carne" INTEGER NOT NULL
- )
- /
- -- Add keys for table ASIGNACION
- ALTER TABLE "ASIGNACION" ADD CONSTRAINT "Key4" PRIMARY KEY ("codigo_asignacion","carne","codigo_curso","codigo_catedratico","numero_detalle_factura","numero_factura")
- /
- -- Table FACTURA
- CREATE TABLE "FACTURA"(
- "numero_factura" INTEGER NOT NULL,
- "fecha" DATE,
- "carne" INTEGER NOT NULL
- )
- /
- -- Add keys for table FACTURA
- ALTER TABLE "FACTURA" ADD CONSTRAINT "Key5" PRIMARY KEY ("numero_factura","carne")
- /
- -- Table DETALLE_FACTURA
- CREATE TABLE "DETALLE_FACTURA"(
- "numero_detalle_factura" INTEGER NOT NULL,
- "numero_factura" INTEGER NOT NULL,
- "carne" INTEGER NOT NULL
- )
- /
- -- Add keys for table DETALLE_FACTURA
- ALTER TABLE "DETALLE_FACTURA" ADD CONSTRAINT "Key6" PRIMARY KEY ("numero_detalle_factura","numero_factura","carne")
- /
- -- Create relationships section -------------------------------------------------
- ALTER TABLE "ASIGNACION" ADD CONSTRAINT "Relationship1" FOREIGN KEY ("carne") REFERENCES "ESTUDIANTE" ("carne")
- /
- ALTER TABLE "CURSO" ADD CONSTRAINT "Relationship2" FOREIGN KEY ("codigo_catedratico") REFERENCES "CATEDRATICO" ("codigo_catedratico")
- /
- ALTER TABLE "ASIGNACION" ADD CONSTRAINT "Relationship3" FOREIGN KEY ("codigo_curso", "codigo_catedratico") REFERENCES "CURSO" ("codigo_curso", "codigo_catedratico")
- /
- ALTER TABLE "DETALLE_FACTURA" ADD CONSTRAINT "Relationship4" FOREIGN KEY ("numero_factura", "carne") REFERENCES "FACTURA" ("numero_factura", "carne")
- /
- ALTER TABLE "FACTURA" ADD CONSTRAINT "Relationship10" FOREIGN KEY ("carne") REFERENCES "ESTUDIANTE" ("carne")
- /
- ALTER TABLE "ASIGNACION" ADD CONSTRAINT "Relationship17" FOREIGN KEY ("numero_detalle_factura", "numero_factura", "carne") REFERENCES "DETALLE_FACTURA" ("numero_detalle_factura", "numero_factura", "carne")
- /
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement