Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles Of Multimedia Database Systems

Authors: V.S. Subrahmanian

1st Edition

1558604669, 978-1558604667

More Books

Students also viewed these Databases questions

Question

DESCRIBE six government-sponsored benefits.

Answered: 1 week ago

Question

=+ How well do you think you could do your job?

Answered: 1 week ago