Designing and Development of Database Testing Tool

Abstract

Tool enable user to perform all the operations from the beginning of data definition which includes Creating, Altering, Dropping and Truncate of table to the data manipulation that includes Selecting, Inserting, Updating and deleting of data, which is followed by controlling them that is commit and reset. In Data Definition we have commands of Creating and dropping of databases followed by creation of tables within a database. And it also allows altering the contents of table either by adding column(s) or removing them. Along with this, user can truncate the table that is removing the whole content of a table. In data manipulation, user has the provision of selecting a specific amount of data from a table by using " where " clause in the command of view data. User can also view data from different table(s) of databases by using sub-queries and join commands according to the requirement. User can insert, update and delete a number of data items whenever and whichever required. At any instance user has a provision of commit and reset of transaction.