I checked with the .net developer what code behind when running those pages,
He says:
It’s a series of entity framework queries, an update and some inserts. The update and the inserts are under a transaction using the Entity Framework. 

1. Get any existing teacher recommendation from the TeacherRecomendation table.   table only has 41 rows
2.  Get a test from the ScheduledTest table              

The following are in a transaction:
3. Insert into the StudentScheduledTests table    : currently there are only 180 rows
4. Update the ScheduledTests table : currently only 151 rows
5. Insert into the ParentReferral table : total 184 rows
6. Insert into the ParentRatings table : 47 rows

 These tables only have Primary keys.
I am not seeing any significant problem with this, what else can I do the troubleshooting?
thanks