Test data for the examples:

Create data (SQL code):

create class employee   
 (name, string,
birthdate date,
project_time time,
checkin_time timestamp,
checkout_time timestamp);

insert into employee(name, birthdate, checkin_time, checkout_time)
values ('Ann Kay', '01/01/1970', '02/01/1997 8:10:10 am', '02/01/1997 4:30:30 pm');
insert into employee(name, birthdate, checkin_time, checkout_time)
values ('Bob May', '02/05/1970', '02/01/1997 8:20:20 am', '02/01/1997 4:50:30 pm');
insert into employee(name, birthdate, checkin_time, checkout_time)
values ('Ray Way', '02/15/1970', '02/01/1997 8:50:10 am', '02/01/1997 5:10:00 pm');
insert into employee(name, birthdate, checkin_time, checkout_time)
values ('Kat Day', '04/20/1971', '02/01/1997 9:10:20 am', '02/01/1997 5:20:00 pm');
insert into employee(name, birthdate, checkin_time, checkout_time)
values ('Mat Hay', '05/10/1972', '02/01/1997 9:20:30 am', '02/01/1997 5:30:30 pm');
insert into employee(name, birthdate, project_time)
values ('Hat Pay', '05/20/1972', '12:00:30 pm');
insert into employee(name, project_time)
values ('Pat Tin', '11:00:30 am'); 



Employee Table:



Name	  Birthdate   Project_time Checkin_time		Checkout_time	
STRING     DATE	         TIME	   TIMESTAMP		TIMESTAMP		     	

Ann Kay 01/01/1970    Null 	02/01/1997 8:10:10 am 02/01/1997 4:30:30 pm 
Bob May 02/05/1970    Null	02/01/1997 8:20:20 am 02/01/1997 4:50:30 pm 
Ray Way 02/15/1970    Null	02/01/1997 8:50:10 am 02/01/1997 5:10:00 pm 
Kat Day 04/20/1971    Null	02/01/1997 9:10:20 am 02/01/1997 5:20:00 pm 
Mat Hay 05/10/1972    Null 	02/01/1997 9:20:30 am 02/01/1997 5:30:30 pm 
Hat Pay 05/20/1972   12:00:30 pm     Null		   Null                                     
Pat Tin    Null      11:00:30 am     Null                  Null                                      
