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
- 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
- procedure
- trigger
- sequence
- cursor
- exception handling
- primary key
- foreign key
- check
- unique
- Appointment system
- blog/online forum system
- dynamic graph generation using result data
- create course and test
- appoint courses based on test result
- update result marks
- view appointments list and update autism and provide prescription
- set his working hours
- register child
- view assigned courses to his child
- view result/performance graph
- create post
- book an appointment in his preferrable time
+---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