CREACION DE LA BASE DE DATOS Y LAS TABLAS

/*---------------------------CREACION DE LA BASE DE DATOS Y LAS TABLAS----------------------------*/

create database EMPRESA;

use EMPRESA;

create table Centro
(
id_Centro int not null primary key,
nombre_Centro varchar(70) not null,
direccion_Centro varchar(70) not null

)engine=innodb;


create table Departamento
(
id_Depto int not nullprimary key,
nombre_Depto varchar(45) not null,
director_Depto int not null,
tipoDirector_Depto char not null,
presupuesto_Depto decimal not null,
depende_Depto int not null,
centro_idCentro int,

index(centro_idCentro),
foreign key(centro_idCentro)
references Centro (id_Centro) on update cascade on delete restrict

)engine=innodb;



create tableEmpleado
(
id_Emp int not null primary key,
nombre_Emp varchar(45) not null,
fNto_Emp date not null,
fIng_Emp date not null,
salario_Emp decimal not null,
numHijos_Emp smallint not null,
comision_Emp decimal not null,
Departamento_idDepto int not null,

index(Departamento_idDepto),
foreign key(Departamento_idDepto) references Departamento (id_Depto)
on updatecascade on delete restrict

)engine=innodb;

/*-----------------------------------------------------------------------------------------------*/

Show tables;


/*-------------------------------INSERCION DE DATOS EN LAS TABLAS--------------------------------*/


insert into centro values (10,'Sede Central','Calle Alcala 820 Madrid');
insert into centro values (20,'Relacion ConClientes','Calle Atocha 405 Madrid');
insert into centro values (50,'Almacen','Calle Lavapies 520 Madrid');


insert into Departamento values (100,'Direccion General',260,'F',120,' ',10);
insert into Departamento values (110,'Direccion Comercial',180,'P',150,'100',20);
insert into Departamento values (111,'Sector Industrial',180,'F',110,110,20);
insert into Departamento values (112,'SectorServicios',270,'P',90,110,20);
insert into Departamento values (120,'Organizacion',150,'F',30,100,10);
insert into Departamento values (121,'Personal',150,'P',20,120,10);
insert into Departamento values (122,'Proceso de Datos',350,'P',60,120,10);
insert into Departamento values (130,'Finanzas',310,'P',20,100,10);
insert into Departamento values (123,'Personal Contratado',190,'F',20,121,null );


insert into Empleado values(110,'Pons Cesar','1930-02-15','1950-02-15',3100,3,0,121);
insert into Empleado values(120,'Lasa Mario','1948-10-01','1968-10-01',3500,1,1100,112);
insert into Empleado values(130,'Terol Luciano','1949-02-10','1969-02-10',2900,2,1100,112);
insert into Empleado values(150,'Perez Julio','1928-01-15','1948-01-15',4400,0,0,121);
insert into Empleadovalues(160,'Aguirre Aurelio','1948-11-11','1968-11-11',3100,2,1100,111);
insert into Empleado values(180,'Perez Marcos','1936-03-18','1956-03-18',4800,2,500,110);
insert into Empleado values(190,'Vega Juliana','1942-02-11','1962-02-11',3000,4,0,121);
insert into Empleado values(210,'Galvez Pilar','1939-01-22','1959-01-22',3800,2,0,100);
insert into Empleado values(240,'SanzLavinia','1946-02-24','1966-02-24',2800,3,1000,111);
insert into Empleado values(250,'Alba Adriana','1926-03-01','1946-03-01',4550,0,0,100);
insert into Empleado values(260,'Lopez Antonio','1948-07-12','1968-07-12',7200,6,0,100);
insert into Empleado values(270,'Garcia Octavio','1946-09-10','1966-09-10',3800,3,800,112);
insert into Empleado values(280,'Flor Dorotea','1951-10-08','1971-10-08',2900,6,0,130);
insertinto Empleado values(285,'Polo Otilia','1948-02-15','1968-02-15',380,0,0,122);
insert into Empleado values(290,'Gil Gloria','1948-02-14','1968-02-14',2700,3,0,120);
insert into Empleado values(310,'Garcia Augusto','1951-01-15','1971-01-15',4200,0,0,130);
insert into Empleado values(320,'Sanz Cornelio','1958-02-05','1978-02-05',4050,2,0,122);
insert into Empleado values(330,'Diaz...