Question
1 question needed Description of the business rules that the system includes Background: You have been hired by ABC Daycare Center to build a database
1 question needed
Description of the business rules that the system includes
Background:
You have been hired by ABC Daycare Center to build a database system for them.
You have met with the owners of the business and they shared the following information with you:
Children in the preschool are referred to individually as child
The parents or guardians are referred to in general terms as guardian
Each childs guardian must pay a fee in advance of the following week
The fee is a function of the childs age category and the number of hours they are in attendance.
Infants (0-1 year old) $6.00/hour
Toddlers (1 year 3 years old) $5.00/hour
Preschoolers (3 6 years old) $4.50/hour
When a child enrolls, the guardians agree to a schedule and the rates above apply to the schedule or any portion of the scheduled time. For example, if a child who is an infant, is scheduled for M-Fr for 9:00 3:00 each day, then if the child attends all days within those time frames, or any subset of those hours (for example, leaves early on Wednesday at noon for a dr. appt), the fee is $6 * 30 hours or $180. No refund is given for time less than schedule.
If a guardian needs to add extra hours in advance of the following week, it is at the hourly rates above (subject to approval in the previous week)
If extra time is taken that is not pre-approved or arranged, then that time is at 3 times the rate provided above. For example, if the infant above was picked up at 4:00 one day, then a fee of $6 * 3 = $18 would be added to the childs account
The fee can be paid in the form of cash, check, or charge
A child must be associated with at least one guardian but most have two guardians who happen to be the parents.
In addition to guardians, the database needs to keep track of other authorized people who can drop off or pick up the child
The daycare is open 8 5 pm Monday through Friday
The limit of children that can be in the daycare at any point in time are set by categories
Infants (0-1 year old) maximum of 5 at same time
Toddlers (1 year 3 years old) maximum of 10 at same time
Preschoolers (3 6 years old) maximum of 10 at same time
Staffing - in order to meet guidelines for the limits above, there must be at least 4 staff on duty at any given time
this is the description of of the business problem that the system will address According to the inquiry, the database will always be refreshed about each enrolment including vital points of interest, for example, the age of the kid, guardians subtle elements, timings for which the kid ought to be taken into account, the meds and other wellbeing reports of the tyke, alongside all the legitimate documentation or confirmation evidences to guarantee security in all conditions.
Question. Description of the business rules that the system includes
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started