Create a 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 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. o Infants (0-1 year old) $6.00/hour o Toddlers (1 year 3 years old) $5.00/hour o 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 o Infants (0-1 year old) maximum of 5 at same time o Toddlers (1 year 3 years old) maximum of 10 at same time o 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

Required Contents of the Database Design Document

1. Description of the business problem that the system will address

2. Description of the business rules that the system includes

3. The 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.

4. 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)

5. ERD of you proposed design be sure to include not just the tables but the fields you think would be meaningful.

6. A dependency diagram that shows your data structure is in 3NF

7. A listing of the types of interfaces and inputs and which tables they would interact with. For example, if you have a Child table and a Schedule table, this is where you would explain that when a new student is enrolled an entry is make in the Child table. Following the enry in the Child table, and through referential integrity, you would then explain how the schedule entry would be created.

8. A listing of the major reports and how your design supports them.for example, referencing specific tables that would be used to obtain a day by day schedule listing each child in order of the times they arrive each day, etc.