StudentShare
Contact Us
Sign In / Sign Up for FREE
Search
Go to advanced search...
Free

Database Test Plan of NFRCentralDatabase - Coursework Example

Cite this document
Summary
The paper "Database Test Plan of NFRCentralDatabase" describes that 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. …
Download full paper File format: .doc, available for editing
GRAB THE BEST PAPER93.2% of users find it useful
Database Test Plan of NFRCentralDatabase
Read Text Preview

Extract of sample "Database Test Plan of NFRCentralDatabase"

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.

Read More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“Database Test Plan of NFRCentralDatabase Coursework”, n.d.)
Database Test Plan of NFRCentralDatabase Coursework. Retrieved from https://studentshare.org/systems-science/1596067-create-a-sample-test-plan-for-a-new-database-a-template-is-available-in-the-attachment
(Database Test Plan of NFRCentralDatabase Coursework)
Database Test Plan of NFRCentralDatabase Coursework. https://studentshare.org/systems-science/1596067-create-a-sample-test-plan-for-a-new-database-a-template-is-available-in-the-attachment.
“Database Test Plan of NFRCentralDatabase Coursework”, n.d. https://studentshare.org/systems-science/1596067-create-a-sample-test-plan-for-a-new-database-a-template-is-available-in-the-attachment.
  • Cited: 0 times

CHECK THESE SAMPLES OF Database Test Plan of NFRCentralDatabase

Principles of Good Database

What is a work plan?... work plan is helpful to outline troubles within the office, and enhance workers awareness and attention.... In other words, a work plan is a typical company's administration tool for scheduling functions during a specific period (Shiota).... Definition of Work plan.... The main research questions are:  What is a database?... What is a transactional or online transactional processing database?...
4 Pages (1000 words) Research Paper

What are the tradeoffs between relational and object-oriented databases and database management systems

This section of the paper will present a detailed analysis of some of the important aspects of relational, object-oriented databases and database management systems.... This section also outlines tradeoffs between relational, object-oriented databases and database management systems.... hellip; Tradeoffs between relational and object-oriented databases and database management systems ... DBMS or RDBMS This section of the paper will present a detailed analysis of some of the important aspects of relational, object-oriented databases and database management systems....
7 Pages (1750 words) Essay

Happy Homes Database System

Happy Homes database System Name: Date: database security The security of a database system should be up to date.... The data held by a database is of great importance and loss or damage to that data could result into great consequences to the organization.... Happy Homes Ltd has a database for the storage, access, and management of information required for its normal operations.... hellip; To enhance the security of the database, several key concepts have to be looked at and properly set....
6 Pages (1500 words) Coursework

Analysis of Relational Databases and Database Suitability

Once a backup plan is developed using its maintenance is of great importance.... A flat database contains only one table.... A database which contains one or several related tables is referred to as a relational database (Harrington, 2002).... In a relational database, symbols are organized into a collection of relations.... The construction of a relational database is built around the concepts of relations....
4 Pages (1000 words) Essay

Databases and Database Systems

The author of the following essay "Databases and database Systems" highlights that Databases and database systems have become an essential component of everyday life in modern society.... In the course of the day, most of us encounter several activities that involve some interaction with a database.... hellip; Banking operations, hotel and airlines reservation, a computerized library catalog to search or Internet vendor through its web page, all such activities involve someone or some computer program accessing a database....
5 Pages (1250 words) Essay

Database Security

The paper "database Security" states that generally, database security needs stem from the requirement to protect data.... The DBMSs provide an interface that enables users to interact with the database itself, other applications for capturing and analyzing data (Oppel, 2004).... database security is concerned with aspects aimed at protecting the contents of the database, users and owners.... The protection ranges from system protection against software and hardware malfunction to intentional and unauthorized use of the database and unintentional access by entities not authorized....
12 Pages (3000 words) Coursework

Distributive Database Capabilities Comparison

Definite methods can be employed by BAS to pick up their databases grounds… SQL applications can be enhanced in the BAS Computer using certain tools that can boost the performance of the database employed by Microsoft Corporation.... Other database performance enhancing methodologies usually call for a profile within the system that reports the data obtained and utilized in changing fine directories The Simultaneous multithreading (SMT) processing develops the computer by sustaining cord level parallelism on one superscalar mainframe (Quick Transport Solutions, Inc....
6 Pages (1500 words) Research Paper

Oracle Database Tuning Plan

This report "Oracle Database Tuning plan" sheds some light on the database performance tuning that is necessitated by existing bottlenecks that require making appropriate changes in the configuration of the database to reduce or eliminate.... Tuning is mostly done as a reaction response to a problem either before or after the database system has been deployed.... In tuning the database, a database administrator must come up with a strategy that outlines the performance tuning methodology that is supported by the software making up the DBMS....
7 Pages (1750 words) Report
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.
Contact Us