-- MariaDB dump 10.19 Distrib 10.4.22-MariaDB, for Win64 (AMD64) -- -- Host: localhost Database: institucion -- ------------------------------------------------------ -- Server version 10.4.22-MariaDB /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Current Database: `institucion` -- CREATE DATABASE /*!32312 IF NOT EXISTS*/ `institucion` /*!40100 DEFAULT CHARACTER SET latin1 */; USE `institucion`; -- -- Table structure for table `acudiente` -- DROP TABLE IF EXISTS `acudiente`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `acudiente` ( `codacud` char(3) NOT NULL, `nombreacud` char(40) NOT NULL, `direccion` char(45) NOT NULL, `telefono` char(7) NOT NULL, `email` char(50) NOT NULL, PRIMARY KEY (`codacud`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `acudiente` -- LOCK TABLES `acudiente` WRITE; /*!40000 ALTER TABLE `acudiente` DISABLE KEYS */; INSERT INTO `acudiente` VALUES ('001','ACEVEDO CARDONA ESTEBAN','Barrio la pradera','5846069','estebancardona@gmail.com'),('002','AGUDELO MANCO DIANA PATRICIA','Barrio rosaleda','5882104','dianapatricia@gmail.com'),('003','ZAPATA VALENCIA JORGE','Barrio Aragon','5841998','jorgezapata@gmail.com'),('004','VELASQUEZ CANO JENNY ASTRID','Barrio la pradera','2791469','yennyvelasquez@gmail.com'),('005','POSADA VASCO ANA','Urbanizacion compartir','2868617','anaposada@gmail.com'),('006','ORTIZ PUERTA INDIRA','Urbanizacion Ciudadela Prado','5841497','indiraortiz@gmail.com'),('007','QUINTERO MENESES ADRIANA MARIA','Barrio Sangabriel','5840570','adrianaquintero@gmail.com'),('008','MONTOYA RIVERA EDILMA','Barrio la pradera','3767289','edilmamontoya@gmail.com'),('009','LOPERA MONSALVE FERNANDO ALONSO','Barrio el limonar1','5709957','fernandolopera@gmail.com'),('010','HENAO RIOS DORA EMILSE','Barrio el limonar2','2866222','dora henao@gmail.com'); /*!40000 ALTER TABLE `acudiente` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `estuacu` -- DROP TABLE IF EXISTS `estuacu`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `estuacu` ( `codest` char(6) NOT NULL, `codacud` char(3) NOT NULL, KEY `codest` (`codest`), KEY `codacud` (`codacud`), CONSTRAINT `estuacu_ibfk_1` FOREIGN KEY (`codest`) REFERENCES `estudiante` (`codest`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `estuacu_ibfk_2` FOREIGN KEY (`codacud`) REFERENCES `acudiente` (`codacud`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `estuacu` -- LOCK TABLES `estuacu` WRITE; /*!40000 ALTER TABLE `estuacu` DISABLE KEYS */; INSERT INTO `estuacu` VALUES ('000001','001'),('000002','002'),('000003','003'),('000004','004'),('000005','005'),('000006','006'),('000007','007'),('000008','008'),('000009','009'),('000010','010'),('000011','001'),('000012','001'); /*!40000 ALTER TABLE `estuacu` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `estudiante` -- DROP TABLE IF EXISTS `estudiante`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `estudiante` ( `codest` char(6) NOT NULL, `nombrest` char(40) NOT NULL, `direccion` char(45) NOT NULL, `telefono` char(7) NOT NULL, `email` char(50) NOT NULL, PRIMARY KEY (`codest`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `estudiante` -- LOCK TABLES `estudiante` WRITE; /*!40000 ALTER TABLE `estudiante` DISABLE KEYS */; INSERT INTO `estudiante` VALUES ('000001','ACEVEDO BURITICA JUAN ESTEBAN','Barrio la pradera','5846069','juanestebanacevedo@gmail.com'),('000002','ALVAREZ AGUDELO ESTEBAN','Barrio rosaleda','5882104','estebanalvarez@gmail.com'),('000003','ZAPATA CAMPIÑO ISABEL','Barrio Aragon','5841998','zapataisabel@gmail.com'),('000004','VALLE VELASQUEZ SOFIA','Barrio la pradera','2791469','sofiavelasquez@gmail.com'),('000005','MORENO POSADA DIEGO ALEJANDRO','Urbanizacion Compartir','2868617','diegomoreno@gmail.com'),('000006','ALZATE ORTIZ JORGE MARIO','Urbanizacion Ciudadela prado','5841497','marioalza@gmail.com'),('000007','ZAPATA QUINTERO JOSE MARIA','Sangabriel','5840570','josezapata@gmail.com'),('000008','MONTOYA MONTOYA ALEJANDRO','Barrio la pradera','3767289','alejandromontoya@gmail.com'),('000009','LOPERA CARTAGENA LUISA FERNANDA','Barrio el limonar1','5709957','luisalopera@gmail.com'),('000010','JARAMILLO HENAO JORGE LUIS','Barrio el limonar2','2866222','josejaramillo@gmail.com'),('000011','ALVAREZ AGUDELO LUNA','Barrio rosaleda','5882104','lunaalvarez@gmail.com'),('000012','ALVAREZ AGUDELO XAVIER','Barrio rosaleda','5882104','xavieralvarez@gmail.com'); /*!40000 ALTER TABLE `estudiante` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `estudiantemat` -- DROP TABLE IF EXISTS `estudiantemat`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `estudiantemat` ( `codest` char(6) NOT NULL, `codmat` char(2) NOT NULL, KEY `codest` (`codest`), KEY `codmat` (`codmat`), CONSTRAINT `estudiantemat_ibfk_1` FOREIGN KEY (`codest`) REFERENCES `estudiante` (`codest`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `estudiantemat_ibfk_2` FOREIGN KEY (`codmat`) REFERENCES `materia` (`codmat`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `estudiantemat` -- LOCK TABLES `estudiantemat` WRITE; /*!40000 ALTER TABLE `estudiantemat` DISABLE KEYS */; INSERT INTO `estudiantemat` VALUES ('000001','01'),('000001','02'),('000001','03'),('000001','04'),('000001','05'),('000001','06'),('000001','07'),('000001','08'),('000001','09'),('000001','10'),('000001','11'),('000001','12'),('000001','13'),('000001','14'),('000001','15'),('000002','01'),('000002','02'),('000002','03'),('000002','04'),('000002','05'),('000002','06'),('000002','07'),('000002','08'),('000002','09'),('000002','10'),('000002','11'),('000002','12'),('000002','13'),('000002','14'),('000002','15'),('000003','01'),('000003','02'),('000003','03'),('000003','04'),('000003','05'),('000003','06'),('000003','07'),('000003','08'),('000003','09'),('000003','10'),('000003','11'),('000003','12'),('000003','13'),('000003','14'),('000003','15'),('000004','01'),('000004','02'),('000004','03'),('000004','04'),('000004','05'),('000004','06'),('000004','07'),('000004','08'),('000004','09'),('000004','10'),('000004','11'),('000004','12'),('000004','13'),('000004','14'),('000004','15'),('000005','01'),('000005','02'),('000005','03'),('000005','04'),('000005','05'),('000005','06'),('000005','07'),('000005','08'),('000005','09'),('000005','10'),('000005','11'),('000005','12'),('000005','13'),('000005','14'),('000005','15'),('000006','01'),('000006','02'),('000006','03'),('000006','04'),('000006','05'),('000006','06'),('000006','07'),('000006','08'),('000006','09'),('000006','10'),('000006','11'),('000006','12'),('000006','13'),('000006','14'),('000006','15'); /*!40000 ALTER TABLE `estudiantemat` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `materia` -- DROP TABLE IF EXISTS `materia`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `materia` ( `codmat` char(2) NOT NULL, `nombremat` char(30) NOT NULL, PRIMARY KEY (`codmat`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `materia` -- LOCK TABLES `materia` WRITE; /*!40000 ALTER TABLE `materia` DISABLE KEYS */; INSERT INTO `materia` VALUES ('01','ESPAÑOL'),('02','LECTOESCRITURA'),('03','MATEMATICAS'),('04','CIENCIAS NATURALES'),('05','INVESTIGACION'),('06','FISICA'),('07','FILOSOFIA'),('08','EDUCACION FISICA'),('09','ETICA'),('10','ARTISTICA'),('11','TECNOLOGIA'),('12','INFORMATICA'),('13','RELIGION'),('14','SOCIALES'),('15','INGLES'); /*!40000 ALTER TABLE `materia` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `matprof` -- DROP TABLE IF EXISTS `matprof`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `matprof` ( `codmat` char(2) NOT NULL, `codprof` char(3) NOT NULL, KEY `codmat` (`codmat`), KEY `codprof` (`codprof`), CONSTRAINT `matprof_ibfk_1` FOREIGN KEY (`codmat`) REFERENCES `materia` (`codmat`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `matprof_ibfk_2` FOREIGN KEY (`codprof`) REFERENCES `profesor` (`codprof`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `matprof` -- LOCK TABLES `matprof` WRITE; /*!40000 ALTER TABLE `matprof` DISABLE KEYS */; INSERT INTO `matprof` VALUES ('01','005'),('02','007'),('03','009'),('04','003'),('05','003'),('06','003'),('07','001'),('08','010'),('09','006'),('10','004'),('11','002'),('12','002'),('13','006'),('14','007'),('15','008'); /*!40000 ALTER TABLE `matprof` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `profesor` -- DROP TABLE IF EXISTS `profesor`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `profesor` ( `codprof` char(3) NOT NULL, `nombreprof` char(40) NOT NULL, `direccion` char(45) NOT NULL, `telefono` char(7) NOT NULL, `email` char(50) NOT NULL, PRIMARY KEY (`codprof`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `profesor` -- LOCK TABLES `profesor` WRITE; /*!40000 ALTER TABLE `profesor` DISABLE KEYS */; INSERT INTO `profesor` VALUES ('001','CIFUENTES MESA MILEIDI MARIA','Barrio la pradera','2345679','mileidijearm@gmail.com'),('002','CUADRADO PEREZ ADRID JOSE','Barrio la paz','8909000','adridjearm@gmail.com'),('003','DUQUE RESTREPO ESTER LUCIA','Barrio san juan','4123908','esterjearm@gmail.com'),('004','GUIRALES MAURICIO','Barrio san jose','4150856','mauriciojearm@gmail.com'),('005','VERA DAZA MARIA ELENA','Urbanizacion madera','2567834','mariajearm@gmail.com'),('006','PALACIO TOMAS FELIPE','Urbanizacion Herreria','5678888','tomasjearm@gmail.com'),('007','MOSUERA OSORIO MARYETH','Barrio la candelaria','4567765','maryethjearm@gmail.com'),('008','ARBOLEDA VARGAS MARIA OFELIA','Barrio Obrero','2534543','ofeliajearm@gmail.com'),('009','MOSCOTE MARULANDA YANET MARIA','Barrio Rosales','5541232','yanetjearm@gmail.com'),('010','MACIAS EDGAR ALBERTO','Urbanizacion Madera','5690012','edgarjearm@gmail.com'); /*!40000 ALTER TABLE `profesor` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2022-04-24 19:33:07