[Database] NULL when advisor is deleted

[LifelongWay]

Feature Request: Reassign Students to Least-Loaded Advisor on Advisor Deletion

Current Behavior

Currently, when a Teacher who serves as an advisor is deleted, the advisor field on the associated Student records is set to NULL. This leaves students without an assigned advisor.

Expected Behavior

Instead of setting the advisor field to NULL, students should automatically be reassigned to another available advisor. The reassignment should prioritize the advisor with the fewest current advisees to balance the load.

Additional Notes

• Consider what happens if no other advisors exist (e.g., raise an error or assign a default “unassigned” advisor).