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.