Dayacare Smile Land Academy (SLA) needs to update to database system. Victoria Middleton, the founder of SLA, needs a better way to organize her data and would like a computerized database system to help manage her day-to-day operational activities and provide summary reports. Document the business rules for the Smile Land Academy. You are allowed to make reasonable assumptions as long as you state them clearly in your answer and identify and list the main entities, relationships and constraints from the business rules.
Dayacare Smile Land Academy (SLA) needs to update to
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 child’s 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.
Step by step
Solved in 2 steps