Assessment Evaluation

For Hotel Reservation System (HRS)

Version 1.0

Submitted in partial fulfillment of the requirements for the degree of Master of Software Engineering

Cem Oguzhan

CIS 895 – MSE Project

Kansas State University

Table of Contents

1. Introduction 3

2. Test Case Result Summary 3

3. Test Case Result Detail 3

3.1. Find Hotel Web Form (Search Room) 3

3.2. Sign In Web Form (Login) 4

3.3. Request Account Web Form (Travel Agent) 5

3.4. Sales Report Web Form (Travel Agent) 6

3.5. Create New Account Form (Customer) 6

3.6. Cancel Reservation Web Form 8

3.7. Add Hotel Web Form 8

3.8. Update Hotel Web Form 9

3.9. Add Room Web Form 10

3.10. Update Room Web Form 11

3.11. Approve Travel Agent Form 11

4. Performance Testing 12

5. Performance Analyze 14

6. Scalability 16

1.  Introduction

This document shows the result of Test Case’s defined in the Test Plan.

Reference:

·  Test Plan 1.3

2.  Test Case Result Summary

Feature Identifier / Description / SR’s Tested / Result
T-001 / Search Room / 3.2.1 / Passed
T-002 / Login / 3.2.2 / Passed
T-003 / Apply for an Account (Travel Agent) / 3.2.3 / Passed
T-004 / Generate Report(Travel Agent) / 3.2.4 / Passed
T-005 / New Customer Register / 3.2.5 / Passed
T-006 / Cancel a Reservation / 3.2.7 / Passed
T-007 / Add/Update a Hotel / 3.2.8 / Passed
T-008 / Add/Update a Room / 3.2.9 / Passed
T-009 / Approve/Disapprove Travel Agent Account / 3.2.10 / Passed

3.  Test Case Result Detail

3.1.  Find Hotel Web Form (Search Room)

Test Unit / Test Case / Result
btnFind / Empty city name / Prompts the user to enter city name
Message: Please enter city
Empty check in date / Prompts the user to enter a check in date
Message: Please enter check in date
Empty check out date / Prompts the user to enter a check out date
Message: Please enter check out date
Enter wrong format data in check in text box / Prompts the user to enter a correct format check in date
Message: Please enter check-in date format mm/dd/yyyy
Enter wrong format data in check out text box / Prompts the user to enter a correct format check out
date
Message : Please enter check-out date format mm/dd/yyyy
Check in date is a past date / Prompts the user to enter a right check in date
Message: Please enter a check in date today's date or later date
Check out date is earlier than or same as check in date / Prompts the user to enter a right check out date
Message: Check Out date can not be earlier/equal than Check In Date
Enter wrong type of data in max. price text box / Prompts the user to enter a right type of data
Message: Please enter decimal number
Correct data in each field / The user will be directed to HotelResult.aspx

3.2.  Sign In Web Form (Login)

Test Unit / Test Case / Result
btnSignIn / Empty user name / Prompts the user to enter user name
Message: Please enter user name
Empty password / Prompts the user to enter password
Message: Please enter password
Invalid user name / Prompts the user to enter valid user name
Message : User name or password is not correct
Invalid password / Prompts the user to enter valid password
Message : User name or password is not correct
Correct data in each field / The user will be directed to requested secure page. If the user didn’t request any secure page, the user will be directed to Default.aspx

3.3.  Request Account Web Form (Travel Agent)

Test Unit / Test Case / Result
btnSubmit / Empty user name / Prompts the user to enter user name
Message: Please enter an user name
Empty password / Prompts the user to enter password
Message: Please enter a password
Empty e-mail address / Prompts the user to the enter email address
Message: Please enter an e-mail address
e-mail address is not correct format / Prompts the user to enter correct format e-mail address
Message: Please enter an e-mail address in format
Empty company name / Prompts the user to enter company name
Message: Please enter company name
Empty address / Prompts the user to enter address
Message: Please enter address
Empty city name / Prompts the user to enter city name
Message: Please enter city
Empty postal code / Prompts the user enter zip code
Message: Please enter zip code
Non- numeric data in postal code or numeric number length less than 5 digits / Prompts the user enter numeric value
Message: 5 digit
Empty phone number / Prompts the user to enter phone number
Message: Please enter phone number
Phone number is not correct format / Prompts the user to enter
phone number in correct format
Message: Please enter home phone number in the format “xxx-xxx-xxxx”
Correct data in each field. / The data is saved into the database and an e-mail sent to the user. The user directed to Confirm Request account page

3.4.  Sales Report Web Form (Travel Agent)

Test Unit / Test Case / Result
btnSubmit / Empty starting date / Prompts the user to enter starting date
Message: Please enter starting date of sales report
Empty ending date / Prompts the user to enter ending date
Message: Please enter ending date of sales report
Ending date is earlier than starting date / Prompts the user to enter correct data
Message: Ending Date can not be equal or less than starting date
Correct data in each field / The user allows to generate sales report

3.5.  Create New Account Form (Customer)

Test Unit / Test Case / Result
btnSubmit / Empty user id / Prompts the user to enter user id
Message: Please enter an user id
Empty password / Prompts the user to enter password
Message: Please enter a password
Empty e-mail address / Prompts the user to the enter email address
Message: Please enter an e-mail address
e-mail address is not correct format / Prompts the user to enter correct format e-mail address
Message: Please enter an e-mail address in format
Empty first name / Prompts the user to enter name
Message: Please enter first name
Empty last name / Prompts the user to enter last name
Message: Please enter last name
Empty address / Prompts the user to enter address
Message: Please enter address
Empty city / Prompts the user to enter to city
Empty postal code / Prompts the user to enter zip code
Message: Please enter zip code
Non- numeric data in postal code or numeric number length less than 5 digits / Prompts the user to enter numeric value
Message: 5 digit
Empty credit card number / Prompts the user to enter credit card number
Message: Please enter credit card number
Non- numeric data in credit card number or numeric number length less than 16 digits / Prompts the user to enter credit card number
Message: Please enter sixteen digit number
Correct data in each field / If the user id is valid. The user inputs are saved into the database and the user login to the HRS system

3.6.  Cancel Reservation Web Form

Test Unit / Test Case / Result
btnFind / Empty reservation number / Prompts the user to enter the reservation number
Message: Please enter reservation number
None numeric reservation number / Prompts the user to enter valid reservation number
Message: Please enter positive integer number
Invalid reservation number / Prompts the user to enter valid reservation number
Message: The reservation number you enter is not valid
Valid reservation number / The valid reservation information is displayed
btnCancel / The reservation will be deleted from the database. The user will be directed ConfirmCancelReservation.aspx for confirmation

3.7.  Add Hotel Web Form

Test Unit / Test Case / Result
btnAddHotel / Empty hotel id / Prompts the administrator to enter hotel id
Message: Please enter hotel id
Empty hotel name / Prompts the administrator to enter hotel name
Message: Please enter hotel name
Empty phone number / Prompts the administrator to enter phone number
Message: Please enter phone number
Phone number is not correct format / Prompts the administrator to enter phone number in correct format
Message: Please enter phone number XXX-XXX-XXXX format
Empty address / Prompts the administrator to enter address
Message: Message: Please enter address
Empty city / Prompts the administrator to enter city
Message: Please enter city
Empty postal code / Prompts the administrator to enter zip code
Message: Please enter zip code
Non- numeric data in postal code or numeric number length less than 5 digits / Prompts the administrator to enter numeric value
Message: 5 digit
Correct data in each field / If the hotel id is valid, the inputs will be saved into the database. The administrator will be directed ConfirmAddHotel.aspx

3.8.  Update Hotel Web Form

Test Unit / Test Case / Result
btnFind / Empty hotel id / Prompts the administrator to enter hotel id
Message: Please enter hotel id
None numeric hotel id / Prompts the administrator to enter valid hotel id
Message: Please enter positive integer number
Invalid hotel id / Prompts the administrator to enter valid hotel id
Message: The hotel id is not valid
Valid hotel id / The hotel information will be displayed
btnUpdate / The hotel information will be updated in the database. The administrator will be directed ConfirmUpdateHotel.aspx

3.9.  Add Room Web Form

Test Unit / Test Case / Result
btnFind / Empty hotel id / Prompts the administrator to enter hotel id
Message: Please enter hotel id
None numeric hotel id / Prompts the administrator to enter valid hotel id
Message: Please enter positive integer number
Invalid hotel id / Prompts the administrator to enter valid hotel id
Message: The hotel id is not valid
Valid hotel id / The hotel name and adding room form will be displayed
btnAddRoom / Empty door number / Prompts the administrator to enter door number
Message: Please enter door number
Non numeric door number / Prompts the administrator to enter valid door number
Message: Please enter integer number for door number
Empty room price / Prompts the administrator to enter room price
Message: Please enter room price
Non numeric room price value / Prompts the administrator to enter valid room price
Message: Please enter decimal number for room price
Correct data in each field / The room inputs will be saved into the database. The confirmation message will be displayed on the same page

3.10. Update Room Web Form

Test Unit / Test Case / Result
btnFind / Empty hotel id / Prompts the administrator to enter hotel id
Message: Please enter hotel id
None numeric hotel id / Prompts the administrator to enter valid hotel id
Message: Please enter positive integer number
Invalid hotel id / Prompts the administrator to enter valid hotel id
Message: The hotel id is not valid
Valid hotel id / The hotel name and edit room form will be displayed
btnEdit / Data grid room will be changed for editing
btnUpdate / Empty room price / Prompts the administrator to enter room price
Message: Please enter decimal number for price
None numeric room price / Prompts the administrator to enter room price
Message: Please enter decimal number for price
Valid Rom Price / The updated room inputs will be saved into the database. The confirmation message will be displayed
btnCancel / The updated room inputs will not be saved into the database. Data grid room will be changed to display room information

3.11.  Approve Travel Agent Form

Test Unit / Test Case / Result
btnApprove / The travel agent’s status will be changed ‘waiting’ to ‘approve’. The travel agent’s will be received an e-mail regarding status of its account. The travel agent can use the HRS
btnDisApprove / The travel agent’s status will be changed ‘waiting’ to ‘disapprove’. The travel agent’s will be received an e-mail regarding status of its account. The travel agent can not access the HRS

4.  Performance Testing

The performance testing was performed by using Jakarta JMeter. The test case below is used for the performance testing.

·  Search hotel

·  List hotels for particular search

·  Select an hotel

·  List available rooms

·  Reserve rooms

·  Login

·  Place the reservation

·  Display confirmation numbers

The below screen shots illustrate the performance testing results in the graph.

.

For 1 user:

For 10 users:

For 30 users:

The below table show the performance testing results.

1 user * 14 Http Request * 5 Repeat / 10 user * 14 Http Request * 5 Repeat / 30 user * 14 Http Request * 5 Repeat
Deviation / 17 / 113 / 223
Throughput / 1606.73/min / 1548.72/min / 2792.24 /min
Average / 33 / 372 / 526

The throughput number represents the actual number of requests/minute the server handled. Deviation and average is displayed in millisecond (ms) in the above table. If the deviation is high, some users will have good response time from the system while other users will have long response time from the system. The smaller deviation value is better. The average value represents the average amount time taken to load a particular page.