Education Course Registration Agent

import pandas as pd
from datetime import datetime

def check_prerequisites(student_id, course_id):
    # Check if student has required prerequisites
    completed = pd.read_sql("SELECT course_id FROM completed_courses WHERE student_id = ?", student_id)
    required = pd.read_sql("SELECT prereq FROM course_prereqs WHERE course_id = ?", course_id)
    return all(p in completed for p in required)

def check_capacity(course_id):
    enrolled = pd.read_sql("SELECT COUNT(*) FROM registrations WHERE course_id = ?", course_id)
    cap = pd.read_sql("SELECT capacity FROM courses WHERE id = ?", course_id)
    return enrolled[0] < cap[0]

# Register student if checks pass