added parent child relationship aggregation