When we comes to management reports normally those reports are generated by

When we comes to management reports normally those

This preview shows page 55 - 58 out of 84 pages.

When we comes to management reports normally those reports are generated by database queries. Currently we are having many report making software tools to make simplify the report generating process. But always database queries are the back end of those simplifying tools. Therefore finally reports are result of queries and they are really important to any organization to take their decisions for their developments. Task 1.12 Describe what database is testing and explain why it is important to your database. (LO 4.1) What is database testing? 54 Sandeep Rahan Hettiarachchi
Image of page 55
Data Analysis & Design HND COM/55/02 Database testing is system that we are applying to a database to assure the quality of the database while storing and receiving the data inside and outside from the database. Basically the purpose of a database is storing the data within the given scope of the database and output the relevant information as requested. Therefore it’s important to store the data as it is and out put the correct information that the user required. Or else simply it can define accuracy is the one of most key component what the user expecting from a database. For an simple example if user needs to insert sales values of 30 days and get the first two weeks total sales value as the output the database should have an ability to store the 30 days sales value as it is respectively and should return the sum of first 14 days sales values as user requested correctly. Therefore to secure the database accuracy, security and improve its performance database testing needs to be done. Followings things are testing under database testing. Data Validity Data Integrity Performance related to database Database procedures, triggers and functions Why database testing is important to my database. As I mentioned earlier database testing is used to assure the quality of the database. It checks the possible criteria’s which should have in a good database. There can be certain errors, bugs while we are creating a database, updating database and receive data from the database. For examples: Wrong data types might have used to create tables Wrong character lengths might have used to create tables Key relationships might not declare properly Wrong triggers, conditions might have set. Table might named incorrectly and etc. Therefore to avoid those kind of mistakes and secure my database security, accuracy, reliability and performance database I believe database testing is being really important to me. Because finally to maintaining error free database it’s must to do database testing in relevant stages. 55 Sandeep Rahan Hettiarachchi
Image of page 56
Data Analysis & Design HND COM/55/02 Task 1.13 Complete database test using proper test cases. (LO 4.2) Data base test cases are used to check the standard of the database by checking given conditions are working properly. A test case is containing followings.
Image of page 57
Image of page 58

You've reached the end of your free preview.

Want to read all 84 pages?

  • Winter '14

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture