1,182
19
Coursework, 2 pages (500 words)

Database test plan of nfrcentraldatabase

Systems science – Database Test Plan
This here is the test plan to be used to test the NFRCentralDatabase. The NFRCentralDatabase is used by the New Forest Retreat Hotel Management System to manage the daily operation of the hotel and its various departments, as well as to generate reports which are used by the administrators of the hotel to perform various functions. The system uses other databases for instance, the database that keep the employee information and data. However, the test will not be on those databases but the NFRCentralDatabase which holds most of the business function data. The other databases would be tested but they are out of this scope of test.
Test Number
Type of Test
Reason
Test Data
Expected Results
1
Input Data into a number field in the client form
This is in order to check the validity as well as error detection
To show number fields will only accept numbers
ABC
12345
ABC is rejected because it is not a number
12345 is accepted because it is a number
2
Input data into a text field
To show that the field is long enough in order to accept a long name
Nahamasema Perihilton Apu
Accepted
3
Leave a field blank
To test and show that the field should not be left blank. For instance a payment field for inputting the credit card number must be filled in.
Blank space
Rejected when submitting the form
4
Validity test
To show that the correct information has been entered
Wrong credit card number
Rejected
5.
Choose a room number from a menu
To show that the database updates correctly. This will enable the system to indicate the vacant rooms and the occupied ones in the resort.
An occupied room number
Rejected
6
Date test
To test that invalid values for dates are rejected
10/35/1897
Rejected
7
Staff verification test
To see if the privileges for each staff has been implemented
Log in a temporary staff member as a permanent member of staff
Rejected
It is not always to have all the information required for a testing plan. This is because most of the users or clients are not techno savvy. Therefore, there needs to be time to take them through the process and to train them on what is required.
While designing the test plan, I assume that as the designer I know all about the hotel management system the resort is using and all the activities the resort is involved in. this is not possible because the resort has a lot of departments and keeping tabs on all of them is not possible. The system itself has to be maintained from time to time in order to incorporate additional functionality.
Justification of the Testing Plan
This strategy of testing the database is very important because it reveals all the problems that the system may have and be corrected before the system is actually rolled out for use. It involves a business and therefore mistakes cannot be allowed since that would literally lead to losses because money is involved. Additionally, this test plan implementation is cost effective as it involves a small team of people.
References
Waugh, Rick. Test Plan for a Database. New York: Wiley, 2012.

Thank's for Your Vote!
Database test plan of nfrcentraldatabase. Page 1
Database test plan of nfrcentraldatabase. Page 2
Database test plan of nfrcentraldatabase. Page 3
Database test plan of nfrcentraldatabase. Page 4

This work, titled "Database test plan of nfrcentraldatabase" was written and willingly shared by a fellow student. This sample can be utilized as a research and reference resource to aid in the writing of your own work. Any use of the work that does not include an appropriate citation is banned.

If you are the owner of this work and don’t want it to be published on AssignBuster, request its removal.

Request Removal
Cite this Coursework

References

AssignBuster. (2021) 'Database test plan of nfrcentraldatabase'. 25 December.

Reference

AssignBuster. (2021, December 25). Database test plan of nfrcentraldatabase. Retrieved from https://assignbuster.com/database-test-plan-of-nfrcentraldatabase/

References

AssignBuster. 2021. "Database test plan of nfrcentraldatabase." December 25, 2021. https://assignbuster.com/database-test-plan-of-nfrcentraldatabase/.

1. AssignBuster. "Database test plan of nfrcentraldatabase." December 25, 2021. https://assignbuster.com/database-test-plan-of-nfrcentraldatabase/.


Bibliography


AssignBuster. "Database test plan of nfrcentraldatabase." December 25, 2021. https://assignbuster.com/database-test-plan-of-nfrcentraldatabase/.

Work Cited

"Database test plan of nfrcentraldatabase." AssignBuster, 25 Dec. 2021, assignbuster.com/database-test-plan-of-nfrcentraldatabase/.

Get in Touch

Please, let us know if you have any ideas on improving Database test plan of nfrcentraldatabase, or our service. We will be happy to hear what you think: [email protected]