TESTING PHASE
Testing Phase is the fourth phase of system development. It involves the system developer and user in the Testing Phase.
To ensure the quality of a database, the system developers act as quality controllers and will run tests on it.
The purpose of system testing is to ensure the system runs correctly and is error free.
DATA ENTRY IN TESTING PHASE
Before testing the database, data must be entered into the Tables. Enter data for four Tables : Author, Book, Category and Publisher.
TESTING ON DATABASE OBJECT
You can do the testing to verify that each database object is functioning.
You need to conduct testing to detect any error present.
TESTING ON FUNCTIONALITY OF THE SYSTEM
You can also conduct a test to verify that all systems work together properly.
EXTENSION : DATA VALIDATION
Validation is the process of comparing the data to a set of rules or values to
determine if the data is accurate.
For example, the quantity a user keyed in should be less or equal to 1000. The message will pop up if the quantity is over 1000.
A range check is another example of a validity check.
For example, the salary a user keyed in should be between 900 and 1500. The message will pop up if the salary is over 1500.
By implementing data validation, it minimises data entry errors.
