Complex Student Performance Analytics Pipeline Design

Design a comprehensive PostgreSQL database schema that can track multi-dimensional student performance across different learning modalities, including online courses, in-class assessments, standardized tests, and extracurricular achievements. Create an advanced ETL process that can handle real-time data ingestion from multiple learning management systems, with built-in data validation, normalization, and performance scoring algorithms. Include specific considerations for handling diverse data types, managing historical academic records, and creating flexible reporting mechanisms that support predictive learning analytics.