a2yKpUui

1DROP DATABASE IF EXISTS `CentroEstudios`;
2CREATE DATABASE  `CentroEstudios`;
3USE `CentroEstudios`;
4-- MySQL dump 10.13  Distrib 5.6.27, for Win64 (x86_64)
5--
6-- Host: localhost    Database: CentroEstudios
7-- ------------------------------------------------------
8-- Server version	5.6.27
9
10/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
11/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
12/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
13/*!40101 SET NAMES utf8 */;
14/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
15/*!40103 SET TIME_ZONE='+00:00' */;
16/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
17/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
18/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
19/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
20
21--
22-- Table structure for table `alumno`
23--
24
25DROP TABLE IF EXISTS `alumno`;
26/*!40101 SET @saved_cs_client     = @@character_set_client */;
27/*!40101 SET character_set_client = utf8 */;
28CREATE TABLE `alumno` (
29  `dni` varchar(11) NOT NULL,
30  `nombre` varchar(45) DEFAULT NULL,
31  `apellido` varchar(45) DEFAULT NULL,
32  `email` varchar(45) NOT NULL,
33  `telefono` varchar(15) DEFAULT NULL,
34  `direccion` varchar(45) DEFAULT NULL,
35  `fecha_nacimiento` date DEFAULT NULL,
36  PRIMARY KEY (`dni`),
37  UNIQUE KEY `email` (`email`)
38) ENGINE=InnoDB DEFAULT CHARSET=latin1;
39/*!40101 SET character_set_client = @saved_cs_client */;
40
41--
42-- Dumping data for table `alumno`
43--
44
45LOCK TABLES `alumno` WRITE;
46/*!40000 ALTER TABLE `alumno` DISABLE KEYS */;
47INSERT INTO `alumno` VALUES ('25469874X','Ana','Sanz','ana.sanz@gmail.com','989767233','Calle Protugal, 3, Madrid','1987-02-24'),('51423010E','Blanca','Carrillo','blanca.carrillo@yahoo.es','96325487','Calle Hortaleza, 18, Madrid','1982-11-08'),('54123658E','Ana','Puerto','ana.puerto@gmail.com','658956332','Calle Moliner, 17, Madrid','1993-12-08'),('57845214L','Julio','Marcos','julio.marcos@gmail.com','923564767','Calle Altamira, 25, Madrid','1995-12-01'),('58745625J','Carlos','Sevilla','carlos.sevilla@gmail.com','698523654','Calle Gran via, 22, Madrid','1989-05-08'),('65263765T','Curro','Alonso','curro.alonso@gmail.com','956434525','Calle Gran via, 17, Madrid','1993-04-08'),('65742148O','Marta','Gracia','marta.gracia@yahoo.es','698545216','Calle Pintores, 18, Madrid','1988-04-08'),('70584632H','David','Moreno','david.moreno@yahoo.es','698546325','Calle Rosales, 25, Madrid','1991-05-15'),('78741254B','Mario','Blanco','mario.blanco@yahoo.es','612653712','Calle Fuencarral, 2, Madrid','1985-07-28');
48/*!40000 ALTER TABLE `alumno` ENABLE KEYS */;
49UNLOCK TABLES;
50
51--
52-- Table structure for table `alumno_asignatura`
53--
54
55DROP TABLE IF EXISTS `alumno_asignatura`;
56/*!40101 SET @saved_cs_client     = @@character_set_client */;
57/*!40101 SET character_set_client = utf8 */;
58CREATE TABLE `alumno_asignatura` (
59  `alumno` varchar(11) NOT NULL,
60  `asignatura` varchar(11) NOT NULL,
61  `nota_1Ev` int(2) DEFAULT NULL,
62  `nota_2Ev` int(2) DEFAULT NULL,
63  `nota_3Ev` int(2) DEFAULT NULL,
64  `nota_Final` int(2) DEFAULT NULL,
65  PRIMARY KEY (`alumno`,`asignatura`),
66  KEY `asignatura` (`asignatura`),
67  CONSTRAINT `alumno_asignatura_ibfk_1` FOREIGN KEY (`alumno`) REFERENCES `alumno` (`dni`) ON DELETE NO ACTION ON UPDATE CASCADE,
68  CONSTRAINT `alumno_asignatura_ibfk_2` FOREIGN KEY (`asignatura`) REFERENCES `asignatura` (`codigo`) ON DELETE NO ACTION ON UPDATE CASCADE
69) ENGINE=InnoDB DEFAULT CHARSET=latin1;
70/*!40101 SET character_set_client = @saved_cs_client */;
71
72--
73-- Dumping data for table `alumno_asignatura`
74--
75
76LOCK TABLES `alumno_asignatura` WRITE;
77/*!40000 ALTER TABLE `alumno_asignatura` DISABLE KEYS */;
78INSERT INTO `alumno_asignatura` VALUES ('25469874X','DAM_BBDD',4,NULL,NULL,NULL),('25469874X','DAM_FOL',6,NULL,NULL,NULL),('25469874X','DAM_PR',3,NULL,NULL,NULL),('25469874X','DAM_SI',4,NULL,NULL,NULL),('51423010E','AYF_FOL',7,NULL,NULL,NULL),('51423010E','AYF_OYPI',8,NULL,NULL,NULL),('54123658E','DAM_AC',4,NULL,NULL,NULL),('54123658E','DAM_DI',6,NULL,NULL,NULL),('57845214L','DAM_BBDD',7,NULL,NULL,NULL),('57845214L','DAM_FOL',6,NULL,NULL,NULL),('57845214L','DAM_PR',5,NULL,NULL,NULL),('57845214L','DAM_SI',9,NULL,NULL,NULL),('58745625J','DAM_AC',10,NULL,NULL,NULL),('58745625J','DAM_DI',8,NULL,NULL,NULL),('65263765T','DAM_BBDD',5,NULL,NULL,NULL),('65263765T','DAM_FOL',7,NULL,NULL,NULL),('65263765T','DAM_PR',4,NULL,NULL,NULL),('65263765T','DAM_SI',6,NULL,NULL,NULL),('65742148O','DAM_BBDD',9,NULL,NULL,NULL),('65742148O','DAM_FOL',8,NULL,NULL,NULL),('65742148O','DAM_PR',10,NULL,NULL,NULL),('65742148O','DAM_SI',9,NULL,NULL,NULL),('70584632H','DAM_AC',5,NULL,NULL,NULL),('70584632H','DAM_DI',7,NULL,NULL,NULL),('78741254B','AYF_FOL',9,NULL,NULL,NULL),('78741254B','AYF_OYPI',8,NULL,NULL,NULL);
79/*!40000 ALTER TABLE `alumno_asignatura` ENABLE KEYS */;
80UNLOCK TABLES;
81
82--
83-- Table structure for table `asignatura`
84--
85
86DROP TABLE IF EXISTS `asignatura`;
87/*!40101 SET @saved_cs_client     = @@character_set_client */;
88/*!40101 SET character_set_client = utf8 */;
89CREATE TABLE `asignatura` (
90  `codigo` varchar(11) NOT NULL,
91  `nombre` varchar(45) NOT NULL,
92  `descripcion` varchar(90) DEFAULT NULL,
93  `horas` int(4) DEFAULT NULL,
94  `ciclo` varchar(15) NOT NULL,
95  `curso` int(2) DEFAULT NULL,
96  `profesor` varchar(11) DEFAULT NULL,
97  PRIMARY KEY (`codigo`),
98  KEY `profesor` (`profesor`),
99  CONSTRAINT `asignatura_ibfk_1` FOREIGN KEY (`profesor`) REFERENCES `profesor` (`dni`) ON DELETE SET NULL ON UPDATE CASCADE
100) ENGINE=InnoDB DEFAULT CHARSET=latin1;
101/*!40101 SET character_set_client = @saved_cs_client */;
102
103--
104-- Dumping data for table `asignatura`
105--
106
107LOCK TABLES `asignatura` WRITE;
108/*!40000 ALTER TABLE `asignatura` DISABLE KEYS */;
109INSERT INTO `asignatura` VALUES ('AYF_FOL','Formación y orientación laboral','Formación...',150,'AYF',1,'74512365X'),('AYF_OYPI','Ofimática y proceso de la información','Ofimática...',250,'AYF',1,'63254157C'),('DAM_AC','Acceso de datos','Continuación de bases de datos',250,'DAM',2,'63254157C'),('DAM_BBDD','Bases de datos','Introducción a las bases de datos',250,'DAM',1,'63254157C'),('DAM_DI','Desarrollo de interfaces','Interfaces',250,'DAM',2,'45124785A'),('DAM_FOL','Formación y orientación laboral','Formación...',150,'DAM',1,'74512365X'),('DAM_PR','Programación','Introducción a la Programación',300,'DAM',1,'45124785A'),('DAM_SI','Sistemas informáticos','Sistemas...',210,'DAM',1,'45124785A');
110/*!40000 ALTER TABLE `asignatura` ENABLE KEYS */;
111UNLOCK TABLES;
112
113--
114-- Table structure for table `profesor`
115--
116
117DROP TABLE IF EXISTS `profesor`;
118/*!40101 SET @saved_cs_client     = @@character_set_client */;
119/*!40101 SET character_set_client = utf8 */;
120CREATE TABLE `profesor` (
121  `dni` varchar(11) NOT NULL,
122  `nombre` varchar(45) DEFAULT NULL,
123  `apellido` varchar(45) DEFAULT NULL,
124  `email` varchar(45) NOT NULL,
125  `telefono` varchar(15) DEFAULT NULL,
126  `direccion` varchar(45) DEFAULT NULL,
127  PRIMARY KEY (`dni`),
128  UNIQUE KEY `email` (`email`)
129) ENGINE=InnoDB DEFAULT CHARSET=latin1;
130/*!40101 SET character_set_client = @saved_cs_client */;
131
132--
133-- Dumping data for table `profesor`
134--
135
136LOCK TABLES `profesor` WRITE;
137/*!40000 ALTER TABLE `profesor` DISABLE KEYS */;
138INSERT INTO `profesor` VALUES ('45124785A','Jorge','Alnoso','jorge.alonso@ufv.es','965875487','Calle Altamira, 25, Madrid'),('63254157C','Esmeralda','Sanz','esmeralda.sanz@ufv.es','658784578','Calle Protugal, 3, Madrid'),('65847512N','Marta','Potro','marta.potro@ufv.es','652148754','Calle Gran via, 17, Madrid'),('74512365X','Sergio','Prieto','mario.blanco@yahoo.es','965874521','Calle Fuencarral, 2, Madrid');
139/*!40000 ALTER TABLE `profesor` ENABLE KEYS */;
140UNLOCK TABLES;
141/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
142
143/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
144/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
145/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
146/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
147/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
148/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
149/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
150
151-- Dump completed on 2016-03-01  0:31:04