silentwolf
Active member
- Local time
- Today, 04:03
- Joined
- Jun 12, 2009
- Messages
- 575
Hi guys,
just wondering if someone had already something similar to get me on the right track with following.
I create a small Database for my little sis she works with kids in a ChildCareCentre.
The Datastructur is attached what I got at present.
Tables:
Employees,
Employment,
EmploymentPlan,
Plan,
Weekdays,
Children,
ChildCare,
Table Infos:
Employees: Employee Data
Employment: Each Employee could have one or more Employments meaning he or she could change the weeklyhours for a given periode.
EmploymentPlan: An Employee could be working on Monday, and Friday from 7:00 to 12:00, on Tuesday from 7:00 to 13:00 and on Wednesday and Thursday from 8:00 to 13:00 for example.
I am getting that Times from the Plan Table
The same applies to Children.
A Child might be in Care on Monday and Tuesday from 7:00 to 12:00 on Wednesday from 7:00 to 13:00.
That might change in some other periods.
Maybe from 1/6/2022 to 31/10/22 Monday and Thuesday from 7:00 to 13:00 and Wednesday from 7:00 to 15:00
and the same kid is from 1/11/22 till the 30/10/2022. Only on Wednesday from 7:00 to 15:00.
In the Plan Table there is a boolean field HasLunch includet.
so if the Plan is from 7:00 to 12:00 there is no lunch.
All other times longer then 12:00 are with lunch.
So I guess so far the Structure is able to sort that out ok.
Now the things I am not sure about:
First I like to build a Calendar for a period of time to see how many kids having lunch at a given periode.
Create a Calendar to see how many Employees are available for that given periode to look after the kids.
Meaning that there are always incomming request for new kids or request if a child could be in a different periode attend different times.
So depanding on how many kids having lunch I need to plan times where the employees can take their own lunch.
So the kids have lunch between 12:00 to 13:00.
If there are more kids on wednesday for example the Employee need to take their lunch at 11:00 to 12: or from 13:00 to 14:00.
I got a table Breaks where different times are entered where someone could take lunchbreaks.
But I am not sure what table I would still need to be able to manage those breaks correctly.
So I was thinking of insert Data Into tblDates I called it for a given periode.
So would I need to create as said a Calendar and from each Day that I can adjust lunchbreaks for the Employees who are at that day working.
Hope that makes sense?
Maybe someone could help me for gettint that achived )
Many thanks
just wondering if someone had already something similar to get me on the right track with following.
I create a small Database for my little sis she works with kids in a ChildCareCentre.
The Datastructur is attached what I got at present.
Tables:
Employees,
Employment,
EmploymentPlan,
Plan,
Weekdays,
Children,
ChildCare,
Table Infos:
Employees: Employee Data
Employment: Each Employee could have one or more Employments meaning he or she could change the weeklyhours for a given periode.
EmploymentPlan: An Employee could be working on Monday, and Friday from 7:00 to 12:00, on Tuesday from 7:00 to 13:00 and on Wednesday and Thursday from 8:00 to 13:00 for example.
I am getting that Times from the Plan Table
The same applies to Children.
A Child might be in Care on Monday and Tuesday from 7:00 to 12:00 on Wednesday from 7:00 to 13:00.
That might change in some other periods.
Maybe from 1/6/2022 to 31/10/22 Monday and Thuesday from 7:00 to 13:00 and Wednesday from 7:00 to 15:00
and the same kid is from 1/11/22 till the 30/10/2022. Only on Wednesday from 7:00 to 15:00.
In the Plan Table there is a boolean field HasLunch includet.
so if the Plan is from 7:00 to 12:00 there is no lunch.
All other times longer then 12:00 are with lunch.
So I guess so far the Structure is able to sort that out ok.
Now the things I am not sure about:
First I like to build a Calendar for a period of time to see how many kids having lunch at a given periode.
Create a Calendar to see how many Employees are available for that given periode to look after the kids.
Meaning that there are always incomming request for new kids or request if a child could be in a different periode attend different times.
So depanding on how many kids having lunch I need to plan times where the employees can take their own lunch.
So the kids have lunch between 12:00 to 13:00.
If there are more kids on wednesday for example the Employee need to take their lunch at 11:00 to 12: or from 13:00 to 14:00.
I got a table Breaks where different times are entered where someone could take lunchbreaks.
But I am not sure what table I would still need to be able to manage those breaks correctly.
So I was thinking of insert Data Into tblDates I called it for a given periode.
So would I need to create as said a Calendar and from each Day that I can adjust lunchbreaks for the Employees who are at that day working.
Hope that makes sense?
Maybe someone could help me for gettint that achived )
Many thanks