Hi L' Eomot Inversé,

One thing you might have missed OR may be i could not understand in your reply is the flexibility for future enhancement.

For example:

In first approach, if one need to add a new column in future DOT which was missed in initial design then that needs lots of changes in DB and application as well, atleast upto some extent.

However, in Second approach, having an "Employee key dates" column with "type of date" column could give lots of flexibility. so if DOT was missed in initial design then by adding the data in type table will allow you to save a new type of information without any structure change? This will also give more control on data growth.

Jeff, I could not understand your point about "How about durability and history?" Do you mean what i have tried to explain in second approach?

SO which one do you recommend, more specially from performance point of view and flexibility for future enhancement? Please tell any any pros and cons.

Thanks and Regards.