The members table should implement an is_alumni boolean flag. This flag should be used before every single member query to filter out those members that have graduated.
Suggestion: ChatGPT suggested using something known as postgres views to create a view called active_members to avoid having to rewrite every single query.