Online HMS
Online HMS
Online HMS
WEB BASED
ONLINE HOSTEL MANAGEMENT
SYSTEM
A PROJECT
Submitted by
Mr. Dineshkumar Mulchandani
Jun-2015
DECLARATION
Date:
Place:
Seal of Institute
iii
PROJECT APPROVAL
Date:
Place:
1)
2)
3)
iv
ACKNOWLEDGEMENT
I fall short of words to pen down anything for
Place: Signature:
Date: Name:
v
LIST OF TABLES
Table Page
No. Description No.
5 Cost of assets 20
10 Users Table 43
11 Hostellers Table 45
12 Room Table 46
13 FeePayment Table 47
14 Admin Table 47
15 Rector Table 48
16 Registration Table 49
vi
LIST OF FIGURES
Page
Figure Description No.
No.
1 Iterative Model 9
2 Gantt Chart 13
Title Page i
Declaration of Originality ii
Certificate iii
Project Approval iv
Acknowledgement v
List of Tables vi
List of Figures vii
Table of Content viii
CHAPTER 1: INTRODUCTION.1
1.1 PROJECT
SUMMARY2
1.2 PROJECT
PROFILE.3
1.3 PURPOSE
.4
1.4 SCOPE.
..5
1.5 TECHNOLOGY AND LITERATURE
REVIEW6
viii
CHAPTER 4: PROCESS DESIGN..23
4.1INPUT DESIGN..23
4.1.1 ADMINISTRATOR..
23
4.2OUTPUT DESIGN..............................................................23
4.3DATABASE DESIGN24
4.4ARCHITECTURAL DESIGN25
4.5PROCESS DESIGN....25
4.5.1 DATA FLOW DIAGRAMS (DFD).
25
4.5.2 USE CASE DIAGRAMS.....
.28
4.5.3 ACTIVITY
DIAGRAMS. 32
4.5.4 CLASS DIAGRAMS
...33
4.5.5 STATE DIAGRAMS
...35
4.5.6 SEQUENCE
DIAGRAMS...36
CHAPTER 6: TESTING..50
CHAPTER 9: CONCLUSION.65
1. INTRODUCTION
Through this you can check the personal profile of all the
current students within few minutes the data base of the system
will help you to check a particular one.
The system will help you to check the mess bills of every
student and the students hostel dues. The students of the hostel
will be recognized from the ID number allocated at the room
rental time. In the last this system will improve the management
work in the hostel.
Front End
Used ASP.NET (Web Application UI)
1.3 PURPOSE
1.4 SCOPE
The web based user interface have certain limits to deal with
speed and immigration performance of the web site.
Project team had visited the new little flower hostel located
at Sabarmati, Ahmedabad for review the current existing
system.
2. PROJECT MANAGEMENT
2.1 PROJECT PLANNING AND
SCHEDULING
WEB APPLICATION:
Page|7
Online Hostel Management System
Resources with needed skill set are not available and are
planned to be used on contract basis for specific iterations.
There are some high risk features and goals which may
change in the future.
The following table lists out the pros and cons of Iterative and
Incremental SDLC Model:
Pros Cons
Chang Definin
Less costly to e the g increments may
definitio o
scope/requirements. require n f the
complete system.
Issues & risks identified from Projects progress is highly
each increment can be
resolved dependent upon the risk
to the next analysis
increment. phase.
P a g e | 11
Online Hostel Management System
ANALYSIS:
DESIGN:
CODING:
TESTING:
GANTT CHART:
Then the design for new system takes brief analysis on the
components that can be used to implement whole product.
So it takes 45 days to design all diagrams and relevant data
flow designs of the system.
Next comes to design layout and UI for the web application and
it takes only 15 days to design graphical on paper designs of
the web application.
P a g e | 13
Online Hostel Management System
TIME
REQUIRED TASK TO BE DONE
P a g e | 14
Online Hostel Management System
Analysis of existing
Task -1 Completion level system
with database design
Task -4 Implementation
part Development of web
interface in ASP.Net with
back-end as SQL SERVER.
P a g e | 15
Online Hostel Management System
Internal risks are project risks, process risks, and product risks.
External risks are generally business with the vendor,
technical risks, customers satisfaction, political stability and
so on.
REQUIREMENT RISKS:
a. Lack of analysis for change of requirements.
b. Change extension of requirements.
c. Lack of report for requirements.
d. Poor definition of requirements.
e. Ambiguity of requirements.
f. Change of requirements.
g. Inadequate of requirements.
h. Impossible requirements.
i. Invalid requirements.
P a g e | 17
Online Hostel Management System
ECONOMICAL RISKS:
1. Lack of good estimation in projects
2. Unrealistic schedule
3. The hardware does not work well
4. Complexity of new architecture
5. Large size of required architecture
6. Extension of requirements change
7. The tools does not work well
8. Personnel change, Management change, technology change,
and environment change
9. Lack of reassessment of management cycle.
OPERATIONAL RISKS:
1. Inadequate budget
2. Change of requirements and extension of requirements
3. Human errors
4. Lack of employment of manager experience
5. Lack of enough skill
6. Lack of good estimation in projects
QUALITY RISKS:
1. Inadequate documentation
2. Lack of project standard
3. Lack of design documentation
4. Inadequate budget
5. Human errors
6. Unrealistic schedule
7. Extension of requirements change
8. Poor definition of requirements
9. Lack of enough skill
10. Lack of testing and good estimation in projects
11. Inadequate knowledge about techniques, programming
language, tools, and so on
STRATEGIES FOR RISK MANAGEMENT:
P a g e | 18
Online Hostel Management System
2.3 ESTIMATION:
Web application cost estimation process is a set of techniques
and procedures that is used to derive the web application cost
estimate. There is usually a set of inputs to the process and
then the process uses these inputs to generate or calculate a
set of outputs.
Cost driver is anything that may or will affect the cost of the
web application. Cost driver are things such as design
methodology, skill-levels, risk assessment, personnel
experience, programming language or system complexity.
P a g e | 19
Online Hostel Management System
Applicable cost in
Physical assets & rupees
deliverabl
es
Computer machines 50000
Optical
disks 500
Developing platform 5000
Office
goods 2000
Maintenance of
systems 5000
Internet/communicatio
n 5000
devices
Paper work & stationary
assets 1000
Total Estimated
Amount 68500
Table 5 cost of assets
P a g e | 20
Online Hostel Management System
Cost Very
Category Driver Low Low Nominal High Very Extra
High High
Product Required 0.75 0.88 1.00 1.15 1.40 -
Attributes Software
Reliability
Database - 0.94 1.00 1.08 1.16 -
Size
Product 0.70 0.85 1.00 1.15 1.30 1.65
Complexity
Computer Execution - - 1.00 1.11 1.30 1.66
Attributes Time
Constraint
Main - - 1.00 1.06 1.21 1.56
Storage
Constraint
Computer - 0.87 1.00 1.07 1.15 -
Turnaround
Time
Table 6 cost driver of
attributes
Cost
Category Driver Very Low Nominal High Very Extra
Low High High
P a g e | 21
Online Hostel Management System
3. SYSTEM REQUIREMENT
STUDY
3.1 REQUIREMENTS
Language : C#
Web browser
Web utilities
P a g e | 22
Online Hostel Management System
4. SYSTEM DESIGN
4.1.1 ADMINISTRATOR:
The Administrator can allot students to the hostel.
He/she can change their rooms, edit and delete the student
records.
The goal of input data design is to make data entry base easy,
logical and free from errors as possible.
They are
A. Menus.
B. Dialog Boxes.
Overall Diagrams:
4.5.1 DATA FLOW DIAGRAM(s) [D. F. D.]:
The data flow diagrams are pictorial or graphical
representation of the outline of the system study.
The data flow diagram covers all the processes and data
storage area, which takes place during any transaction in the
system. The data flow diagrams are functionally divided into
context level, Zero level, and First level and Second level data
flow diagrams.
P a g e | 25
Online Hostel Management System
(4) Data store: Any store data but with no reference to the
physical method of storing.
P a g e | 26
Online Hostel Management System
UNIVERSITY/ FUNDING
GOVERNMENT AGENCY
HOSTEL
Rules &
Regulation MANAGEMENT Request
Hostel
Information SYSTEM Fulfill
DFD LEVEL-1
DIAGRAMS:
1.0 Send Student
Registration Details Hosteler
Form Registration Receipts
STUDENT
Registration
4.0
STUDENT
Information
Confirmation
Confirm flag
P a g e | 27
Online Hostel Management System
STUDEN Registration
T 1.1
Info Updated
Registration
as new user
Inquiry
P a g e | 29
Online Hostel Management System
P a g e | 30
Online Hostel Management System
P a g e | 31
Online Hostel Management System
P a g e | 32
Online Hostel Management System
P a g e | 34
Online Hostel Management System
P a g e | 35
Online Hostel Management System
P a g e | 36
Online Hostel Management System
5. DATA DICTIONARY
P a g e | 37
Online Hostel Management System
This step also gives knowledge of different data types used for
different field and their size. All the normalized tables are
showed in data storage.
Data Flow stage shows the flow of data in the system. This
step is can be already seen in the data flow diagrams above in
this document.
So, it refers to all the data flow paths were transactions are
done in the computerized system.
Table: users
password Password
Table
: room_data
Table: rectors
P a g e | 39
Online Hostel Management System
Table
: Feepayment
Table: hostellers
hosteler_approximate_te
rm Term / duration
Table: Admin
Attribute
Name Usage Of Attribute
Users: -
Objective: The users table contains the information about the
different users and their passwords, which are used to access the
system as there is more than one owner in the factory and they
can access data privately. The table stores the data as username
and password and thus provides security to the system. This
table also contains the administrator user and its password, so all
the rights are provided to the administrator and some rights are
not provided by the system to some local users.
Tables Referred: users
Table Format:
field field
name description Type size null
Unique id as user
Username id Nvarchar(50) 50 Not allowed
Hostellers: -
Objective: The Status table contains the information about the
Student & his/her guardians and parents details.
Tables Referred: Hostellers
Table Format:
Contact no
mother_mob_no of Double 10 Yes
mother
Nvarchar(max
hosteler_address Address of ) N Yes
hosteler
Room_data: -
Objective: The Room_data table contains the information about
the Room whether the there related detail.
Tables Referred: Room_data
Table Format:
Field
name field description type size Null?
Feepayment :-
Objective: The Fees table contains the information about the
Student Fees description.
Tables Referred: Fees
Table Format:
Nvarcha
Username Unique Id of user r 10 Not
(Primary key) allowed
Admin :-
Objective: The Admin table contains the information about the
Administrator person.
Tables Referred: Admin
Table Format:
field
name field description type size Null?
User id of the account Nvarcha
Username holder r 20 Not
allowed
Name of the Nvarcha
Name administrator r 50 yes
rectors :-
Objective: The table contains the Personal information about the
Employee.
Tables Referred: Employee_info
Table Format:
field
name field description type size Null?
Username User id of account Nvarcha Not
holder r 20 allowed
Name Nvarcha
Employee Name r 50 Yes
Age Age Double 6 Yes
Address Nvarcha
Address of emp r n Yes
Phone Mobile number of
employee number 10 Yes
Date_of_joi Joining date of
n employee date 10 Yes
Registration: -
Objective: The registration table contains the information about
the basic details of account holder to register.
Tables Referred: registration
Table Format:
field
name Field description type size Null?
username Nvarcha
Unique user id of account r 20 Not
holder allowed
Password Password of user Nvarcha 20 Not
allowed
P a g e | 48
Online Hostel Management System
Name Nvarcha
Student / employee name r 50 yes
Contact_no Contact number of
account Double 10 Yes
holder
Table 16 Registration
Table
Validations:
The table does not allow to the user to enter blank field those are
required as those fields are not null and it will show an error
message if the any of the field which is required is kept null by
the user while doing any transaction using this table.
Primary Key: username
Reference Key:-
Image_Details :-
Objective: The image details table contains the information
about the image profile photo for the Account holder.
Tables Referred: Image_Details
Table Format:
Field
name Field description type size Null?
Image_id Image id for each Nvarcha Not
image r 50 allowed
Image_Nam Nvarcha
e Name of the pic/ image r 50 Yes
Image Actual location of the Nvarcha Not
image r N allowed
6. TESTING
1) Functionality Testing:
This is the test for all the links in web pages, database
connection, forms used in the web pages for submitting or
getting information from user, Cookie testing.
Forms are the integral part of any web site. Forms are used to
get information from users and to keep interaction with them.
So we had checked many things on these forms as below:
o We had checked all the validations on
each field. o We had checked for the
default values of fields.
o We had tested for wrong inputs to the fields in the forms.
o Options to create forms if any, form delete, view or modify
the forms.
Database testing:
o Data consistency is very important in web application. So,
we did have checked for data integrity and errors while we
edit, delete, modify the forms or do any DB related
functionality.
o In that case, we had checked that if all the database
queries are executing correctly, data is retrieved correctly
and also updated correctly.
2) Usability Testing:
Test for navigation:
o In an navigation test we got that how the user surfs the
web pages,
different controls like buttons, boxes or how user using the
links on the pages to surf different pages.
Content checking:
o Content should be logical and easy to understand. Check
for spelling errors. Use of dark colors annoys users and
should not be used in site theme. You can follow some
standards that are used for web page and content building.
These are common accepted standards like as I
mentioned above about annoying colors, fonts, frames etc.
o Content should be meaningful. All the anchor text links
should be working properly. Images should be placed properly
with proper sizes. o These are some basic standards that
should be followed in web
development. Your task is to validate all for UI testing.
3) Compatibility Testing:
Compatibility of our web site is very important testing aspect.
So, we had checked many compatibility aspects as listed as
below:
o Browser compatibility
o Operating system
compatibility o Mobile
browsing
o Printing options
o Browser compatibility:
P a g e | 51
Online Hostel Management System
OS compatibility:
o Some functionality in our web application is may not be
compatible with all operating systems. All new
technologies used in web development like graphics
designs, interface calls like different APIs
may not be available in all Operating Systems.
o So, we had tested application on different operating
systems like Windows, UNIX, MAC, Linux, and Solaris with
different OS flavors.
Mobile browsing:
o While testing web pages on mobile browsers, there were no
any compatibility issues exists on mobile.
4) Security Testing:
For example: Hosteller can view their own data and own
records only at the hosteller login. And if rector gets logged in
with his/her credentials he/she will access whole data of
hosteller and can view, insert, update, delete specific data.
As shown in the screen shot the home page contains the main
view to be represented to the guest as well as online visitors.
P a g e | 54
Online Hostel Management System
P a g e | 56
Online Hostel Management System
P a g e | 57
Online Hostel Management System
P a g e | 58
Online Hostel Management System
When user will click on generate pdf of this data it will make
pdf and gives to user to print or download file.
P a g e | 59
Online Hostel Management System
As shown in screen shot above the rector will login with his/her
allocated user id and password and it will redirects to the
Rector Portal of the website.
P a g e | 60
Online Hostel Management System
P a g e | 62
Online Hostel Management System
And we had seen that contact us and about us page that are
virtually mounted in each page of web application whether
user is guest or specific hosteller they can contact to office at
any time by just clicking over the
about us in the main menu of page or just clicking over the
communication info from the main menu of web application.
P a g e | 63
Online Hostel Management System
8. FUTURE PLAN
Notifications.
o Semicircular notifications.
hostel mobility.
payment facilities.
security alerts.
P a g e | 64
Online Hostel Management System
9. CONCLUSION
Asp. [Online] :
o http://www.asp.net.
asp.net-tutorials. [Online] :
o http:// www.asp.net-tutorials.com
Code project.[Online]:
o http://www.codeproject.com/KB/aspnet/
Css-tricks. [Online]:
o http://css-tricks.com
msdn.microsoft.[Online]:
o http://msdn.microsoft.com/en-
us/aa336522.aspx
w3schools.[Online]:
o http://www.w3schools.com/aspnet/
P a g e | 66