Hey Tharaa Gazzaz,
If you join the two tables either by field or using a spatial join you will have all the data in one layer. You could then use a field calculator to subtract the schools capacity from the number of school aged kids to see schools that need more capacity or schools with capacity to take on more children.
If this answer was helpful please mark it as helpful. If this answer solved your question please mark it as the answer to help others who have the same question.
Thanks Ben for your suggestion.
As you know, each neighborhood will have different population density and a buffer might cover one or more neighborhoods.
I was thinking of using buffer zone that capture population count matching school student capacity.
For example, if a school capacity is 100 students, I would like to know this school coverage area reference to population density, in other word, what will be the school buffer diameter that will capture the 100 students.
I did a buffer zone related to school capacity, however, its not reflecting school potential area coverage reference to population distribution.