Download Database Testing Report: Analysis of System Functionality and Data Integrity and more Summaries Database Management Systems (DBMS) in PDF only on Docsity!
Test No Name/Form Being Tested Type of Test Expected Result Test Data Actual Result Pass / Fail Evaluatio n 1 Main Page Normal I was expecting to open the database Input fake Passwo rd Doesn’t open the Databas e Fail Then I input the right Password and the database is opened 2 Tbl_camp Erroneo us I was expecting Camp ID to be added to the system Enter Camp ID: 1999 Must be greater than 2000 Fail Then I input 2006 as a ID for a new camp and it added the record 3 Tbl_Wareho use Normal I'm expecting the blanket record will be deleted from the report Testing the integrity of databas e relations hip by deleting the row in a wareho use table. I will delete the blanket rows from the wareho use The blanket related record from the queries as well as from the report is deleted Pass 4 Agent_Form Normal The new record will I will add a The new record Pass
be add on the tbl_Agent new agent for shiva camp, that why in the agent_f orm I will add the agent ID, Agent Name, Camp Details and contact number will be added On the tbl_Agen t. All agent report will be updated as well. 5 Incident_For m Normal I’m expecting to see the new record on the incident table I will add a record for a new incident on the form The New incident added on the incident table. That means from the form we can update the table Pass 6 Tbl_Incident Extreme I was expecting the record will be added on the system Will test the data field of the table. I will try to input chittago ng banglad esh on It’s only allowed chittagon g not chittagon g banglad esh Fail On my incident table, the field size for the place of the incident was set for 10. And I
the number data type on the column system 10 Low_stock Query Erroneo us I was expecting water stock to come up Want to check the stock of the water from the queries of low stock Other records came up apart from the water record Fail From the design view of the low stock queries, I change the criteria of the low stock <2000 to < and the record for the water came up 1 st^ Test :
2 nd^ Test: 3 rd^ Test: No record for blanket on low stock update report, as blanket record delete from the warehouse table 4 th^ Test: A New Agent Oliver John is added for shiva camp 5 th^ Test: A new record for flood in Bangladesh is added on the Incident table
7 th^ Test:
8 th^ Test: 9 th^ Test: 10 th^ Test:
