What are all the applicable business rules to establish entities, relationships, optionalities, connectivities and participants for a database based on:

Victoria would like to spend less time processing paperwork and more time managing her business. Currently, she had to obtain data from the paper forms and reentered it into a spreadsheet software in order to generate a report, even if it is a simple report such as a list of children attending class each day. Victoria has set aside a budget for these purposes. She would like to be able to electronically record child attendance and easily retrieve information for planning and scheduling caretakers. She would also like the new system to be able to generate the following reports:

3.1 Waiting list report.

Victoria would like to keep an electronic record of children in the SLA waiting list organized by age and when the child was placed on the list.

3.2 Child information. Per State Law, SLA must maintain accurate information of each child. Victoria would like the tasks of keeping accurate records to be as easy as possible. The system should allow Victoria to view and update information and pictures for each child. She would also like to be able to view the overall records for all active children enrolling at SLA. This feature would be very useful in such situations as looking up which children do not have an immunization record on file. Victoria would like to keep records of every child enrolled at SLA, whether the enrollment is active or not.

3.3 Guardian Information. Similar to the childs information, Victoria would like to maintain accurate information for the parents/guardians of each child. She wants to be able to view information about all children under each guardian as well as all guardians for each child. Again, Victoria would like to keep records of all the parents/guardians whether they have a child currently enrolled at SLA.

3.4 Child reference report. This feature would be useful for caretakers to quickly locate basic information about each child. The reference report for each child should include such information as parent/guardian names and phone numbers, emergency contacts, medical information, and name and pictures of authorized pick up persons.

3.5 Birthday report. This report lists birthdays of children currently enrolled at SLA as well as birthdays by classroom.

3.6 Class roster. Victoria would like to be able to view the SLA roster overall (i.e., a list of children currently enrolled at SLA) as well as individual class rosters (i.e., a list of child assigned to each classroom). Ideally, the printed individual class roster should include the classroom number, teacher name(s), child names and the total number of children scheduled to be in a class. In addition, the reports should include checkboxes for attendance, a place to record the number of breakfast, lunch, and afternoon snacks requested for each class.

3.7 Attendance reports. Based on the checkin and check-out data, Victoria would like to be able to view the list of children currently attending SLA at any particular moment as well as the current attendance for each classroom. In addition, the system should be able to create a comprehensive report summarizing attendance hours for each child every week.

3.8 Receipt for fee payments. The system should be able to generate receipts for each of the payments SLA receives.

3.9 Event reminders. Victoria would like to receive an automatic reminder report at the beginning of each day. Examples of reminders include upcoming children's birthdays, upcoming activities (field trips, emergency drills, etc.), upcoming child progress evaluations (see Section 3.6.3), upcoming due dates for child immunizations, account information needed to be updated, and accounts that are currently past due.

3.10 Child incident reports. An incident report currently in use is provided in Figure 2. Victoria would like the new system to be able to generate a similar report that can be accessed from each childs record. She also would like to be able to create a monthly report summarizing all incidents by classroom, age group, and SLA overall.

3.11 Caretaker Information. Victoria would like to keep records of all employees at SLA although they are no longer actively working at SLA.