Now I have a complete understanding of the project. This is a Student Course Hub - a university web application to:

1. Student-facing: Browse programmes, modules, staff, and register interest
2. Admin-facing: Manage programmes, modules, staff, and view mailing lists

Let me set up tasks and get the database integration ready.

I understand - I'll build this Student Course Hub application with static data that matches the SQL schema structure. Let me first re-read all the requirement files to get the complete picture.

Now I have a complete understanding of the project. Let me read the existing files and then build this comprehensive Student Course Hub application.

Now I have a comprehensive understanding. Let me build the complete Student Course Hub application. I'll start by creating the data layer, then the shared components, and finally all the pages for both student and admin interfaces.

Now let me create the main pages starting with the home page:

Now let me create the admin section with authentication, dashboard, and CRUD operations:

Now let me update the layout with better metadata and read the existing alert-dialog component:

Good, the components exist. Now let me update the layout with proper metadata:

Now let me create a not-found page for better UX:

Let me also update the globals.css to add a nice primary color for the university theme:

I've built a complete Student Course Hub web application based on your requirements. Here's what's included:

Student-Facing Features:

• Home Page: Hero section, stats, featured programmes (undergraduate & postgraduate), and call-to-action sections
• Programmes: Filterable list with search by keyword and level (undergraduate/postgraduate), with detailed individual programme pages showing modules grouped by year
• Modules: Searchable module directory showing which programmes include each module
• Staff: Directory with department filtering and individual profile pages showing modules/programmes led
• Interest Registration: Modal form with XSS protection and duplicate detection for students to register interest in programmes

Admin Portal Features:

• Authentication: Login system with role-based access (admin vs editor), demo credentials shown on login page
• Dashboard: Statistics overview, quick actions, and recent registrations
• Programme Management: Full CRUD operations - create, edit, publish/unpublish, and delete programmes
• Module Viewer: View all modules with their associated programmes
• Mailing List: Filter by programme/status, toggle active/inactive status, remove registrations, and export to CSV

Technical Highlights:

• Mobile-responsive design with keyboard navigation and WCAG2 accessibility compliance
• Input sanitization to prevent XSS attacks
• Clean university-themed design with a professional blue primary color
• Static data layer matching the provided SQL schema, ready to connect to a real database when needed