Back to Home

👨‍💼 ADMIN PANEL - COMPLETE DFD

From Login to Complete System Management (Step-by-Step Flow)

📖 DFD SYMBOLS LEGEND
Process Admin operations and system actions
External Entity Admin (System administrator)
Data Store Database tables storing information
→
Data Flow Direction of information movement

🔍 ADMIN SYSTEM ASSUMPTIONS

STEP 1: ADMIN LOGIN & AUTHENTICATION

Process Flow:

Input: Admin Email + Password

Process: Verify credentials → Check role = ADMIN → Generate admin session token

Output: Login successful → Redirect to Admin Dashboard

ADMIN STEP 1 1.1 ADMIN AUTHENTICATION D1: USER TABLE D2: ADMIN TABLE 1.2 GENERATE SESSION Login Request (Email + Password) Verify Credentials User Found Check Role role = ADMIN Valid Admin Admin Token + Redirect to Dashboard
STEP 2: ADMIN DASHBOARD OVERVIEW

Process Flow:

Input: Admin session token

Process: Fetch system statistics → Count active students → Calculate revenue → Show content count

Output: Dashboard with key metrics (total students, revenue, active subscriptions, content stats)

ADMIN STEP 2 2.1 LOAD ADMIN DASHBOARD D3: STUDENT_PROFILE D4: STUDENT_SUBSCRIPTION D5: PAYMENT D6: VIDEO + NOTES D7: EXAM_RESULT Access Dashboard Count Students Total: 1500 Active: 1200 Revenue: ₹50L Videos: 500, Notes: 300 Exams: 150 Dashboard Statistics
STEP 3: STUDENT MANAGEMENT

Process Flow:

Input: Admin views/manages students

Process: List all students → View details → Approve/Block/Delete accounts → Update status

Output: Student list with actions (Active/Inactive/Blocked status)

ADMIN STEP 3 3.1 LIST ALL STUDENTS 3.2 VIEW STUDENT DETAILS 3.3 MANAGE STATUS D3: STUDENT_PROFILE D4: STUDENT_SUBSCRIPTION D1: USER (status update) Request Student List Fetch All Student Records Display List Select Student Subscription Info Action: Approve/Block Update Status Status Updated Action Completed
STEP 4: UPLOAD VIDEO LECTURES

Process Flow:

Input: Admin uploads video file with metadata (title, course, is_free flag)

Process: Validate file → Upload to storage → Save metadata to database → Link to course

Output: Video successfully uploaded and available for students

ADMIN STEP 4 4.1 UPLOAD VIDEO 4.2 VALIDATE FILE 4.3 SAVE METADATA D8: FILE STORAGE D6: VIDEO TABLE Video File + (Title, Course, is_free) Check File Format Upload Video File URL Valid + URL Save Record (title, course, url, is_free) Saved Successfully Upload Success (Video Available)
STEP 5: UPLOAD STUDY NOTES (PDF)

Process Flow:

Input: Admin uploads PDF file with metadata (title, course, is_free)

Process: Validate PDF → Upload to storage → Save file path to database

Output: Notes successfully uploaded and downloadable for students

ADMIN STEP 5 5.1 UPLOAD NOTES (PDF) 5.2 VALIDATE PDF 5.3 SAVE INFO D8: FILE STORAGE D9: NOTES TABLE PDF File + (Title, Course, is_free) Check PDF Format Upload PDF File Path Valid + Path Save Record (title, course, path, is_free) Saved Successfully Upload Success (Notes Available)
STEP 6: CREATE EXAM / MOCK TEST

Process Flow:

Input: Admin creates exam with title, course, questions, duration, total marks

Process: Enter exam details → Add questions with answers → Set marking scheme → Save exam

Output: Exam created and available for students to attempt

ADMIN STEP 6 6.1 EXAM DETAILS 6.2 ADD QUESTIONS 6.3 SET MARKING 6.4 SAVE EXAM D10: EXAM TABLE D11: QUESTION_BANK Title, Course, Duration, Total Marks Exam Created Questions Added (With Correct Answers) Marking Done Store Exam Info Store Questions Saved Successfully Exam Created (Ready for Students)
STEP 7: CREATE/MODIFY SUBSCRIPTION PLANS

Process Flow:

Input: Admin defines plan (name, duration, price, features)

Process: Enter plan details → Set included features (videos, notes, tests, guidance) → Save plan

Output: Subscription plan active and available for student purchase

ADMIN STEP 7 7.1 CREATE PLAN 7.2 SET FEATURES D12: SUBSCRIPTION_PLAN Plan Name, Duration, Price (₹999, ₹1999, etc) Plan Created Save Plan (includes_videos, includes_notes, etc) Plan Active Plan Created Successfully (Available for Purchase)
STEP 8: PAYMENT & TRANSACTION MANAGEMENT

Process Flow:

Input: Admin views payment history

Process: Fetch all payments → Filter by status/date → Calculate total revenue

Output: Payment list with details (student, amount, date, status, transaction ID)

ADMIN STEP 8 8.1 VIEW PAYMENTS 8.2 CALCULATE REVENUE D5: PAYMENT D4: STUDENT_SUBSCRIPTION Request Payment List Fetch All Payments Payment Records Subscription Info Payment Data Sum Amounts Payment List + Total Revenue: ₹50,00,000
STEP 9: VIEW EXAM RESULTS & STUDENT PERFORMANCE

Process Flow:

Input: Admin selects exam to view results

Process: Fetch all student results → Calculate pass/fail statistics → Generate report

Output: Result list with student performance (marks, status, rank)

ADMIN STEP 9 9.1 SELECT EXAM 9.2 VIEW RESULTS D10: EXAM TABLE D7: EXAM_RESULT Request Results Fetch Exam List Exam Details Exam Selected Fetch All Results Student Results (marks, pass/fail, rank) Result Report (Pass: 85%, Fail: 15%)
STEP 10: SEND NOTIFICATIONS TO STUDENTS

Process Flow:

Input: Admin creates notification message

Process: Write message → Select target students (All/Specific) → Send notification → Store in DB

Output: Notification sent to students' dashboard and email

ADMIN STEP 10 10.1 CREATE NOTIFICATION 10.2 SEND NOTIFICATION D13: NOTIFICATION D3: STUDENT_PROFILE STUDENTS Message Text (Alert, Announcement) Get Recipients Student IDs Notification Ready Store Notification Push Notification (Dashboard + Email)
STEP 11: VIEW SYSTEM ANALYTICS & REPORTS

Process Flow:

Input: Admin requests analytics dashboard

Process: Aggregate data from all tables → Calculate KPIs → Generate graphs and charts

Output: Analytics dashboard (enrollment trends, revenue graphs, content usage, exam statistics)

ADMIN STEP 11 11.1 GENERATE ANALYTICS D3: STUDENT_PROFILE D5: PAYMENT D7: EXAM_RESULT D6: VIDEO D4: SUBSCRIPTION D10: EXAM Request Analytics Fetch All Data Aggregate Data Analytics Dashboard (Graphs, Charts, KPIs)

✅ COMPLETE ADMIN OPERATIONS - END TO END

🔐 AUTHENTICATION

Secure admin login → Role verification → Session token generated

📊 DASHBOARD

System statistics → Active students → Revenue tracking → Content count

👥 STUDENT MANAGEMENT

View all students → Approve/Block accounts → Update status

🎥 VIDEO UPLOAD

Upload lectures → Validate files → Store metadata → Content available

📝 NOTES UPLOAD

Upload PDFs → Validate format → Store path → Notes downloadable

📋 EXAM CREATION

Create exams → Add questions → Set marking → Exam ready

💳 SUBSCRIPTION PLANS

Create plans → Set features → Define pricing → Plans active

💰 PAYMENT TRACKING

View all payments → Transaction history → Revenue calculation

📈 RESULT MANAGEMENT

View exam results → Student performance → Pass/fail stats

🔔 NOTIFICATIONS

Send alerts → Target students → Push to dashboard + email

📊 SYSTEM ANALYTICS

Generate reports → Data aggregation → KPIs & trends

🎯 COMPLETE CONTROL

Full system management → Content control → User oversight

👨‍💼 Admin Operations: 11 major functions

📦 Database Tables: 13 tables managed

🔄 Complete Admin Lifecycle: Login → Management → Analytics