Nursery School

Sufiev Hadasa Hadar Example

Table of Contents

• Phase 1: Design and Build the Database
  • Introduction
  • ERD (Entity-Relationship Diagram)
  • DSD (Data Structure Diagram)
  • SQL Scripts
  • Data
  • Backup
• Phase 2: Integration

Phase 1: Design and Build the Database

Introduction

The Nursery School Database is designed to efficiently manage information related to children, parents, nannies, and nursery groups. This system ensures smooth organization and tracking of essential details such as group assignments, caregiver experience, child-parent relationships, and contact information.

Purpose of the Database

This database serves as a structured and reliable solution for nursery schools to:

• Organize groups of children based on age, availability, and special needs.
• Manage caregiver assignments by linking experienced nannies to specific groups.
• Maintain parent-child relationships, ensuring smooth communication and accessibility.
• Store contact information, including addresses, phone numbers, and emails.
• Track essential details such as children's birthdates, allergies, and caregiver experience.

Potential Use Cases

• Nursery School Administrators can use this database to efficiently allocate children to groups, assign caregivers, and store emergency contacts.
• Parents can track their child's assigned group, caregiver details, and provide important information about allergies or special needs.
• Nannies can view their assigned groups and the children under their care.
• Staff and Management can use the system for record-keeping, scheduling, and communication.

This structured database helps streamline nursery school operations, improving organization, safety, and communication among all parties involved.

ERD (Entity-Relationship Diagram)

DSD (Data Structure Diagram)

SQL Scripts

Provide the following SQL scripts:

• Create Tables Script - The SQL script for creating the database tables is available in the repository:

📜 View create_tables.sql

• Insert Data Script - The SQL script for insert data to the database tables is available in the repository:

📜 View insert_tables.sql

• Drop Tables Script - The SQL script for droping all tables is available in the repository:

📜 View drop_tables.sql

• Select All Data Script - The SQL script for selectAll tables is available in the repository:

📜 View selectAll_tables.sql

Data

First tool: using mockaro to create csv file

Entering a data to person table

• person id scope 1-800 📜View personMock_data.csv

Entering a data to nanny table

• person id scope 1-400 📜View nannyMock_data.csv

Entering a data to apotropus table

• person id scope 401-800
• Formula of Person ID: this + 400

📜 View apotropusMock_data.csv results for the command SELECT COUNT(*) FROM Apotropus;:

Second tool: using generatedata. to create csv file

Entering a data to babyGroup table

• Group Number scope 1-400 📜View babyGroupGenerateDat.csv

results for the command SELECT COUNT(*) FROM BabyGroup;:

Entering a data to baby table

• Bayby id scope 801-1200
• Group Number range 1-400

📜View babyGenerateDat.csv

results for the command SELECT COUNT(*) FROM Baby;:

Third tool: using python to create csv file

Backup

• backups files are kept with the date and hour of the backup:

עבור לתיקיית הגיבויים

Phase 2: Integration