Just need 1 question answered you need to create a single word document which is
ID: 3918339 • Letter: J
Question
Just need 1 question answered
you need to create a single word document which is the “Design and Implementation Plan “ for a Database that you design. The Database will be created using a RDBMS.
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 child’s guardian must pay a fee in advance of the following week
The fee is a function of the child’s 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
Question : Description of the business problem that the system will address
Explanation / Answer
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.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.