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 1The scope of this portion of the design (e.g. what processes does your database design address - scheduling ? enrollment ? time/attendance of children ? payments ? receipt of payments ? ) - you must address all of the business rules listed above - you also can add any business rules you would like to add (as long as they are not contrary to any of the given business rules) - this is the point in the document where you would like those additional rules that you defined. This is also the point in the document where you would list any assumptions you made when creating the design.

question 2 : Scope not included/future scope (are there any areas of the database design that are envisioned but not included in this "phase" of the design ? For example, as you work on the project, you may think of other areas such as the schedule of activities or the menu of snacks/lunch, etc. that are not in the design)