3Uw8v4AE

1DROP TABLE IF EXISTS `hospitales`;
2CREATE TABLE `hospitales` (
3  `cod_hospital` 	integer 	not null,
4  `nombre` 		varchar(50),
5  `direccion` 		varchar(60),
6  `num_plazas` 		integer,
7  	PRIMARY KEY  	(`cod_hospital`)
8)ENGINE=InnoDB DEFAULT CHARSET=utf8;
9
10insert into hospitales values(1,'Rafael Méndez','Gran Vía, 7',250);
11insert into hospitales values(2,'Reina Sofía','Junterones, 5',225);
12insert into hospitales values(3,'Príncipe Asturias','Avenida Colón',150);
13insert into hospitales values(4,'Virgen de la Arrixaca','Avenida Juan Carlos I',250);
14
15DROP TABLE IF EXISTS `medicos`;
16CREATE TABLE `medicos` (
17  `dni` 		varchar(11) 	NOT NULL,
18  `apellidos` 		varchar(50) 	default NULL,
19  `cod_hospital` 	integer,
20  `especialidad` 	varchar(50) 	default NULL,
21  	PRIMARY KEY  (`dni`),
22	FOREIGN KEY(`cod_hospital`) REFERENCES `hospitales`(`cod_hospital`)
23)ENGINE=InnoDB DEFAULT CHARSET=utf8;
24
25
26insert into medicos values(66655544,'Castillo Montes, Pedro',1,'PSIQUIATRA');
27insert into medicos values(22233322,'Tristán García, Ana',2,'CIRUJANO');
28insert into medicos values(33222111,'Mesa del Castillo, Juan',4,'DERMATOLOGO');
29insert into medicos values(22233333,'Martínez Molina, Andrés',2,'CIRUJANO');
30insert into medicos values(22233311,'Martínez Molina, Gloria',4,'PSIQUIATRA');