E-Learning-Platform-for-Special-Children

Project Objective

In this pandemic, where the students of all levels are trying to adapt to the new normal of online classes and exams, there is no such facilities available for the children with special abilities, hence we thought of making an online platform that would be helpful for these children to continue their education online with the help of their parents as regular users of our website.It was our academic DBMS project of level-3,term-1 and I had Sazia Tabasum Mim and Fairooz Nawar Nawme as my project partners.

Click the image below to see our project video

Our project contains overall 10 database tables, Here is the ER diagram of the project

SCHEMA

Roles

• Doctor/therapist : for determining autism type and other counselling
• Teacher : for creating courses and test, assigning courses based on prerequisite test score of autistic child
• Guardian : will register his autistic child and get access of courses and tests, can also view performance result graph
• Nurse : caregiver for autistic child

PL/SQL

• procedure
• trigger
• sequence
• cursor
• exception handling

CONSTRAINTS

• primary key
• foreign key
• check
• unique

Automated System

• Appointment system

other features:

• blog/online forum system
• dynamic graph generation using result data

a teacher can

• create course and test
• appoint courses based on test result
• update result marks

a doctor can

• view appointments list and update autism and provide prescription
• set his working hours

a guardian can

• register child
• view assigned courses to his child
• view result/performance graph
• create post
• book an appointment in his preferrable time

NECESSARY PART OF APP DIRECTORY

+---app
|   +---Console
|   +---Exceptions
|   +---Http
|   |   +---Controllers
|   |   |   +---Appointment
|   |   |   +---Auth
|   |   |   +---AutismTypeDefine
|   |   |   +---Childform
|   |   |   +---CourseAppoint
|   |   |   +---CreateCourseTest
|   |   |   +---GiveTest
|   |   |   +---PostComment
|   |   |   +---ResultGraph
|   |   |   +---ScoreUpdate
|   |   |   \---ViewCourses
|   |   \---Middleware
|   +---Models
|   \---Providers
+---bootstrap
|   \---cache
+---config
+---database
|   +---factories
|   +---migrations
|   \---seeders
+---er and schema
+---helpful pdfs
+---node_modules
.
.
.
.
+---public
|   +---css
|   +---image
|   +---images
|   +---includes
|   +---js
|   +---uploads
|   |   \---avatars
|   \---vendor
+---resources
|   +---css
|   +---js
|   +---lang
|   |   +---bn
|   |   \---en
|   +---sass
|   \---views
|       +---auth
|       |   +---doctor
|       |   +---guardian
|       |   +---nurse
|       |   +---passwords
|       |   \---teacher
|       +---layouts
|       \---post
+---routes
+---sql
|   \---sazia sql
+---storage
|   +---app
|   |   +---images
|   |   \---public