Your question was really well laid out, but there were a lot of mistakes in your scripts. Extra braces in table definitions and incorrect column names in the INSERTs compared to the table definition. I've corrected them in the post in case anyone else is looking at it.

The output you have given is impossible for the test data you have supplied. I believe the third insert into EMP_WORK_SCH has not been supplied correctly. I believe it should have read TOM, not JACKY: