School Student Attendance Application Development
Budget: $750 – $1,500 USD
Project Overview
Project Name: School Student Attendance System
Goal: Build a system that allows teachers/staff to mark student attendance (possibly with location/time), notifies parents via push notifications when the student is ready for pickup or has been picked up, enables parents to confirm/view status, and handles basic student/parent/teacher data.
Architecture:
• Mobile App (Teachers / Parents)
• Oracle APEX Backend (Admin / Reports / APIs)
• Oracle Database
Duration: 2 Months (8 Weeks)
System Architecture
1) Mobile Application
Users:
• Teachers → mark attendance and deliver students
• Parents → Students receive and students tracking.
• Security → deliver students (optional)
Features:
• Login
• Class & student list
• Attendance marking
• Reports & notifications
2) Oracle APEX Backend System
Users:
• Admin
• Teachers
• IT Staff
Project Phases & Timeline (2 Months)
Phase 1 – Analysis & Planning (Week 1)
Duration: 5 days
Tasks:
• Requirements gathering about school data
• Define user roles:
o Admin
o Teacher
o Security
o Parent
• Define workflows:
o Student delivery flow
• System architecture design
• Database ERD design
• UI/UX wireframes (mobile + APEX)
Deliverables:
• Requirements Document (SRS)
• Data Model (ERD)
• Flow Diagrams
• Project Schedule
Phase 2 – Database & Backend Design (Week 2)
Duration: 5 days
Tasks:
• Design Oracle tables:
o Students
o Parents
o Teachers
o Classes
o Attendance
o security
o Student Delivery Logs
o Users & Roles
• Create sequences & constraints
• PL/SQL APIs & packages
• REST APIs for mobile app
• Security & authentication design
Deliverables:
• Database schema
• PL/SQL packages
• API documentation
Phase 3 – Oracle APEX Backend Development (Weeks 3–4)
Duration: 10 days
Modules in APEX:
Admin Module
• Student management
• Parent management
• Teacher management
• Security management
Attendance Module
• Daily attendance dashboard
• Manual attendance editing
• Reports
Deliverables:
• Fully working APEX application
• Admin dashboards
Phase 4 – Mobile Application Development (Weeks 5–6)
Duration: 10 days
Mobile Apps:
Parent App
• Login
• Student status (arrived / absent)
• Request student
• Notifications
• History
Security App
• Login
• Deliver srudent.
Teacher App (optional)
• Attendance marking
• Student deliver
Deliverables:
• Android/iOS apps
• API integration with APEX
Phase 5 – Integration & Testing (Week 7)
Duration: 5 days
Testing Types:
• Unit testing
• API testing
• Integration testing
• User acceptance testing (UAT)
• Performance testing
• Security testing
Deliverables:
• Test cases
• Bug fixes
• Final version
Phase 6 – Deployment & Training (Week 8)
Duration: 5 days
Tasks:
• Production environment setup
• Database deployment
• APEX deployment
• Mobile app release
• School staff training
• Documentation
Deliverables:
• Live system
• User manuals
• Admin guide
Time Breakdown (2 Months)
Phase Duration
Analysis & Design 1 week
Database & APIs 1 week
Oracle APEX Development 2 weeks
Mobile App Development 2 weeks
Testing & Integration 1 week
Deployment & Training 1 week
Total 8 weeks (2 months)
Project Name: School Student Attendance System
Goal: Build a system that allows teachers/staff to mark student attendance (possibly with location/time), notifies parents via push notifications when the student is ready for pickup or has been picked up, enables parents to confirm/view status, and handles basic student/parent/teacher data.
Architecture:
• Mobile App (Teachers / Parents)
• Oracle APEX Backend (Admin / Reports / APIs)
• Oracle Database
Duration: 2 Months (8 Weeks)
System Architecture
1) Mobile Application
Users:
• Teachers → mark attendance and deliver students
• Parents → Students receive and students tracking.
• Security → deliver students (optional)
Features:
• Login
• Class & student list
• Attendance marking
• Reports & notifications
2) Oracle APEX Backend System
Users:
• Admin
• Teachers
• IT Staff
Project Phases & Timeline (2 Months)
Phase 1 – Analysis & Planning (Week 1)
Duration: 5 days
Tasks:
• Requirements gathering about school data
• Define user roles:
o Admin
o Teacher
o Security
o Parent
• Define workflows:
o Student delivery flow
• System architecture design
• Database ERD design
• UI/UX wireframes (mobile + APEX)
Deliverables:
• Requirements Document (SRS)
• Data Model (ERD)
• Flow Diagrams
• Project Schedule
Phase 2 – Database & Backend Design (Week 2)
Duration: 5 days
Tasks:
• Design Oracle tables:
o Students
o Parents
o Teachers
o Classes
o Attendance
o security
o Student Delivery Logs
o Users & Roles
• Create sequences & constraints
• PL/SQL APIs & packages
• REST APIs for mobile app
• Security & authentication design
Deliverables:
• Database schema
• PL/SQL packages
• API documentation
Phase 3 – Oracle APEX Backend Development (Weeks 3–4)
Duration: 10 days
Modules in APEX:
Admin Module
• Student management
• Parent management
• Teacher management
• Security management
Attendance Module
• Daily attendance dashboard
• Manual attendance editing
• Reports
Deliverables:
• Fully working APEX application
• Admin dashboards
Phase 4 – Mobile Application Development (Weeks 5–6)
Duration: 10 days
Mobile Apps:
Parent App
• Login
• Student status (arrived / absent)
• Request student
• Notifications
• History
Security App
• Login
• Deliver srudent.
Teacher App (optional)
• Attendance marking
• Student deliver
Deliverables:
• Android/iOS apps
• API integration with APEX
Phase 5 – Integration & Testing (Week 7)
Duration: 5 days
Testing Types:
• Unit testing
• API testing
• Integration testing
• User acceptance testing (UAT)
• Performance testing
• Security testing
Deliverables:
• Test cases
• Bug fixes
• Final version
Phase 6 – Deployment & Training (Week 8)
Duration: 5 days
Tasks:
• Production environment setup
• Database deployment
• APEX deployment
• Mobile app release
• School staff training
• Documentation
Deliverables:
• Live system
• User manuals
• Admin guide
Time Breakdown (2 Months)
Phase Duration
Analysis & Design 1 week
Database & APIs 1 week
Oracle APEX Development 2 weeks
Mobile App Development 2 weeks
Testing & Integration 1 week
Deployment & Training 1 week
Total 8 weeks (2 months)