The problem Smiling Soul solves

Mental health and counselling is our main focus as isolation is leading to depression and anxiety among some students as studies are also going online nowadays. Students are going on a study, eat, sleep schedule. Every student is suffering from Loneliness and boredom. In online semesters College students find it difficult to approach GCS, Guidance and counselling services provided by IIT Mandi. Students generally have to call or email the concerned person which is sometimes difficult to be done by a socially isolated person. So our platform provides easy way to connect with GCS IIT Mandi.

Challenges we ran into

First challenge was to Add Google Authentication For registration and Signing in of users which was done OAUTH library. Another Main challenge was to plan , create and implement into working form a Scheduling database using RDBMS. Redundancy was the Main concern but using the concepts of IDS course we were able to build Schema and relationships without any redundancy. And finally we were able implement using Mysql Queries in Flask . Inserting, Deleting , Updating and Fetching details were implemented using sql queries and doing natural joins between tables to fetch relative information between table.