Bachelor of Science in Computer Science & Engineering

Proposal for Hall Dining Management System

by
Dipannita Paul Orni
ID: 2104125

Umme Sanjida
ID: 2104126

Oarisa Rebayet
ID: 2104129

Department of Computer Science and Engineering

Chittagong University of Engineering and Technology (CUET)

Chattogram-4349, Bangladesh.

October, 2024
 Chittagong University of Engineering & Technology (CUET)

Department of Computer Science & Engineering

Chattogram-4349, Bangladesh.

Project Proposal
Application for the Approval of B.Sc. Engineering Project

Student Name : Dipannita Paul Orni

ID : 2104125

: Umme Sanjida

: 2104126

: Oarisa Rebayet

: 2104129

Session : 2021-2022

Supervisor Name : Md. Atiqul Islam Rizvi

Designation : Assistant Professor

: Department of Computer Science & Engineering

Department : Computer Science and Engineering

Program : B.Sc. Engineering

Tentative Title : Proposal for Hall Dining Management System

1
Table of Contents

Contents
1 Introduction 3

2 Motivation 3

3 Background Study 3
3.1 Key Features . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3
3.2 Drawbacks in existing system . . . . . . . . . . . . . . . . . . . . . . . . . 5
3.3 Potential Improvements . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5

4 Implementation and Technologies 5

4.1 Technologies used . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5
4.2 Implementation Plan . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6

5 Conclusion 8

2
1 Introduction
DineSmart, a web-based hostel dining management system is designed to simplify meal
validation, history tracking, and payment methods for students. This comprehensive
system streamlines manual processes by offering a platform where students can effortlessly
manage their meals and make payments online, ultimately enhancing the overall efficiency
of dining operations.

2 Motivation
Managing meals in a hostel can be challenging due to the manual processes involved with
meal tokens, communication with dining staff, and payment collection. One of the most
time-consuming tasks is paying for meals, often requiring students to spend hours waiting
in line. These inefficiencies cause frustration among students and staff, impacting the
quality of the dining experience. The motivation behind DineSmart is to digitize the
entire process, ensuring transparency and providing students with more control over their
dining options.

3 Background Study
Research has been conducted on an existing dining website of Khulna University of En-
gineering and Technology [1]. While this system provides dining management solutions,
it has several issues across various aspects. The study highlights the importance of an ef-
ficient dining management system, especially in a university environment where students
rely on timely access to meals and seamless payment procedures.

By analyzing these features, we aim to identify both the strengths and weaknesses of
the existing system, providing a basis for improvements in our own platform, DineSmart.

3.1 Key Features

The dining website of Khulna University of Engineering and Technology (KUET) focuses
on user-friendly navigation and the efficient management of dining services. Its main
features include:

3
• Meal Status: This section provides flexible meal planning where the users can
easily toggle their meal preferences on and off for each day based on individual
schedules.

• Payment Details: This section displays all pending dues for the student, including
fines, generator fees, water supply charges, and monthly feast costs.

• Account Security: Users have the option to update their login password in this
section, enhancing account security.

Figure 1: Home Page Interface Figure 2: Meal Scheduling View

Figure 3: Payment Details Figure 4: Change Password Option

4
3.2 Drawbacks in existing system

The existing site has several limitations that could be improved. The "Payment Details"
section displays dues but does not offer an option for online payments. This reliance on
manual payments complicates the payment process and nullifies the purpose of digitizing
the dining system. Furthermore, the absence of a feedback system restricts the ability to
gather insights on user satisfaction and areas for improvement. Implementing a feedback
feature could enhance the system’s responsiveness to student needs and preferences.
Additionally, a more comprehensive Settings menu could be integrated into the database
structure, allowing users to manage various account-related preferences instead of having
a separate option solely for changing the password.

3.3 Potential Improvements

