Bd Database Hospital.txt 2l3j6h

CREATE DATABASE HOSPITAL_ADSI; USE HOSPITAL_ADSI; CREATE TABLE EMP(Emp_No INT(4) PRIMARY KEY, Apellido VARCHAR(50), Oficio VARCHAR(50), Dir INT(4), Fecha_Alt DAtETIME, Salario INT(4), Comision INT(4), Dept_No INT(4)); ALTER TABLE Emp MODIFY COLUMN Fecha_Alt DATETIME; CREATE TABLE Dept (Dept_No INT(4), DNombre VARCHAR(50) , Loc VARCHAR(50) , CONSTRAINT PK_Dept PRIMARY KEY(Dept_No)); ALTER TABLE Emp ADD FOREIGN KEY (Dept_No) REFERENCES Dept(Dept_No); CREATE TABLE Hospital(Hospital_Cod INT, Nombre VARCHAR(50) NULL, Direccion VARCHAR(50) NULL, Telefono VARCHAR(50) NULL, Num_Cama INT NULL,CONSTRAINT PK_Hospital PRIMARY KEY(Hospital_Cod)); CREATE TABLE Doctor (Hospital_Cod INT(4), Doctor_No INT(4), Apellido VARCHAR(50), Especialidad VARCHAR(50), FOREIGN KEY (Hospital_Cod) REFERENCES Hospital(Hospital_Cod)); CREATE TABLE Sala (Hospital_Cod INT(4), Sala_Cod INT(4), Nombre VARCHAR(50), Num_Cama INT(4) , CONSTRAINT FK_Sala_Hospital FOREIGN KEY (Hospital_Cod) REFERENCES Hospital(Hospital_Cod)); CREATE TABLE Plantilla (Hospital_Cod INT(4), Sala_Cod INT(4), Empleado_No INT(4), Apellido VARCHAR(50), Funcion VARCHAR(50), T VARCHAR(50), Salario int(4) , FOREIGN KEY (Hospital_Cod) REFERENCES Hospital(Hospital_Cod));

CREATE TABLE Enfermo (Inscripcion INT(4), Apellido VARCHAR(50), Direccion VARCHAR(50), Fecha_Nac DATE, S VARCHAR(50), NSS INT(4));

INSERT INTO Dept VALUES( 10,"CONTABILIDAD","ELCHE"); INSERT INTO Dept VALUES( 20,"INVESTIGACION","MADRID"); INSERT INTO Dept VALUES( 30,"VENTAS","BARCELONA"); INSERT INTO Dept VALUES( 40,"PRODUCCION","SALAMANCA"); INSERT INTO Emp VALUES( 7369,"SANCHEZ","EMPLEADO",7902,"1980-12-17 00:00:00",104000,0,20); INSERT INTO Emp VALUES( 7499,"ARROYO","VENDEDOR",7698,"1981-02-22 00:00:00",208000,39000,30);

INSERT INTO Emp VALUES( 7521,"SALA","VENDEDOR",7689,"1981-02-22 00:00:00",162500,65000,30); INSERT INTO Emp VALUES( 7566,"JIMENEZ","DIRECTOR",7839,"1981-04-02 00:00:00",386750,0,20); INSERT INTO Emp VALUES( 7654,"MARTIN","VENDEDOR",7698,"1981-09-28 00:00:00",182000,182000,30);

INSERT INTO Emp VALUES( 7698,"NEGRO","DIRECTOR",7839,"1981-05-01 00:00:00",370500,0,30); INSERT INTO Emp VALUES( 7782,"CEREZO","DIRECTOR",7839,"1981-06-09 00:00:00",318500,0,10); INSERT INTO Emp VALUES( 7788,"NINO","ANALISTA",7566,"1987-03-30 00:00:00",390000,0,20); INSERT INTO Emp VALUES(

7839,"REY","PRESIDENTE",0,"1981-11-17 00:00:00",650000,0,10); INSERT INTO Emp VALUES( 7844,"TOVAR","VENDEDOR",7698,"1981-09-08 00:00:00",195000,0,30); INSERT INTO Emp VALUES( 7876,"ALONSO","EMPLEADO",7788,"1987-05-03 00:00:00",143000,0,20); INSERT INTO Emp VALUES( 7900,"JIMENO","EMPLEADO",7698,"1981-12-03 00:00:00",123500,0,30); INSERT INTO Emp VALUES( 7902,"FERNANDEZ","ANALISTA",7566,"1981-12-03 00:00:00",390000,0,20);

