Real-Time Course Enrollment Capacity Management System

Build a high-concurrency database solution using Redis and PostgreSQL to manage real-time course enrollment with strict capacity limits. Develop a Python implementation that handles race conditions during simultaneous student registrations, implements atomic transactions to prevent over-enrollment, and provides instant waitlist management. Include advanced locking mechanisms and develop a distributed queuing system that can handle peak registration periods for large university systems.