Bases De Datos
create table Empleado
(
Empl_Id numeric not null primary key,
Empl_Cedula bigint not null,
Empl_Nombre nvarchar (40),
Empl_Apellido1 nvarchar (40) not null,
Empl_Apellido2 nvarchar (40) ,
Empl_Telefono bigint,
Empl_Celular bigint,
Empl_Direccion nvarchar (25),
Empl_FechaNac datetime,
Empl_FechaIngreso datetime,
Secci_Id numeric notnull,--FALTA
Turn_Id numeric not null,--FALTA-hice 13 registros de turnos y rellene los campos en estas tablas.
Carg_Id numeric not null--FALTA
);
insert into Empleado values (400,41235689,'Juan Pablo','Angel','Vargas',7895612,3102022442,'Av 5 # 4-99','01-01-1990 2:45:00','11-03-2010 8:00:00',,1501,);
insert into Empleado values(401,12457896,'Lina','Correa','Deantonio',4561237,3152442154,'Cll 65 # 99-03','15-11-1985 5:55:00','15-12-2010 8:00:00',,1502,);
insert into Empleado values (402,32659817,'Pedro','Manrrique','Huerfano',7156231,3102356897,'Trans 3 # 68-9','31-05-1980 1:00:00','11-09-2010 8:00:00',,1503,);
insert into Empleado values (403,42538795,'Carolina','Burgos','Beltran',6689231, 3112036598,'Cll 35 # 8-43','19-03-1989 11:45:00','15-05-2010 8:00:00',1504,,);
insertinto Empleado values (404,12459632,'Adriana','Vergara','Vergara',4235617,3202241142,'Av 15 # 4-99','31-01-1983 6:45:00','01-01-2010 8:00:00',,1505,);
insert into Empleado values (405,89562314,'Andres','Velasco','Ortiz',7778899,3212000369,'Diag 5 # 99','01-11-1990 2:45:00','15-01-2010 8:00:00',,1506,);
insert into Empleado values (406,78965214,'Cindy','Aristizabal','Gomez',6789562,3152022442,'Av 8# 3-19','11-09-1990 4:45:00','20-01-2011 8:00:00',,1507,);
insert into Empleado values (407,12124538,'Jennifer','Pavas','Correa',7894561,3133022442,'Cll 15 # 41-10','16-06-1991 7:50:00','01-04-2011 8:00:00',,1508,);
insert into Empleado values (408,78459612,'Camilo','Contreras','',5623471,3180244211,'Av 19 # 10-99','17-04-1988 9:45:00','15-06-2010 8:00:00',,1509,);
insert into Empleado values(409,23568974,'Juan Camilo','Duarte','Jimenez',2022696,3126597845,'Cll 5 # 9-49','21-02-1990 2:45:00','01-07-2010 8:00:00',,1510,);
insert into Empleado values (410,45548721,'Cristian','Martinez','Galindo',6961122,3169865321,'Cll 8 # 9-49','21-05-1990 9:45:00','01-03-2010 8:00:00',,1511,);
insert into Empleado values (411,32659874,'Lucas','Herrera','Garzon',955116,3132345781,'Cll 15 #49-3','11-07-1989 2:00:00','07-07-2010 8:00:00',,1512,);
insert into Empleado values (412,12456814,'Manuel','Paez','Gonzalez',7896532,3251234567,'Av chile # 1-49','31-07-1982 7:55:00','31-07-2010 8:00:00',,1513,);
insert into Empleado values (413,32659872,'Daniel','Daza','Ruiz',3132035724,3214567891,'Diag 12 # 8-19','21-02-1990 2:45:00','15-10-2010 8:00:00',,,);
insert into Empleado values(414,32659896,'Jeisson','Quintero','Daza',5555555,3102356741,'Cll 115 # 81-45','10-04-1991 9:45:00','12-01-2011 8:00:00',,,);
insert into Empleado values (415,10235605,'Alejandro','Vargas','Betancourt',2305821,3162356417,'Cll 100 # 11-25','20-05-1990 5:00:00','30-06-2010 8:00:00',,,);
insert into Empleado values (416,12356890,'Santiago','Correa','Cortes',7763411,3167286617,'Cll 56 A # 11-25','20-05-19905:00:00','30-06-2010 8:00:00',,,);
insert into Empleado values (417,13024578,'Mauricio','Rodriguez','Rodriguez',8794561,3223654781,'Av 68 # 26-05','20-02-1985 6:00:00','15-01-2010 8:00:00',,,);
insert into Empleado values (418,20358745,'Cristian Camilo','Torres','Sanabria',7845121,3213000748,'Trans 95 # 80-10','10-08-1980 1:00:00','12-10-2010 8:00:00',,,);
insert into Empleado values(419,10235689,'Sebastian','Hincapie','Gallo',2154877,3121121222,'Cll 95 # 61-55','22-07-1985 7:00:00','15-01-2010 8:00:00',,,);
insert into Empleado values (420,15269874,'Jessica','Betancourt','Giraldo',7962615,3113113114,'Cll 65 A # 71B-55','30-12-1986 6:00:00','05-07-2010 8:00:00',,,);
insert into Empleado values (421,32659874,'Camila','Paez','Arias',7845962,3102345781,'Diag 100 # 10-23','11-03-1990...
Regístrate para leer el documento completo.