For this i am using 2 tables i.e., Holidays and WorkingHours. We are storing only holidays dates in holidays table. in working hours table 3 columns were there i.e., weekday, starting time, closing time.

we are storing the values like from monday to friday 9 am to 5 pm and for saturday 9 am to 1 pm.

thanks & regards

Venki