DBMS Assignment 3 - Hostel Management Database Webapp

Made with Flask and MySQL

We used html, css and and JS to design the frontend, the login page and different profile page for every user. We also used bootstrap a pre-designed CSS framework. Then for backend we used Flask. The database was made in mySQL

Setup Required

1. Install Python 3.10.9

2. Install MySQL 5.7 or better

3. Install the required packages for python:

   bash pip install flask pip install flask-mysql

   Run the above commands in the terminal in order to install the required packages.

4. Use the hostel Mnagaement Database created in assignment 1 and 2.

5. Following are the crediantials for each user present in script.js: js student - Username Password-123 admin - Username Password-123 caretaker - Username Password-123

How to Run the Webapp?

1. Open the terminal and navigate to the directory where the 'init.py' file is located.

2. Run the following command in the terminal:

   bash python init.py

   Or you can simply click on the 'Run' button in your IDE for the 'init.py' file.

3. Open your browser and go to the URL that is displayed in the terminal, like this:

   bash http://127.0.0.1:5000

This brings home page of the webapp. Different pages open for different credentials

Login Screen

Users

1. Admin: He can view, edit, delete and filter in all tables
2. Student: He can view only view all tables
3. Caretaker: He can view all tables, but edit and delete entries in certain specific tables only. Also he can't add new data. Data addition can be done by admin only.

Operations

1. Insert
   • Before, a form opens
   • After
2. Update
   • Before, a form opens
   • After
3. Delete
   • Before, a form opens
   • After
4. Where (Filter)
   • Before, a form opens. Enter your query
   • Query
   • After
5. Delete Multiple Entries
   • Before, a form opens
   • Query
   • After

Work Distribution

Disha Chopra

Developed page for caretaker view, managed and resolved errors in the same. Teste and debugged the database and web app.

Hirva Patel

Worked on backend and integrating it with front-end. Helped in resolving errors and debugging in front end. Developed back-end function calls Integrated Google Authentication. Created defense against SQL attacks.

Harshi Chandrafari

Developed the front end using HTML, CSS, and Bootstrap. Worked extensively on front-end, resolving errors, making HTML pages, and integrating Bootstrap, Javascript, Jquery, and Flask. Developed back-end function calls and worked on the integration of pages with the backend.

Siddhi Rajpurohit

Worked in front-end form functions development Created README file and supervised work Worked on the backend and integrated it with the front-end. Developed back-end function calls.

Dhruv Gupta

Developed the frontend using HTML, CSS, and Tailwind CSS Worked extensively of front-end, resolving errors, making html pages, integrating bootstrap, Javascript, Jquery and Flask. Worked on the integration of pages with the backend

Divyanshu Pandey

Worked on the backend and integrated it with the front-end. Developed back-end function calls Worked in front-end form development using HTML,CSS ans Tailwind CSS Contributed to README and supervised work

Shubham More

Worked on README file, helped in front-end function creations.