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.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

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.

**3. Desired System Features and Outcomes**

Victoria aims to minimize time spent on paperwork and increase time managing her business. Currently, she transfers data manually from paper forms to a spreadsheet. With funding set aside for improvements, Victoria desires an electronic system that simplifies attendance tracking and provides detailed reports. The new system should support the following features:

- **3.1 Waiting List Report**: Maintain an electronic record of children on the SLA waiting list, organized by age and enrollment date.
  
- **3.2 Child Information**: Ensure the maintenance of accurate child records, including updates and pictures, as required by state law. This feature should include immunization records and overall records for all children, assisting in identifying children without immunizations.

- **3.3 Guardian Information**: Similar to child information, Victoria requires updated guardian info, enabling views of current guardians for each child.

- **3.4 Child Reference Report**: Supports caretakers by providing fundamental details such as guardian names, phone numbers, emergency contacts, medical issues, and pickup permissions.

- **3.5 Birthday Report**: Lists current and classroom-specific birthdays.

- **3.6 Class Roster**: Displays a live roster of children currently enrolled, detailing attendance and schedules, including checkboxes for breakfast, lunch, and snacks.

- **3.7 Attendance Reports**: Utilize check-in/out data to list current attendees and classroom attendance, with weekly summary reports.

- **3.8 Receipt for Fee Payments**: Automate generation of payment receipts.

- **3.9 Event Reminders**: Auto-generate reminders for events such as birthdays and upcoming activities.

- **3.10 Child Incident Reports**: Generate accessible incident reports, with monthly classroom, age group, and SLA-wide summaries.

- **3.11 Caretaker Information**: Maintain records of SLA employees, past and present.

**4. Conclusion**

Victoria’s Smile Land Academy has grown successfully, presenting new challenges in time management and record-keeping. The current processing method is inefficient, and Victoria hopes to find a database solution to streamline operations and fulfill her needs.

**Table 1: SLA Fee Structure**

- One time Non-refundable Registration Fee: **$50**
- Weekly Tuition for Infant Rooms: **$160**
- Weekly Tuition for 1-year old Rooms: **$143**
- Weekly Tuition for 2-year old Rooms: **$130**
- Weekly Tuition for 3-year old Rooms: **$117**
Transcribed Image Text:**3. Desired System Features and Outcomes** Victoria aims to minimize time spent on paperwork and increase time managing her business. Currently, she transfers data manually from paper forms to a spreadsheet. With funding set aside for improvements, Victoria desires an electronic system that simplifies attendance tracking and provides detailed reports. The new system should support the following features: - **3.1 Waiting List Report**: Maintain an electronic record of children on the SLA waiting list, organized by age and enrollment date. - **3.2 Child Information**: Ensure the maintenance of accurate child records, including updates and pictures, as required by state law. This feature should include immunization records and overall records for all children, assisting in identifying children without immunizations. - **3.3 Guardian Information**: Similar to child information, Victoria requires updated guardian info, enabling views of current guardians for each child. - **3.4 Child Reference Report**: Supports caretakers by providing fundamental details such as guardian names, phone numbers, emergency contacts, medical issues, and pickup permissions. - **3.5 Birthday Report**: Lists current and classroom-specific birthdays. - **3.6 Class Roster**: Displays a live roster of children currently enrolled, detailing attendance and schedules, including checkboxes for breakfast, lunch, and snacks. - **3.7 Attendance Reports**: Utilize check-in/out data to list current attendees and classroom attendance, with weekly summary reports. - **3.8 Receipt for Fee Payments**: Automate generation of payment receipts. - **3.9 Event Reminders**: Auto-generate reminders for events such as birthdays and upcoming activities. - **3.10 Child Incident Reports**: Generate accessible incident reports, with monthly classroom, age group, and SLA-wide summaries. - **3.11 Caretaker Information**: Maintain records of SLA employees, past and present. **4. Conclusion** Victoria’s Smile Land Academy has grown successfully, presenting new challenges in time management and record-keeping. The current processing method is inefficient, and Victoria hopes to find a database solution to streamline operations and fulfill her needs. **Table 1: SLA Fee Structure** - One time Non-refundable Registration Fee: **$50** - Weekly Tuition for Infant Rooms: **$160** - Weekly Tuition for 1-year old Rooms: **$143** - Weekly Tuition for 2-year old Rooms: **$130** - Weekly Tuition for 3-year old Rooms: **$117**
**1) The Current System and Situation**