INSERT INTO Emp VALUES( 7934,"MU�OZ","EMPLEADO",7782,"1982-06-23 00:00:00",169000,0,10); INSERT INTO Emp VALUES( 7119,"SERRA","DIRECTOR",7839,"1983-11-19 00:00:00",225000,39000,20); INSERT INTO Emp VALUES( 7322,"GARCIA","EMPLEADO",7119,"1982-10-12 00:00:00",129000,0,20); INSERT INTO Hospital VALUES( 19,"PROVINCIAL","O'Donell 50","964-4256",502); INSERT INTO Hospital VALUES( 18,"GENERAL","Atocha s/n","595-3111",987); INSERT INTO Hospital VALUES( 22,"LA PAZ","Castellana 1000","923-5411",412); INSERT INTO Hospital VALUES( 45,"SAN CARLOS","Ciundad Universitaria","597-1500",845); INSERT INTO Sala VALUES( 22,1,"Recuperacion",10); INSERT INTO Sala VALUES( 45,1,"Recuperacion",15); INSERT INTO Sala VALUES( 22,2,"Maternidad",34); INSERT INTO Sala VALUES( 45,2,"maternidad",24); INSERT INTO Sala VALUES(

19,3,"Cuidados Intensivos",21); INSERT INTO Sala VALUES( 18,3,"Cuidados Intensivos",10); INSERT INTO Sala VALUES( 18,4,"Cardiologia",53); INSERT INTO Sala VALUES( 45,4,"Cardiologia",55); INSERT INTO Sala VALUES( 19,6,"Psiquiatricos",67); INSERT INTO Sala VALUES( 22,6,"Psiquiatricos",118); INSERT INTO Plantilla VALUES( 22,6,1009,"Higueras D.","Enfermera","T",200500); INSERT INTO Plantilla VALUES( 45,4,1280,"Amigo R.","Interino","N",221000); INSERT INTO Plantilla VALUES( 19,6,3106,"Hernandez","Enfermera","T",275000); INSERT INTO Plantilla VALUES( 19,6,3754,"Diaz B.","Enfermera","T",226200); INSERT INTO Plantilla VALUES( 22,1,6065,"Rivera G.","Enfermera","N",162600); INSERT INTO Plantilla VALUES( 18,4,6357,"Karplus W.","Interno","T",337900); INSERT INTO Plantilla VALUES( 22,1,7379,"Carlos R.","Enfermera","T",211900);

INSERT INTO Plantilla VALUES( 22,6,8422,"Bocina G.","Enfermero","M",183800); INSERT INTO Plantilla VALUES( 45,1,8526,"Frank H.","Enfermera","T",252200); INSERT INTO Plantilla VALUES( 22,2,9901,"Nu�es C.","Interino","M",221000); INSERT INTO Doctor VALUES(

22,386,"Cabeza D.","Psiqiatria"); INSERT INTO Doctor VALUES( 22,398,"Best D.","Urologia"); INSERT INTO Doctor VALUES( 19,435,"Lopez A.","Cardiologia"); INSERT INTO Doctor VALUES( 22,453,"Galo D.","Pediatra"); INSERT INTO Doctor VALUES( 45,522,"Adams C.","Neurologia"); INSERT INTO Doctor VALUES( 18,585,"Miller G.","Ginecologia"); INSERT INTO Doctor VALUES( 45,607,"Chuki P.","Pediatra"); INSERT INTO Doctor VALUES( 18,982,"Cajal R.","Cardiologia"); INSERT INTO Enfermo VALUES( 10995,"Laguia M.","Goya 20","1956-05-16","M",280862422); INSERT INTO Enfermo VALUES( 14024,"Fern�ndez M.","Recoletos 50","1960-05-21","F",284991452); INSERT INTO Enfermo VALUES( 18004,"Serrano V.","Alcala 12","1967-06-23","F",284991452); INSERT INTO Enfermo VALUES( 36658,"Domin S.","Mayor 71","1942-01-01","M",160654471); INSERT INTO Enfermo VALUES( 38702,"Neal R.","Orense 11","1940-06-18","F",380010217); INSERT INTO Enfermo VALUES( 39217,"Cervantes M.","Peron 38","1952-02-29","M",440249390); INSERT INTO Enfermo VALUES( 59076,"Miller B.","Lopez de Hoyos 2","1945-09-16","F",311969044); INSERT INTO Enfermo VALUES( 63827,"Ruiz P.","Equerdo 103","1980-12-26","M",100973253); INSERT INTO Enfermo VALUES( 64823,"Fraiser A.","Soto 3","1980-07-10","F",285201776); INSERT INTO Enfermo VALUES( 74835,"Benitez E.","Argentina","1957-10-05","M",154811767); SELECT*FROM EMP;