CREATE table empleados 
(
id_empleado int PRIMARY KEY AUTO_INCREMENT,
nombre varchar (60)NOT Null,
puesto varchar (60),
fecha_nac date,
hora date,
sueldo date
);

create table clientes
(
id_cliente int PRIMARY KEY AUTO_INCREMENT,
nombre varchar (30),
cel int NOT Null,
dpi int NOT Null,
fecha_nac date
);

CREATE table registros 
(
id_registro INT PRIMARY KEY AUTO_INCREMENT,
entrada int,
salida int,
id_clientes INT,
no_habitacion varchar (10),
tipo_pago int Not Null
);

CREATE table costos 
(
id_costo int PRIMARY KEY AUTO_INCREMENT,
hora date,
dia date,
semana date
);
Insert into empleados
(nombre,puesto,fecha_nac,hora,sueldo)VALUES
("maria","administrador","2001-04-16","15:00",5000),
("juan","secretario","2001-04-16","15:00",5000),
("ana","limpiesa","2001-04-16","15:00",5000),
("monica","amallaves","2001-04-16","15:00",5000),
("fernando","conser","2001-04-16","15:00",5000);