What is the significance of the day column and what are the data types of every column ... ? Please let me know. Because I dont find any importance of the day column.
Besides this its the what structure I hopped to be.
Secondly Month Year and empId the trio should be the primary key i.e. composite key.
Also empId should be the foreign key.
now let me know what u r not understanding ? Once this step complete please let me know.