Presently, most data is first recorded on paper and later transferred to a computer file. Victoria keeps a paper copy of all the information in case there are problems with the computer files. Parents and caretakers can check in and out using paper sign-in sheets or one of the three computers located at the building entrance. Victoria also utilizes a spreadsheet software program to keep track of employee work hours and payroll information. This practice has worked well until recently, when she felt she needed a better way to organize data for easy retrieval. In addition, she would like to be able to see the overall day-to-day operations without having to spend too much time going through her files and papers to create reports.

**2) Current Data Processing Description**

This section describes activities performed at SLA.

a) **2.1 Creating a Waiting List**  
   SLA accepts child enrollment applications from parents or guardians all year round. If there is an opening in a class for the child in his or her age range, the child will be immediately accepted and may start attending class as early as the next day. However, SLA rarely has an unfilled seat. As a result, most applications will be placed on a waiting list. Applications on the waiting list are dated and kept in a file folder for the age group (Nursery, i.e., 3-12 months, 1, 2, 3, 4 and 5 years old). An application may be placed on the waiting list for as little as 1 week all the way up to one year. Any application older than one year old will be shredded.

b) **2.2 Processing Initial Child Registration and Enrollment**  
   As soon as there is an open seat in a classroom, Victoria will contact the parents of a child who were next in line on the waiting list for that age group. The parents will be asked to update information on the application as well as complete additional forms including parent/guardian address and phone numbers, family physician information, hospital name and phone number, and health insurance provider information. Victoria will take a picture of the child and the parents and attach them to the records. A $50 nonrefundable registration fee is also due with the completed application.

c) **2.3 Daily Checking In and Out of Children**  
   SLA is open Monday through Friday from 6:30am to 5:30pm. Parents, guardians, or other authorized persons may
Transcribed Image Text:**1) The Current System and Situation** Presently, most data is first recorded on paper and later transferred to a computer file. Victoria keeps a paper copy of all the information in case there are problems with the computer files. Parents and caretakers can check in and out using paper sign-in sheets or one of the three computers located at the building entrance. Victoria also utilizes a spreadsheet software program to keep track of employee work hours and payroll information. This practice has worked well until recently, when she felt she needed a better way to organize data for easy retrieval. In addition, she would like to be able to see the overall day-to-day operations without having to spend too much time going through her files and papers to create reports. **2) Current Data Processing Description** This section describes activities performed at SLA. a) **2.1 Creating a Waiting List** SLA accepts child enrollment applications from parents or guardians all year round. If there is an opening in a class for the child in his or her age range, the child will be immediately accepted and may start attending class as early as the next day. However, SLA rarely has an unfilled seat. As a result, most applications will be placed on a waiting list. Applications on the waiting list are dated and kept in a file folder for the age group (Nursery, i.e., 3-12 months, 1, 2, 3, 4 and 5 years old). An application may be placed on the waiting list for as little as 1 week all the way up to one year. Any application older than one year old will be shredded. b) **2.2 Processing Initial Child Registration and Enrollment** As soon as there is an open seat in a classroom, Victoria will contact the parents of a child who were next in line on the waiting list for that age group. The parents will be asked to update information on the application as well as complete additional forms including parent/guardian address and phone numbers, family physician information, hospital name and phone number, and health insurance provider information. Victoria will take a picture of the child and the parents and attach them to the records. A $50 nonrefundable registration fee is also due with the completed application. c) **2.3 Daily Checking In and Out of Children** SLA is open Monday through Friday from 6:30am to 5:30pm. Parents, guardians, or other authorized persons may
Expert Solution
Step 1

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.

steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education