Fecha de entrega del Proyecto "Application Software Mision Sucre"

Viernes 11 del 11 del 11. hora 11:00 am

Fecha de Prueba de la Base de Datos Mysql con Java

Jueves 10 de Noviembre del 2011

Fecha de Prueba de La Base de Datos Postgresql con PHP

Miercoles 9 de Noviembre 2011

Tabla Base de Datos Profesores

-- Table: "Data_Profesores"

-- DROP TABLE "Data_Profesores";

CREATE TABLE "Data_Profesores"
(
id_cedula integer NOT NULL,
"Nombre" character varying,
"Apellido" character varying(20),
"Estado" character varying(20),
"Municipio" character varying(20),
"Aldea" character varying(20),
"Genero" "char",
"Direccion" character varying(60),
"Asignatura" character varying,
"Profesion" character varying(50),
"IES" character varying(50),
"Año" date,
tel_hab integer,
tel_cel integer,
email character varying(50),
CONSTRAINT profesores_key PRIMARY KEY (id_cedula)
)
WITH (
OIDS=FALSE
);
ALTER TABLE "Data_Profesores" OWNER TO postgres;
COMMENT ON TABLE "Data_Profesores" IS 'Listado de Profesores';

Tabla Base de Datos Cuadro General

-- Table: "Cuadro_general"

-- DROP TABLE "Cuadro_general";

CREATE TABLE "Cuadro_general"
(
"Estado" character varying(20),
"Municipio" character varying(20),
"Aldea" character varying(20),
id_cedula integer NOT NULL,
"Nombre" character varying(20),
"Apellido" character varying(20),
"Genero" "char",
fecha_nacimiento timestamp without time zone,
"Grupo_sanguineo" character varying,
"Nacionalidad" "char",
direccion character varying(150),
"lugar de nacimiento" character varying(20),
telefono_de_hab integer,
telefono_celular integer,
email character varying(50),
"TIT_Medio" character varying,
"NUM_TITULO" integer,
"LIBRO" character varying(20),
"Folio" character varying(5),
"Plan_inter" character varying(20),
"cod_Plantel" integer,
"año_titulo" integer,
t1_ma integer,
"t1_PNNC" integer,
"t1_LC" integer,
"t1_TDA" integer,
"t1_PNAT" integer,
"t1_PLAD" integer,
"T1_IA" integer,
"T1_MA" integer,
"T1_INFO" integer,
"T1_LAPP1" integer,
"T1_CONT1" integer,
"T1_ING1" integer,
"T1_EST1" integer,
"T1_ESP1" integer,
"T1_PROY1" integer,
"T2_LAPP2" integer,
"T2_EST2" integer,
"T2_CONT2" integer,
"T2_FUE" integer,
"T2_PRE" integer,
"T2_COST" integer,
"T2_OS" integer,
"T2_MER1" integer,
"T2_DAR" integer,
"T2_ESP2" integer,
"T2_PROY2" integer,
"T3_FIN" integer,
"T3_ING2" integer,
"T3_MER2" integer,
"T3_AP" integer,
"T3_HSA" integer,
"T3_INMER" integer,
"T3_ISP3" integer,
"T3_PROY3" integer,
"T4_SIST" integer,
"T4_DAR2" integer,
"T4_AUD1" integer,
"T4_GESDE" integer,
"T4_FSP4" integer,
"T4_PROY4" integer,
CONSTRAINT id_cedula_est_key PRIMARY KEY (id_cedula)
)
WITH (
OIDS=FALSE
);
ALTER TABLE "Cuadro_general" OWNER TO postgres;

Tabla Base de Datos Cuadro General

-- Table: "Cuadro_general"

-- DROP TABLE "Cuadro_general";

CREATE TABLE "Cuadro_general"
(
"Estado" character varying(20),
"Municipio" character varying(20),
"Aldea" character varying(20),
id_cedula integer NOT NULL,
"Nombre" character varying(20),
"Apellido" character varying(20),
"Genero" "char",
fecha_nacimiento timestamp without time zone,
"Grupo_sanguineo" character varying,
"Nacionalidad" "char",
direccion character varying(150),
"lugar de nacimiento" character varying(20),
telefono_de_hab integer,
telefono_celular integer,
email character varying(50),
"TIT_Medio" character varying,
"NUM_TITULO" integer,
"LIBRO" character varying(20),
"Folio" character varying(5),
"Plan_inter" character varying(20),
"cod_Plantel" integer,
"año_titulo" integer,
t1_ma integer,
"t1_PNNC" integer,
"t1_LC" integer,
"t1_TDA" integer,
"t1_PNAT" integer,
"t1_PLAD" integer,
"T1_IA" integer,
"T1_MA" integer,
"T1_INFO" integer,
"T1_LAPP1" integer,
"T1_CONT1" integer,
"T1_ING1" integer,
"T1_EST1" integer,
"T1_ESP1" integer,
"T1_PROY1" integer,
"T2_LAPP2" integer,
"T2_EST2" integer,
"T2_CONT2" integer,
"T2_FUE" integer,
"T2_PRE" integer,
"T2_COST" integer,
"T2_OS" integer,
"T2_MER1" integer,
"T2_DAR" integer,
"T2_ESP2" integer,
"T2_PROY2" integer,
"T3_FIN" integer,
"T3_ING2" integer,
"T3_MER2" integer,
"T3_AP" integer,
"T3_HSA" integer,
"T3_INMER" integer,
"T3_ISP3" integer,
"T3_PROY3" integer,
"T4_SIST" integer,
"T4_DAR2" integer,
"T4_AUD1" integer,
"T4_GESDE" integer,
"T4_FSP4" integer,
"T4_PROY4" integer,
CONSTRAINT id_cedula_est_key PRIMARY KEY (id_cedula)
)
WITH (
OIDS=FALSE
);
ALTER TABLE "Cuadro_general" OWNER TO postgres;

Comandos de la Base de Datos

-- Table: "Acta_Evaluacion_Definitiva"

-- DROP TABLE "Acta_Evaluacion_Definitiva";

CREATE TABLE "Acta_Evaluacion_Definitiva"
(
"Estado" character varying(20),
"Municipio" character varying(20),
"Aldea" character varying(20),
"Lapso_inicio" date,
lapso_final date,
"Asignatura" character varying(20),
"Trayecto" character varying(20),
trimestre character varying(10),
"Seccion" character varying(10),
"Nombre_del_Profesor" character varying(20),
id_cedula_profesor integer,
"Nombre_del_Preparador" integer,
id_cedula_preparador integer,
id_cedula_estudiante integer NOT NULL,
"Nombre_estudiante" character varying(20),
"Apellido_del_estudiante" character varying(20),
"Calificacion" integer,
"Calificacion_letras" "char",
CONSTRAINT acta_evaluacion_notas_materias_key PRIMARY KEY (id_cedula_estudiante)
)
WITH (
OIDS=FALSE
);
ALTER TABLE "Acta_Evaluacion_Definitiva" OWNER TO postgres;
COMMENT ON TABLE "Acta_Evaluacion_Definitiva" IS 'Notas finales';