Messroom: Sourav Das Swarnali Saha Rahul Pal
Messroom: Sourav Das Swarnali Saha Rahul Pal
Messroom: Sourav Das Swarnali Saha Rahul Pal
APPENDIX 1
MESSROOM
A PROJECT REPORT
Submitted by
Sourav das
Swarnali saha
Rahul pal
degree of
Bachelor’s of science
in
Computer Science
August 2022
Page 2 of 42
ACKNOWLEDGEMENT
Apart from the efforts of team, the success of any project depends largely on
the encouragement and guidelines of many others. We take this opportunity
to express our gratitude to the people who have been instrumental in the
successful completion of this project.
The completion of any inter-disciplinary project depends upon cooperation,
co-ordination and combined efforts of several sources of knowledge.
We are eternally grateful to our PROF. BIJAN KRISHNA PAUL for his
even willingness to give us valuable advice and direction under which we
executed this project. His constant guidance and willingness to share his vast
knowledge made us understand this project and its manifestations in great
depths and helped us to complete the assigned tasks.
Page 3 of 42
APPENDIX 2
BONAFIDE CERTIFICATE
Certified that this project report “ MessRoom ” is the bonafide work of “Sourav das
, Swarnali saha , Rahul pal ” who carried out the project work under my supervision.
Certified further that to the best of my knowledge the work reported herein does not
form part of any other thesis or dissertation on the basis of which a degree or award
was conferred on an earlier occasion on this or any other candidate.
DECLARATION
APPENDIX 3
TABLE OF CONTENTS
1 INTRODUCTION 8
1.1 PROJECT AIMS AND OBJECTIVE 8
2 SYSTEM ANALYSIS 9
2.1 SOFTWARE REQUIREMENT ANALYSIS
2.1.1 PROJECT TITLE 9
2.1.2 CATEGORY 9
2.1.3 PURPOSE 9
2.1.4 SCOPE 9
2.1.5 EXISTING SYSTEM 9
2.1.6 PROPOSED SYSTEM 9-10
2.1.7 ADVANTAGES PAYING GUEST 10
2.1.8 ADVANTAGES LANDLORD 10
2.1.9 FUNCTIONAL REQUIREMENT 10-12
2.1.10 NON-FUNCTIONAL REQUIREMENT 13
2.2 SOFTWARE TOOLS 13
2.3 DATABASE 13
2.4 DEPLOYMENT 13
2.5 HARDWARE SPECIFICATIONS 13
2.6 SOFTWARE COMPONENT 13 – 16
5 CONCLUSION 37
6 PROBLEM FORMULATION 38
7 LIMITATIONS 39
8 FUTURE SCOPE 40
9 BIBLIOGRAPHY 41
Page 7 of 42
ABSTRACT
This project is based on fulfilling the need for changing and developing environments.
In this busy world a person doesn’t have enough time to search things manually. This
project helps a person to find mees or pg according to his/her convince. Manual process
takes ample amount of time and person has to visit place to place in order to search for
a good mess or Pg. In the older process many time it is seen that a 3 rd party person or
organization also participates and sometimes it hampers the whole process. With the
new system I.E by searching the mess or Pg by our website will save time and also
doesn’t include ay 3rd party person or organization. MESSROOM is a very easy and
user friendly platform where anyone who is searching for mess or Pg can search
according to his/her convince and contact directly to the owner with zero interference.
Page 8 of 42
CHAPTER 1:
INTRODUCTION
THIS CHAPTER GIVES A BASIC INTRODUCTION AN OVERVIEW OF
THE AIMS AND OBJECTIVE OF THE PROJECT OF THE PROJECT .
“ Don’t you hate it when it come to wastage of your precious time …! ” This is the case when it
come to search for a Mess or Pg in an older process I.E searching manually by travelling from one
place to another place. MessRoom is a project developed by Sourav das , Swarnali Saha and Rahul
pal of Department of Computer Science of Bhairab Ganguly College where you can search Mess or
Pg according to your choice and convenience. Now forget about the older process and search Mess
or Pg just by a click sitting at you home. There are some other proposed solutions as well but those
are complex to use. Here comes our solution I.E MessRoom which is user friendly and easy to use
and also doesn’t include any kind of 3rd party person or organization which makes the whole process
seamless. On the MessRoom website you can book your Mess or Pg directly by contacting the
owner and can also view the ratings given by the previous residents. MessRoom also keeps the safety
of their user, on our website all the owners are verified.
The aim and objectives of the project that will be achieved after the
completion of the project are discussed below
i. Dedicated for users like students , working professional , guests.
ii. Easy to use and user friendly.
iii. Can contact the owner directly
iv. No intervention of 3rd party or organization.
v. Verified owners.
vi. Updated portal with many more facilities for owners.
Page 9 of 42
CHAPTER2:
SYSTEM ANALYSIS
2.1.2 CATEGORY
Web application
2.1.3 PURPOSE
The purpose of Mess & Pg finding web portal is to bridge the gap between
Mess & Pg owner and the user with easy user interface and to find the best
suitable Mess or Pg according to their location and budget.
2.1.4 SCOPE
The scope is to make the user interface more friendly and easy to use. The user
will be able to search Mess or Pg without the interference of any 3rd party. This
web application connects the user directly to the owner so that the user does not
have to search manually. The user gets benefits like Mess or Pg in their budget ,
convenience , according to their location , separate for girls , boys , working
professionals , couples.
The proposed system gives the user benefit as the user can watch all the necessary
information just on a device with a single login.
2.3 Database
For development: MySQL
For Production: PostgreSQL
2.4 DEPLOYMENT
PaaS: Heroku
The whole Project is divided in two parts the front end and the back end.
Frontend technologies
for frontend we have used HTML , CSS and JavaScript
Backend technologies
for backend we have used Ruby on Rails (RoR) and for database we used MySQL.
HTML
CSS
Cascading Style Sheets (CSS) is a style sheet language used for describing
the look and formatting of a document written in a markup
language. While most often used to style web pages and interfaces
written in HTML and XHTML, the
language can be applied to any kind of XML document, including plain XML,
SVG and XUL. CSS is a cornerstone specification of the web and almost all web
pages use CSS style sheets to describe their presentation.CSS is designed
primarily to enable the separation of document
content from document presentation, including elements such as
the layout, colors, and fonts. This separation can improve content
accessibility, provide more
flexibility and control in the specification. of presentation characteristics, enable
multiple pages to share formatting, and reduce complexity and repetition in the
structural content (such as by allowing for table less
web design).CSS can also allow the same markup page to be presented in different
styles for different rendering methods, such as on-screen, in print, by voice (when
14 read out by a speech-based browser or screen reader) and on Braille-based,
tactile devices. It can also be used to allow the web page to display differently
depending on the screen size or device on which it is being viewed. While the
author of a document typically links that document to a CSS file, readers can use a
different style sheet, perhaps one on their own computer, to override the one the
author has specified. However, if the author or the reader did not link the document
to a specific style sheet the default style of the browser will be applied.
JavaScript:
MYSQL
MySQL ("My S-Q-L", officially, but also called "My Sequel") is (as of July
2013) the world's second most widely used open-source relational
database management system (RDBMS). It is named after co-founder
Page 16 of 42
Michael Widenius daughter, My. The SQL phrase stands for Structured
Query Language. The MySQL development project has made its source
code available under the terms of the GNU General Public License, as
well as under a variety
of proprietary agreements. MySQL was owned and sponsored by a
single for-profit firm, the Swedish company MySQL AB, now owned by
Oracle Corporation
.MySQL is a popular choice of database for use in web applications, and
is a central component of the widely used LAMP open source web
application software stack (and other 'AMP' stacks). LAMP is an
acronym for "Linux, Apache, MySQL, Perl/PHP/Python." Free-
software-open source projects that require a full-featured database
management system often use MySQL. For commercial use, several paid
editions are available, and offer additional functionali
Page 17 of 42
CHAPTER 3
WATERFALL MODEL
A study was undertaken for the minimum hardware configuration which consists
of windows 7 a multiuser system with 4 GB RAM , 512 GB of SSD/HDD , one
cd driver . At a time 3 USB’S can be inserted of 3.0 and 2.0 type.
The system has software’s like subline text version 4 , chrome version
103.0.5060.66 , xampp version 7.4.29 / Rails 6.1.5 , ruby 3.0.2p107 (2021-07-07
revision 0db68f0233) , draw SQL.
This shows that technically it is feasible to get the required hardware, software and
a person having complete understanding of the requirements to develop the
software package.
websites.
Cocomo
The operational feasibility study was carried out on the basis of comparison
between existing system and the proposed system
It is found that proposed system works well and fulfill all the criteria that a
student , working professionals , guests wanted. A simple and easy to use to use
system where a person can book his/her Mess or pg sitting at on place and without
the intervention of any 3rd party person or organization.
The analysis research says that some people who are students , guests , working
professionals who wants to rent a mess or pg just for few months or years want a
simple and easy and user friendly system. Now in the research we have also found
that owners or landlords used to face a lots of problems as they were not having an
updated system where they could have all their relevant information at one place.
In this chapter we will discuss about the design i.e table/database , DFD , ER ,
UML diagrams
Page 19 of 42
is
destroy
Update
Read
Delete
Page 20 of 42
username,email,(username,name),(username,phone),(email,name),(email,phone)
rating table (user_id,mess_id)
Mess table:
foreign key :user_id
Reviews table:
foreign key: user_id,mess_id
Ratings table:
foreign key: user_id,mess_id
Page 21 of 42
LEVEL 0
Mess Booking
LEVEL 1
0.8
Request to Rate Request to Rate
Rating &
& Review Mess & Review Mess
Review Mess
0.7
Request to book Request to book 0.3
Booking
Mess Mess Mess info
Mess Upload
Mess
0.4 0.5
Sign Up to make
User Record
Sign Up to make
Normal User Owner Account
Mess Record
Account 0.6
Edit Edit & Edit
manage
Account
User details 0.1
User details
Search by Landmark Search
user
Search by City Mess or PG Mess info
Admin
Page 22 of 42
0.3.1
Owner Sign up to make
Owner Account 0.3.4 Mess info Update
Update Mess
Acknowledgement
0.3.5
Mess info Delete
Delete Mess
Acknowledgement
0.7.1 0.7.2
User Sign in Booking
Confirmation
Contact Mail
Owner Owner
Mess Owner
Page 23 of 42
0.8.3
User details
Delete
Review info delete
0.8.1 Review
0.8.6
Sign in
Update Mess Review
Details Record
0.8.4
Rating Mess Rating info
Rating Record
Rating info
0.8.5
Update
Rating Rating info update
0.9.3
Response Response Response
through Mail
0.9.1
Write Message with Admin
user Message to
name, mail id Admin
Request to Successful or
view message unsuccessful
Acknowledgement
Message info
0.9.2
View
Message
Contact Record
Page 24 of 42
0.10.1 Request
Request to update mess info
Update Mess Acknowledgement
Successful or unsuccessful info
Acknowledgement
0.10.2 Request
Request to read mess info
Read Mess info
Successful or unsuccessful Acknowledgement
Acknowledgement Mess Record
0.10.5
Request to read user info User Record
Read User
Successful or unsuccessful info
Acknowledgement
Users Table
Page 26 of 42
Mess table
Page 27 of 42
Page 28 of 42
Ratings table
Page 29 of 42
Reviews table
Page 30 of 42
Contacts table
3.5 TESTING
1. Unit Testing.
2. White box
testing
3. Black Box testing
Unit testing
Unit testing focuses efforts on the smallest unit of software design. This is
known as module testing. The modules are tested separately. The test is carried out
during programming stage itself. In this step, each module is found to be
working satisfactory as regards to the expected output from the module.
TC1:LOGIN
TC 4 : Mess upload
Serial Input value Test case Conditon being result
no checked
1 Title Empty Title can’t be Passed
blank
2 Description Empty Description can’t Passed
be blank
3 Price Empty Price can’t be Passed
empty
4 Address Empty Address can’t be Passed
empty
5 State Empty State can’t be Passed
empty
6 City Empty City can’t be Passed
empty
7 Landmark Empty Landmark can’t Passed
be empty
8 Images Empty Images can’t be Passed
blank
9 Description Charectors Charectors must Passed
less than 20 be greater than
entered 20.
10 Images Uploaded Only upload Passed
more than 5 images less than
images or equal 5.
TC 5 : REVIEW
Serial no Input value Test case Condition Result
being
checked
1 Review filed Empty Review field Passed
can’t be
empty
2 Review field Without login User must be Passed
logged in to
review
Page 35 of 42
TC 6 :RATING
TC 7 : CONTACT OWNER
3.5.1 MAINTAIENCE
For search feature there was a problem of case sensitivity . Case sensitivity was
fixed by adding down case method to the search parameters.
This process was looked and verified through Maintenance
Page 36 of 42
CHAPTER 4
COST ESTIMATION
The cost estimation plays a major role is the software development. Cost
estimation can be done in various ways. Here we have done the estimation using
cocomo
4.1 cocomo
Lines of Code=3832 =3.832K
Semi-Detached Model:
Effort = 3.0*(3.832)1.12 person-months
= 13.51 person-month
Intermediate COCOMO:
Efforts = 3 * (3.832)1.12 *EAF person-months
[as all cost driver parameters’ values are NOMINAL.
= 13.51 person-month so, EAF( Effort Adjustment Factor) = 1]
Chapter 5
Conclusion
The final conclusion is that MessRoom is a simple and easy to use website
where you can easily book your Mess or Pg. Though there are various existing
solution but those are either very old process i.e the manual searching process
which ultimately consumes lots of time and travel and also lacks some features.
Other than there are some existing websites which also provides similar
facilities but those websites are little complex and not user friendly for all types
of users and those also includes some facilities that a student or a working
professional don’t require so it becomes complex to use for them.
Page 38 of 42
CHAPTER 6
PROBLEM FORMULATION
Although there are some existing solutions yet they have many problems.
There are two types of existing solution
1. The old process I.E the manual searching process
2. Some existing websites that provides similar facilities
The problem with the old process is that a person has to travel from one
place to other place in order to search for a good mess or pg. with this
process it consumes a lot of time and travel cost and also lacks a lot of
features. Person can’t be able to contact the previews resident in order to
know the review. Also the problems lies with the owners or landlords as
they have to spend a lot of money on advertising their property and also
they don’t have the feature to save all their relevant information at one
place.
The problem with the existing website is those websites are little complex
to use as they also includes features like buying , selling , developing and
many other facilities which makes a little complex for users like students ,
guests , working professionals. The above mentioned users requires a easy
and user friendly website.
Page 39 of 42
CHAPTER 7
LIMITATIONS
The system is not equipped with geolocation service. User can contact the
owner and book the mess or pg no online booking facilities available. The
system doesn’t contains any chat system. The system is not equipped with
automatic detection of mess. Spam checking is also to be done manually.
Page 40 of 42
CHAPTER 8
FUTURE SCOPE
The future scope cosists of chat with customer care 24x7. In future users
will get location based suggestion. Artificial intelligence will be
integrated. Spam checking will be done through AI which will be more
secure and accurate. Some premium models will be introduced. Users will
be able to search more accurately through more filters. Automatic
moderation , users will be able to get a 360 view of the mees or pg.
Page 41 of 42
CHAPTER 9
BIBLIOGRAPHY
1. https://guides.rubyonrails.org/
2. https://fontawesome.com/search?q=box&s=solid%2Cbrands
3. stackoverflow.com
4. https://uigradients.com/
5. codetabs.com
6. github.com
7. https://heroku.com/
8. https://www.javatpoint.com/
9. https://www.w3schools.com/w3css/defaulT.asp
10.https://www.geeksforgeeks.org/css/
Page 42 of 42