Baby Sitters and Nannies

The "Sessions, Nannies & Fee" table records detailed information about each babysitting or nanny session. It includes the nanny's and parent's names, session start and end times, hours worked, hourly rate, amount due, payment status, dates of payment, and any outstanding amounts. This table is crucial for tracking the financial aspects of each session, ensuring that payments are managed efficiently and caregivers are compensated accurately.

The "Agencies" table stores information about the agencies that provide babysitting and nanny services. It includes the agency's name, address, contact phone numbers, email address, and other relevant details. This table helps in managing agency information, facilitating communication, and ensuring that agency details are readily accessible.

The "Baby Sitters & Nannies" table contains detailed information about individual babysitters and nannies. It includes their name, photo, gender, hourly rate, age, date of birth, address, contact details, and any associated agency. This table is essential for maintaining a comprehensive record of caregivers, supporting effective matching with families, and managing schedules and payments.

The "Baby Sitters Qualifications" table records the qualifications of each babysitter or nanny. It includes the sitter's name, qualification code, and relevant dates. This table ensures that caregivers' qualifications are documented and verified, providing assurance to parents regarding the competency and skills of the caregivers.

The "Baby Sitting Sessions" table tracks the details of each babysitting session. It includes the parent's name, session start and end times, total hours, and other relevant details. This table helps in organizing and managing session schedules, ensuring that all babysitting activities are well-documented and easily accessible for review and planning.

The "Parents" table stores information about the parents who utilize babysitting and nanny services. It includes their name, gender, address, contact phone numbers, and other relevant details. This table is vital for maintaining accurate records of parents, facilitating communication, and ensuring that services are tailored to their needs.

The "Children" table contains information about the children who are cared for by babysitters and nannies. It includes the child's name, gender, parent name, age, date of birth, and other relevant details. This table ensures that all necessary information about the children is documented, supporting personalized care and effective communication with parents.

The "Qualifications" table records the various qualifications that babysitters and nannies may hold. It includes the qualification code and description, ensuring that all qualifications are clearly documented and can be easily referenced. This table supports the verification of caregivers' skills and credentials, providing confidence to parents and agencies.