CS 432-Assignment 3

Table of Contents:

• CS 432-Assignment 3
  • Table of Contents:
  • Introduction:
  • Steps to run Web-app:
  • Login Page:
  • Hero Page:
  • 3.3.1: Creating Dummy Database
  • 3.3.2: Section-2 Dynamic Execution
    • 1. INSERT:
    • 2. UPDATE
    • 3. DELETE
    • 4. WHERE
    • RENAME:
  • Views:
    • 1. Admin:
    • 2. Staff:
    • 3. Professor:
    • 4. Student:
  • Webpage:
  • Contributions:

Introduction:

This lab management website, created by SQL Dummies, is a platform designed to organize and enhance the management of laboratories, offering a comprehensive solution for professors, students, lab technicians, and administrators alike. It offers multiple features such as providing lab details, managing inventory, regulating course administration, booking labs, keeping profiles of professors and students, etc. A login/registration page allows different views to the database, allowing admins to delete, rename, update and insert data, while restricting students to lab booking and issuing tools. All our data is stored in an optimized database, which is currently tested using dummy data. Various tools such as HTML, CSS, Tailwind, etc. are used for frontend, and MySQL and Flask are used to create a smooth interaction to the databases. Detailed information about the features are given below.

Steps to run Web-app:

1. Install the libraries for requirements.txt: pip install -r requirements.txt
2. Clone the repository : <link> Terminal: git clone https://github.com/kaushal-003/LabManagementWebApp.git
   
   
3. Run the SQL script in the MySQL Workbench:
   • Go to File > Run SQL script.. choose the .sql file(sql script, and click Run.
   
   **Note:** The database should be visible in navigation pane:
   - This script will create a database called lab_bookings, corresponding tables, and it will insert some pre-required data into the tables.

5. Run the app.py code.
python app.py

Login Page:

Hero Page:

3.3.1: Creating Dummy Database

LOCK TABLES `students` WRITE;
/*!40000 ALTER TABLE `students` DISABLE KEYS */;
INSERT INTO `students` 
VALUES 
(11637578,'Anthony',NULL,'Marquez',2017,'BTech',0,'Investigation','CSE','anthony.marquez@example.com',1234567890,1),
(12278656,'Angela','Daniel','Martin',2019,'BTech',0,'Documentation','ME','angela.martin@example.com',1234567891,1),
(14790536,'Daniel','Richard','Scott',2021,'MTech',0,'Calibration','MSE','daniel.scott@example.com',1234567892,1);
/*!40000 ALTER TABLE `students` ENABLE KEYS */;
UNLOCK TABLES;




LOCK TABLES `staff` WRITE;
/*!40000 ALTER TABLE `staff` DISABLE KEYS */;
INSERT INTO `staff` VALUES (1090324586,'Antonio','Candice','Fritz',21076.4,'Assistant','Anatomy Lab','antoniofritz@example.com',7513498620, 'https://drive.google.com/file/d/19uY3X76bigNjiPrmo-qrM6UUFvoXbNCc/view?usp=sharing', 'man wearing proffessional attire _ img1',1),
(1175259019,'Larry',NULL,'Clark',48988.8,'Researcher','Biochemistry Lab','larryclark@example.com',2385167904, 'https://drive.google.com/file/d/1UVrg23vtXXhAelbIsNwhuPQ60PapMhlK/view?usp=sharing', 'man wearing proffessional attire _ img2',1),
(1357028218,'Cody',NULL,'Lopez',38466.9,'Assistant','Biology Lab','codylopez@example.com',6975814320, 'https://drive.google.com/file/d/1UCkE2pw8BxXX4HAkfJ6hvuPbd5Hff7ww/view?usp=sharing', 'man wearing proffessional attire _ img3',1),
(1396986120,'Jessica',NULL,'Frost',71804.4,'Researcher','Botany Lab','jessicafrost@example.com',4297681053, 'https://drive.google.com/file/d/1rck0DeK398QA4zGW1cJANB5aupO1U0Qp/view?usp=sharing', 'man wearing proffessional attire _ img4',1);
/*!40000 ALTER TABLE `staff` ENABLE KEYS */;
UNLOCK TABLES;

3.3.2: Section-2 Dynamic Execution

1. INSERT:

a. ADMIN VIEW:

In course_slot table:

Before:

After:

In student table:

Add:

Before:

After:

2. UPDATE

a. ADMIN VIEW:

In student table:

Before:

After:

In Staff table:

Before:

After:

3. DELETE

a. ADMIN VIEW:

In student table:

Before:

After:

In Staff table:

Before:

After:

4. WHERE

a. ADMIN VIEW:

In lab_booking table:

Data:

Before:

After:

5. RENAME:

Data:

Before:

After:

Views:

1. Admin:

2. Staff:

3. Professor:

Profile:

4. Student:

profile:

Webpage:

Contributions:

Group 1

Manan Jain

• Created the front-end of the lab webpage.
• Used HTML to create the front-end structure of the lab webpage.
• Incorporated navbar and footer using Bootstrap.
• Applied CSS styling to enhance the visual appearance and utilized CSS techniques such as flexbox for responsive design.
• Contributed in the ReadMe file.

Anish Karnik

• Created templates related to Admin Page
• Worked on frontend of Profile page.
• Worked on client-side related renderings using Javascript.

Srujan Kumar Shetty

• Created API routes for checking availability of lab slots and equipments.
• Worked on different HTML templates.
• Helped in styling, password constraints.

Husain Malawat

• Worked on Hero page frontend.
• Contributed to ReadMe file.
• Helped in route testing, user authentication.

Group 2

Sachin Jalan

• Worked on flask integration with MySQL.
• Helped in testing routing and admin operations.
• Worked on routing of lab bookings, issue equipment.

Kaushal Kothiya

• Worked in backend implementation of the login and authentication system recognizing different user roles.
• Worked on designing backend routes.
• Helped in flask integration with MySQL.

Ameya Tajne

• Tested the webapp, views, and dynamic operations.
• Helped in debugging errors found during testing.
• Provided visual documentation of the program's execution in the ReadMe file.