Testcover.com - Tutorial - Database Table Example

	Testcover.com
		Tutorial - Database Table Example

Home
Existing User Login
Brochure
Sign up for Risk-Free Trial
About Testcover.com
Frequently Asked Questions
Tutorial with Examples
->Need for the Service
->Submitting Requests
->Reading Results
->Configuration Example
->Constraints Example
->Calendar Example
->Database Table Example
->Finite State Machine
->UML State Machine
->Definitions of Terms
Performance
WSDL Interface
Background
Partners
Registrations
Contact Information

The Database Table Example shows how to use the generator to create records for testing a reservation system. In this example multiple blocks are used to accommodate dependencies among the factor values.

The GreatM Motel Chain (a fictional company) is implementing an expansion program. It is building three new motels with innovative features and amenities. GreatM also is updating its reservation system to reflect these improvements. The software engineers working on the reservation system have migrated the old database to the new system for testing. However they need additional data to represent the motels under construction and their new features.

The motel room database table has columns (factors) as follows.

Test Factor		Number of Values	Test Factor Values
1.	Location ID	-	[unique motel identifier]
2.	Room ID	-	[unique room identifier]
3.	Room type	3	single standard suite
4.	Section	3	floor_1 mezzanine tower
5.	Smoking	2	no yes
6.	Beds	3	single 2_queen 1_king
7.	Convertible couch	2	no yes
8.	Near gym/spa	2	no yes
9.	Near business center	2	no yes
10.	Wi-fi	2	no yes
11.	Phone lines	2	1 2
12.	Balcony/patio	2	no yes

The engineers will use three Location ID values to represent the new motels. They will generate rows of data including all pairs of values for all the columns except the Room ID. (Each Room ID value should appear only once in the table.) The engineers will assign a single value as a Room ID placeholder to generate the rows. Then they will assign unique values to the Room IDs in the resulting rows (test cases).

The three Room types define the allowed values for the other columns as follows.

• Each single room is located on floor_1 or in the tower in any of the new motels. Smoking may or may not be allowed. The single room has a single bed and does not have a convertible couch. It is not near a gym/spa or a business center. The room does not have wi-fi, but it does have 1 phone line. It does not have a balcony/patio.

• Each standard room is located in any section of any of the new motels. Smoking may or may not be allowed. The standard room has either 2 queen size beds or 1 king size bed. It does not have a convertible couch. The standard room may or may not be near a gym/spa or a business center. The room may or may not have wi-fi, and it does have 1 phone line. The standard room may or may not have a balcony/patio.

• Each suite is located in the mezzanine or tower of any of the new motels. Smoking may or may not be allowed. The suite has 2 queen size beds and a convertible couch. The suite is near a gym/spa and a business center. It has wi-fi and 2 phone lines. The suite also has a balcony/patio.

These rules are described in the three blocks (one for each Room type) in the request below.
Database Table Example Location ID Room ID Room type Section Smoking Beds Convertible couch Near gym/spa Near business center Wi-fi Phone lines Balcony/patio # + single room location_1 location_2 location_3 room_ID single floor_1 tower no yes single no no no no 1 no + standard room location_1 location_2 location_3 room_ID standard floor_1 mezzanine tower no yes 2_queen 1_king no no yes no yes no yes 1 no yes + suite location_1 location_2 location_3 room_ID suite mezzanine tower no yes 2_queen yes yes yes yes 2 yes

The results table follows. All allowed pairs of factor values are included in the 15 test cases.

#1.

Test Case ID	Location ID	Room ID	Room type	Section	Smoking	Beds	Convertible couch	Near gym/spa	Near business center	Wi-fi	Phone lines	Balcony/patio	Combo Countdown
	3 Values	1 Value	3 Values	3 Values	2 Values	3 Values	2 Values	2 Values	2 Values	2 Values	2 Values	2 Values	332
1	location_1	room_ID	single	floor_1	no	single	no	no	no	no	1	no	266
2	location_2	room_ID	suite	mezzanine	yes	2_queen	yes	yes	yes	yes	2	yes	200
3	location_3	room_ID	standard	tower	no	1_king	no	no	yes	yes	1	yes	150
4	location_3	room_ID	standard	floor_1	yes	1_king	no	yes	no	no	1	no	120
5	location_2	room_ID	standard	tower	no	2_queen	no	no	no	no	1	no	99
6	location_1	room_ID	standard	mezzanine	no	1_king	no	yes	no	no	1	yes	84
7	location_1	room_ID	suite	tower	yes	2_queen	yes	yes	yes	yes	2	yes	71
8	location_3	room_ID	suite	tower	no	2_queen	yes	yes	yes	yes	2	yes	64
9	location_2	room_ID	single	floor_1	yes	single	no	no	no	no	1	no	58
10	location_3	room_ID	single	tower	no	single	no	no	no	no	1	no	54
11	location_3	room_ID	standard	mezzanine	no	2_queen	no	yes	no	yes	1	no	50
12	location_2	room_ID	standard	floor_1	no	1_king	no	yes	yes	no	1	yes	46
13	location_1	room_ID	standard	floor_1	yes	2_queen	no	no	yes	yes	1	yes	44
14	location_1	room_ID	standard	tower	yes	2_queen	no	yes	yes	yes	1	no	43
15	location_2	room_ID	standard	mezzanine	yes	2_queen	no	no	yes	yes	1	yes	42

After the unique Room ID values are set, the new rows for the database table are as given below.

Location ID	Room ID	Room type	Section	Smoking	Beds	Convertible couch	Near gym/spa	Near business center	Wi-fi	Phone lines	Balcony/patio
location_1	room_1	single	floor_1	no	single	no	no	no	no	1	no
location_2	room_2	suite	mezzanine	yes	2_queen	yes	yes	yes	yes	2	yes
location_3	room_3	standard	tower	no	1_king	no	no	yes	yes	1	yes
location_3	room_4	standard	floor_1	yes	1_king	no	yes	no	no	1	no
location_2	room_5	standard	tower	no	2_queen	no	no	no	no	1	no
location_1	room_6	standard	mezzanine	no	1_king	no	yes	no	no	1	yes
location_1	room_7	suite	tower	yes	2_queen	yes	yes	yes	yes	2	yes
location_3	room_8	suite	tower	no	2_queen	yes	yes	yes	yes	2	yes
location_2	room_9	single	floor_1	yes	single	no	no	no	no	1	no
location_3	room_10	single	tower	no	single	no	no	no	no	1	no
location_3	room_11	standard	mezzanine	no	2_queen	no	yes	no	yes	1	no
location_2	room_12	standard	floor_1	no	1_king	no	yes	yes	no	1	yes
location_1	room_13	standard	floor_1	yes	2_queen	no	no	yes	yes	1	yes
location_1	room_14	standard	tower	yes	2_queen	no	yes	yes	yes	1	no
location_2	room_15	standard	mezzanine	yes	2_queen	no	no	yes	yes	1	yes