Data Modelling

Data Modeling for Student Feedback Analysis app on Hasura Platform


As a part of two month off-site internship with Hasura, I am embarked on developing a small 3-screen student feedback analysis app.
Here is the link of Three screen app idea and App wireframe/prototype 

For modeling this application I have created following three tables.

1)Student: Purpose of this table is to store student information like rollno(Primary Key), name, class and branch.




2)Faculty: Purpose of this table is to store faculty_id(primary key), name of faculty and calculated average of feedback.





3)Feedback: Purpose of this table is to store student feedback





ER Diagram for database schema is as follows
(ER diagram drawn using PonyORM on-line editor- https://editor.ponyorm.com/)

This ER diagram depicts two relationship.
1) One -to-many relationship between student to feedback table- depicting the fact that one student provide feedback of multiple faculties
2) One-to-many relationship between faculty to feedback table- depicting the fact that one faculty is evaluated by multiple students.

Comments

Post a Comment

Popular posts from this blog

Three Screen App Idea

As a part of Introduction to Modern Application Development NPTEL online course, I was fortunate to be selected for two month off-site internship programme. This internship is meant to consolidate software development concept and deliver a working product on Hassura platform within a period of two month. After a long thought and looking at department requirement I decided to develop a Student Feedback  Analysis  Web App. The main concept of this web-app is to allow students to give feedback about teaching learning process of departmental faculty. I am planning to devise this app with three screen (Excluding login/logout/register screen) First Screen:   Take student roll number and retrieve his/her information from database. Check whether the student already provided feedback. Second Screen: Allow student to provide feedback based on various parameters. Third Screen: Display analysis of students feedback in Graphical format (Pie Chart / Bar Cart) 
Read more

Week 8 - Final App

Image
Week 8 - Final App Finally its time to complete my App on Student Feedback Analysis System. Thanks to all members of Hasura team  for their kind support in completion of my app. Here are the final screenshot of my App.. Login Screen Screen 1 Screen 2 Screen 3 Apart from these functionalities, provision for signup using Google Captcha was also provided.
Read more

Setup dev environment

Image
Setup device  environment As per recommendation from Hasura team, I decided to install Ubuntu 16.04 on desktop Computer. Hardware and software  configuration of my PC are shown in screen-shot.   I downloaded  Ubuntu 16.04 image from http://releases.ubuntu.com/16.04/ubuntu-16.04.2-desktop-amd64.iso, created bootable pendrive(using Startup Disk Creator), and installed plain ubuntu 16.04 operating system on my PC. Now I thought to install an editor. As suggested by @tanmay during his first webinar, I decided to install vim on my system. So next step was to install vim by giving command $sudo apt-get install vim . Used vimtutor to learn basic vim commands. Updated .vimrc file for colors, indentation, numbering lines etc. The screen-shot of .vimrc file is
Read more