Arya kumar, July 08, 2016 - 4:36 pm UTC
Thanq Connor McDonald..
Can You Tell Me why table design is not appropriate,This is a table which describe employees attendence,So we have given Day1..Day31 as column names with Employee code,Year,Month fields.
where each day is represented as day with leave codes as its value
So Can You Suggest me the better way to do the design
July 09, 2016 - 2:00 am UTC
It opens up holes for data inconsistency.
eg
Mth=Feb
Day31=10
So...when did Feb suddenly have 31 days ?
I'd be more inclined just to have
emp_code
measurement_date
It easy to pivot that into columns, and having a date column takes care of all of the date validation etc.