To enhance the user experience, DineSmart could improve with some thoughtful updates.
One of the biggest improvements would be to introduce an online payment system that
integrates with the database. This change would ensure proper tracking of student dues
and eliminate the hassle of manual payments
Additionally, remodelling the “Settings” menu could enhance user account manage-
ment within the database. Instead of just a “Change Login Password” option, a more
comprehensive menu would let students manage their privacy settings in one place
Adding feedback features, such as meal rating systems, would allow data collection on
student preferences. This data could be analyzed to improve meal quality, thereby enhanc-
ing the overall dining experience. Overall, these improvements would make DineSmart a
friendly platform that supports the needs of its users.

4 Implementation and Technologies

4.1 Technologies used

To build the DineSmart (E-Hall Dining Management System), we will incorporate a se-
lection of technologies and tools, including:

• Frontend Development: HTML and CSS will be used to structure and style the
web pages, while JavaScript and React will be employed to create a dynamic and
responsive user interface.

5
 • Backend Development: Spring-boot (JAVA) will be used to manage the server-
side logic and database interactions.

• Database Management: MySQL will be used for storing user profiles, payment
details and other relevant data.

• Suitable IDE: We will utilize Visual Studio Code for the frontend development
with React, and IntelliJ IDEA for the backend development with Spring Boot.

4.2 Implementation Plan

• Week 1: Initial Discussions

– The project initiates with a series of meetings aiming to establish clear objec-
tives and expectations. Team members will identify their respective roles while
discussing initial ideas and outlining the project scope.

• Week 2: Research and Analysis

– The team will conduct research on existing dining management systems and
focus on gathering requirements through interviews with potential users to
understand their needs.

• Week 3: Proposal Documentation and Drafting the E-R Diagram

– A proposal will be drafted which will provide a comprehensive discussion on

the scope and methodology of the project.

– An Entity-Relationship diagram will be created to visually represent the data

model of the project, including the key entities along with their attributes
and relationships. Once it is prepared, it will be further reviewed for any
modifications before finalization.

6
• Week 4: Relational Mapping with Normalization

– The fourth week will focus on implementing relational mapping to organize

data into structured tables, ensuring relationships between entities are clearly
defined.

– Normalization will be applied to eliminate redundancy and maintain data in-

tegrity by dividing larger tables into smaller to optimize database performance.
This method will enable efficient data retrieval and reduce complications during
data manipulation.

• Week 5: Database Setup: Defining Entity Tables, Attributes, and Man-

aging Data Operations

– This week will focus entirely on converting the E-R diagram to a functional
database which involves creating tables and defining relationships between en-
tities.

– SQL commands will be written to insert data for each entity, retrieve meals by
hall and category, view payment history for each student, and compile a list of
feedback.

• Week 6: Data Validation and Query Optimization

– The team will implement data validation by establishing rules and constraints
to maintain data accuracy and integrity across all attributes. Queries will
be optimized by refining SQL statements and indexing frequently accessed
columns, ensuring efficient and rapid data retrieval.

• Week 7-8: Frontend-Backend Integration and API Development

– The team will develop RESTful APIs for essential functions such as user au-
thentication, meal retrieval, and payment updates, ensuring secure data access.

– Each API will undergo testing to validate data accuracy and security before
integration with the frontend.

7
 • Week 9: Testing and Security Enhancements

– The team will conduct comprehensive testing on all application features to

ensure functionality, including user login, meal selection, payment processing,
and feedback submission.

• Week 10: Documentation and Final Presentation

– Detailed documentation will be prepared, describing the system design, database

schema, and user guides.

– The project will conclude with a final presentation demonstrating the function-
ality of the system and highlighting the database design.

5 Conclusion
DineSmart (E-Hall Dining Management System) project is designed to improve the dining
experience for students by offering a user-friendly platform. By leveraging modern tech-
nologies such as React, Spring Boot, and MySQL, we seek to address the inefficiencies
of traditional meal management systems and provide a seamless payment process. By
incorporating features like flexible meal planning, real-time payment tracking, and robust
account security, DineSmart aims to create a comprehensive dining management solution
that prioritizes user satisfaction.

References
[1] KUET Hall Automation. (n.d.). Available at: https://hall.kuet.ac.bd