Database Test Plan of NFRCentralDatabase - Coursework Example

Systems science - Database Test PlanThis 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 NumberType of TestReasonTest DataExpected Results1Input Data into a number field in the client form This is in order to check the validity as well as error detectionTo show number fields will only accept numbersABC12345ABC is rejected because it is not a number12345 is accepted because it is a number2Input data into a text field To show that the field is long enough in order to accept a long nameNahamasema Perihilton ApuAccepted3Leave a field blankTo 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 spaceRejected when submitting the form4Validity testTo show that the correct information has been enteredWrong credit card numberRejected 5. Choose a room number from a menuTo 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 numberRejected 6Date testTo test that invalid values for dates are rejected10/35/1897Rejected 7Staff verification testTo see if the privileges for each staff has been implementedLog in a temporary staff member as a permanent member of staffRejected 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 PlanThis 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.