TC Name: Country Master Table Objective: To test the data validations of Country Master Table TC ID
Test Case check field CountryID for 1 data validation.
Validation Should allow only entry to numeric data (0-9) Should allow entry to only numeric data (0-9) Should allow only entry to numeric data (0-9)
1 2 check field CountryID for new
3 key generation
CountryID should be unique
4
CountryID should be unique
check for referential integrity CountryID should follow 5 of CountryID Referential integrity
Test Data enter A-Z enter a-z enter special characters insert a new row in table delete an existing row and insert a new row try to delete a row having a linking row in StateMaster Table
CountryID should follow Referential integrity
Modify an existing CountryID
10
Should allow any alphanumeric characters except any special characters CountryName should not be more than 100 characters CountryName is mandatory and cannot be NULL CountryName is mandatory and cannot be blank
Should allow any alphanumeric characters except any special characters enter any name exceeding 100 chars Insert a new row in table leaving CountryName as NULL Insert a new row in table leaving CountryName as blank spaces
check field CountryID for new 11 key generation
insert a new row with CountryName = 'India'. Now insert another new CountryName should be unique row with CountryName = 'India'
6 check field CountryName for 7 data validation.
8 9
Check field Currency for data 12 validations check for referential integrity of 13 CountryID check field AppName for data 14 validation check field HostName for data 15 validations
16 check field CreateDate for data
17 validations
Should allow any alphanumeric characters except any special characters Curreny should not be more than 5 characters
enter any special characters other than (A-Z, a-z, 0-9, space and single quote try to delete a row having a linking row in CityMaster Table should allow any data should allow any data should allow any data try to enter any data not in date format
18 functional validation
insert a new row in table to check if this field should trac which the field automatically takes the application inserted the new row name of the application, using what or modified the existing row the row has been inserted
19
modify an existing row in table to check if the field automatically this field should trac which takes the name of the application, application inserted the new row using what the row has been or modified the existing row modified
check field AppName for
20 functional validation
insert a new row in table to check if this field should trac from which the field automatically takes the computer the new row has been name of the computer from which inserted or modified the row has been inserted
21
modify an existing row in table to check if the field automatically this field should trac from which takes the name of the computer computer the new row has been from which the row has been inserted or modified modified
22 functional validation
insert a new row in table to check if this field should trac the user the field automatically takes the name who has inserted the new name of the user who inserted the row or modified an existing row new row
23
modify an existing row in table to this field should trac the user check if the field automatically name who has inserted the new takes the name of the user who row or modified an existing row modified the existing row
24 functional validation
insert a new row in table to check if this field should trac the date on the field automatically takes the which the new row has been date on which the row has been inserted inserted
check field HostName for
check field UserName for
check field ModifyDate for
25 26 27 28 29 30 31
Modify an existing row in table to this field should trac the date on check if the field automatically which the new row has been takes the date on which the row has inserted been Modified
Remarks should not accept the test data should not accept the test data should not accept the test data should generate a new CountryID the deleted row's CountryID should not be repeated Should not allow to delete the record Should not allow to modify the record
should not accept the test data should not accept data more than 100 chars should not allow to insert a new row should not allow to insert a new row
should not accpet same country name twice
should not accept the test data should not accept data more than 5 chars should allow any data should allow any data should allow any data should not accept the test data on a new row entry, this field should automatically take the name of application using what the row has been inserted e.g. if a new row has been inserted using MySQL query browser, this field should show 'My SQL query browser' on modifying the row, this field should automatically take the name of application using what the row has been modified e.g. if the row has been modified using c# application Vista NE-DSS, this field should show 'Vista NE-DSS'
on a new row entry, this field should automatically take the name of computer from which the row has been inserted e.g. if a new row has been inserted from COMP1, this field should show 'COMP1' on modifying the row, this field should automatically take the name of computer from which the row has been modified e.g. if the row has been modified from SERVER1, this field should show 'SERVER1' on a new row entry, this field should automatically take the name of the user who inserted the new row e.g. if a new row has been inserted by User1, this field should show 'User1' on modifying the row, this field should automatically take the name of the user who has modified the row e.g. if user User2 has modified the row this field should show 'User2' on a new row entry, this field should automatically take the date on which the row has been inserted on modifying an existing row entry, this field should automatically take the date on which the row has been modified
TC NAME : STATE MASTER TABLE OBJECTIVE : TO TEST THE FUNCTIONALITY OF THE STATE MASTER TABLE
TC ID
TEST CASE check state id field for data 1 validation
VALIDATION
TEST DATA
3
Should allow entry to only numeric data (0-9) enter A-Z Should allow only entry to numeric data (0-9) enter a-z Should allow only entry to numeric data (0-9) enter special characters
check state name field for 4 data validation
Should allow any alphanumeric characters except any special characters
Should allow any alphanumeric characters except any special characters
5
CountryName should not be more than 100 characters
enter any name exceeding 100 chars
6
CountryName is mandatory and cannot be NULL
Insert a new row in table leaving CountryName as NULL
2
CountryName is mandatory and cannot be 7 blank check field CountryID for data Should allow only entry to 8 validation. numeric data (0-9) Should allow only entry to 9 numeric data (0-9) Should allow only entry to 10 numeric data (0-9) check field CountryID for new CountryID should be 11 key generation unique CountryID should be 12 unique check for referential integrity CountryID should follow 13 of CountryID Referential integrity CountryID should follow 14 Referential integrity
Insert a new row in table leaving CountryName as blank spaces enter A-Z enter a-z enter special characters insert a new row in table delete an existing row and insert a new row try to delete a row having a linking row in CityMaster Table Modify an existing CountryID
Should allow any alphanumeric characters check field CountryName for except any special 15 data validation. characters
Should allow any alphanumeric characters except any special characters
16
CountryName should not be more than 100 characters
enter any name exceeding 100 chars
17
CountryName is mandatory and cannot be NULL
Insert a new row in table leaving CountryName as NULL
18
CountryName is mandatory and cannot be blank
Insert a new row in table leaving CountryName as blank spaces
Check field CountryName for CountryName should be unique
19 unique key constraint
insert a new row with CountryName = 'India'. Now insert another new row with CountryName = 'India'
check field AppName for data
20 validation
should allow any data
check field HostName for 21 data validations check field UserName for 22 data validations check field CreateDate for 23 data validations
should allow any data should allow any data try to enter any data not in date format
24 functional validation
this field should trac which application inserted the new row or modified the existing row
insert a new row in table to check if the field automatically takes the name of the application, using what the row has been inserted but not more then 45 VARCHAR
25
this field should trac which application inserted the new row or modified the existing row
modify an existing row in table to check if the field automatically takes the name of the application, using what the row has been modified
26 functional validation
this field should trac from which computer the new row has been inserted or modified
insert a new row in table to check if the field automatically takes the name of the computer from which the row has been inserted and not more then 45 VARCHAR
27
this field should trac from which computer the new row has been inserted or modified
modify an existing row in table to check if the field automatically takes the name of the computer from which the row has been modified
28 functional validation
this field should trac the user name who has inserted the new row or modified an existing row
insert a new row in table to check if the field automatically takes the name of the user who inserted the new row & not more then 45 VARCHAR
29
this field should trac the user name who has inserted the new row or modified an existing row
modify an existing row in table to check if the field automatically takes the name of the user who modified the existing row
check field AppName for
check field HostName for
check field UserName for
30 functional validation
insert a new row in table to check this field should trac the if the field automatically takes the date on which the new row date on which the row has been has been inserted inserted
31
Modify an existing row in table to this field should trac the check if the field automatically date on which the new row takes the date on which the row has been inserted has been Modified
check field ModifyDate for
EXPECTED RESULTS should not accept the test data should not accept the test data should not accept the test data
should not accept the test data should not accept data more than 100 chars should not allow to insert a new row should not allow to insert a new row should not accept the test data should not accept the test data should not accept the test data should generate a new CountryID the deleted row's CountryID should not be repeated Should not allow to delete the record Should not allow to modify the record
should not accept the test data should not accept data more than 100 chars should not allow to insert a new row should not allow to insert a new row
should not accpet same country name twice
ACTUAL RESULT
SUCCESS/FAILURE
REMARKS/SUGGES SIONS
should allow any data should allow any data should allow any data It should not be accepted on a new row entry, this field should automatically take the name of application using what the row has been inserted e.g. if a new row has been inserted using MySQL query browser, this field should show 'My SQL query browser' And it should not accept more then 45 V ARCHAR on modifying the row, this field should automatically take the name of application using what the row has been modified e.g. if the row has been modified using c# application Vista NEDSS, this field should show 'Vista NE-DSS' on a new row entry, this field should automatically take the name of computer from which the row has been inserted & it should not accept more then 45 VARCHAR e.g. if a new row has been inserted from COMP1, this field should show 'COMP1' on modifying the row, this field should automatically take the name of computer from which the row has been modified e.g. if the row has been modified from SERVER1, this field should show 'SERVER1' on a new row entry, this field should automatically take the name of the user who inserted the new row & should not accept more then 45VARCHAR e.g. if a new row has been inserted by User1, this field should show 'User1' on modifying the row, this field should automatically take the name of the user who has modified the row e.g. if user User2 has modified the row this field should show 'User2'
on a new row entry, this field should automatically take the date on which the row has been inserted on modifying an existing row entry, this field should automatically take the date on which the row has been modified
TC NAME : CITY MASTER TABLE OBJECTIVE: TO TEST THE FUNCTIONALITY OF THE CITY MASTER TABLE
TC ID
TEST CASE Check the chain id for 1 data validation 2 check for referential integrity of state master 3 table 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
VALIDATION TEST DATA Should allow only entry to integer data (0-9) Enter A-Z,a-z,) Should allow only entry to integer data (0-9) Enter (0-9)
EXPECTED RESULT should not accept the test data It should accept the integer value
REMARKS/SUGGESS ACTUAL RESULT SUCCESS/FAILURE IONS