This is a ERD representation of a Day

This is a ERD representation of a Day Care system

Patty’s playschool is a child daycare center. A parent registers their child or children at the school using a registration form. A parent can submit more than one registration form. Each daycare is assigned an age group. For example an infant is under 1 year of age an toddlers are from 1 to 3 years of age. A child is assigned to a room based on their age and availability of space. A room may be assigned one or more employees. An employee can only be assigned to one room. The minimum number of employees required for a room is determined by a number of children assigned to the room and the child staff ratio identified by the government. For example one employee can care for 5 infants or 8 toddlers.

ID Number Name Age Gender Parent Address

ID Number Name Registration Form Age Gender Address Room Number

Room Number Age Group Room

Age Children Name ID Number

Gender Employee Age ID Number Name

ID Number Room Number Name Age Group Age Gender Parent Room Address Children Age Gender ID Number Name Employee Registration Form Age Gender Address Room Number ID Number Age Name

0123 Cusi 18 Male Quezon City

0123 Cusi 18

0123 Cusi 18 Male Caloocan City A 1

0123 Cusi 18 Male

A 1 3 to 6 year’s old