Right Now I design Time & Attendance System.If I have the following entities :Shift (Id,Name,start_time,end_time, ...etc)EX :1,Morning,08:00,16:00WorkSchedule (Id,Name,Type,...etc)EX :1,General,1Where the Type may be(Traditional,Daily Flexible Hours ,Weekly Flexible Hours)And WorkSchedule has detail using Shift like this :Day   Shift      WeekendSa       1           1Su       1           0Mo       1           0Tu       1           0We       1           0Th       1           0Fr       1           1Now If i want to add the Core Hours for the flexible type ,Where should i specify the start time and the end time for the Core Hours? in Shift Entity or in WorkSchedule Entity or something else ?
Where Should I put data related to more than one entity?
design;object oriented;architecture;asp.net;entity framework