Real-Time Student Performance Analytics Pipeline

Create a high-performance database migration strategy for building a real-time student performance tracking system that can handle concurrent grade updates across multiple academic departments. Develop a normalized schema that supports instant calculation of cumulative GPAs, tracks historical grade changes, and provides audit trails using Laravel's database migrations. Include comprehensive indexing strategies to ensure sub-100ms query response times for large academic datasets.