Bihar PYQ Educational Platform Development

Bihar PYQ Website – Small Developer Guide Project: Bihar PYQ Platform Goal: Students can easily find and access previous-year question papers from Bihar universities. 1. Main Website Clean, simple, mobile-friendly UI. Homepage with Search PYQ. University-wise browsing. No unnecessary features. 2. PYQ Structure Use this hierarchy: University → Course → Semester → Subject → Year → Paper → PDF Example: Patliputra University → BA → Semester 1 → Political Science → 2024 → Major → PDF 3. Student Features Search PYQs Filter by university/course/semester/subject/year View PDF Download PDF Show paper details before opening 4. Admin Panel Admin should be able to: Login securely Add university Add course Add semester Add subject Upload PYQ PDF Select year and paper type Edit/delete records Publish/unpublish PDFs 5. Supabase Backend Use Supabase for: Database PDF Storage Admin authentication Suggested database fields: id | university | course | semester | subject | year | paper_type | title | pdf_url | status | created_at 6. Important Requirement Do not create separate pages manually for every PDF. The admin uploads the PDF and selects its categories; the website should automatically display it in the correct section. 7. Priority Build in this order: UI → Supabase Database → PDF Storage → Admin Login → Admin Upload → Student Search/Filter → View/Download PDF Developer instruction: Keep the system scalable so more Bihar universities, subjects, semesters and years can be added later without changing the website structure.