DATA MANIPULATION OPERATION - Mobile App

Click here for Introduction.

Mobile App

1. REFRESH/UPDATE

You can easily refresh gmail app or update data by clicking button or by swip down

2. DELETE

 If you want to delete the mail then first you select that mail and then press delete button

3. INSERT

If you want to insert files in a drive application then you can easily upload that file from upload button

4. SELECT

 You can easily select data

Testing Checklist  For  Web Application

		Tick
I can easily sort data
All input parameters are validated
I can easily remove data through button
Data is automatically update
Data can easily update through refresh button
I can easily upload data in web application
Is a list view used to allow a collection of items that are on a single hierarchical level, such as files or folders, to be displayed and manipulated?
I can easily remove specific data from applications
Are meaningful, concise messages provided when an error or problem exists?
Are optional and mandatory fields marked clearly on the screen?
Is the cursor blinking to first textbox by pressing f5 key?
Is the data removed by pressing delete key?
I can easily choose data by dropdown menu
Is the placeholder text clear or meaningful?
Is it throw an exception while inserting the data?
Is it show the progress bar while uploading files?
Is it show the status (uploaded or not) after uploading files?
Is it allow to stop during uploading files?
Is it allow for uploading multiple files at a time ?
Is it take time for response?
I can easily search specific data

Testing Checklist For GUI

	Tick
Is the static text clear, concise, and meaningful?
Does static text follow the project standards for consistent placement on the screen (e.g., field labels to the left of an entry field)?
I can easily sort data by applying conditions
Are standards followed for mouse and keyboard navigation, manipulation, and interaction (e.g., TAB, SHIFT+TAB, double-click, selection of elements and objects, drag and drop)?
I can easily insert data through button
Is it show the alert dialogue box for asking delete file after pressing delete key ?
I can easily remove specific data by backspace key
I can easily choose data by dropdown menu
I can easily search specific data
Is it allow for copy the data  by ctrl +c key ?
Is it allow for paste the data by ctrl +v key?
Is it restore the file if the pc suddenly shutdown?
I can easily rename the file
Is it take time for response?
Is it easily insert images?

Testing  Checklist For  Mobile Application

	Tick
Is the screen well organized and easy to use?
Are the fields and objects properly aligned?
Is keypad is open for insertion  when fingertip touch on screen
Is mobile app auto update or not
Is the Placeholder text clear and meaningful?
Is the functionality of all buttons work properly?
Does the Text are concise and meaningful?
Is it throw an exception while opening an app?
Is it throw an exception while inserting data ?
I can easily remove specific data from applications.
Is it show the alert dialogue box for asking delete data after pressing delete button ?
Is it allow for copy the data?
Is it allow for paste the data?
Is it show the progress bar while uploading files?
Is it show the status (uploaded or not)after uploading files?
Is it allow to stop during uploading files?
Is it allow for uploading multiple files at a time ?
Is it take time for response?
I can easily search specific data

Written by,

Rameeshah Shahid

DATA MANIPULATION OPERATION - Web Application

Click here for Introduction.

Web Application

1. DELETE

If you tick the checkbox then you are able to delete the selected data

  

2. UPDATE

If you press the refresh button your new mails added in applications

3. INSERT

If you want to create a new account then you would have to type your id if your id already exist in their database then they will recommend some id which is similar to your id.

Your password must match the confirm password and must be at least 8 characters other it will not create id

If you want to upload files in drive then you would have to press button and easily upload any kind of file

Written by,

Rameeshah Shahid

DATA MANIPULATION OPERATION - Desktop App

Click here for Introduction.

Desktop App

1. SELECT

Following are the steps  to organized data in a meaningful form.

When the Conditional Formatting Rules Manager window appears, click on the "New Rule" button to enter the first condition.

When the New Formatting Rule window appears, select Format only top or bottom ranked values as the rule type.
Then select Top in the first drop down, and enter 1 in the final box. In our example, we've selected only the first top value.
Next, we need to select what formatting to apply when this condition is met. To do this, click on the Format button.

When the Format Cells window appears, select the Fill tab. Then select the color that you'd like to see for the highest value in the range. In this example, we've selected green. Then click on the OK button.

When you return to the New Formatting Rule window, you should see the preview of the formatting in the Preview box. In this example, the preview box shows green as the fill color. Next click on the OK button.

This will return you to the Conditional Formatting Rules Manager window.
You will need to click on the New Rule button again.

When the New Formatting Rule window appears, we need to set up the second condition.
Select Format only top or bottom ranked values as the rule type.
Then select Bottom in the first drop down, and enter 1 in the final box. In our example, we've selected only the first bottom value.
Next, we need to select what formatting to apply when this second condition is met. To do this, click on the Format button.

When the Format Cells window appears, select the Fill tab. Then select the color that you'd like to see for the lowest value in the range. In this example, we've selected red. Then click on the OK button.

When you return to the New Formatting Rule window, you should see the preview of the formatting in the Preview box. In this example, the preview box shows red as the fill color. Next click on the OK button.

Your Conditional Formatting window should now look like this.

Click on the OK button.
Now when you return to the spreadsheet, the conditional formatting will be applied. As you can see, the -3 value appears in a red cell while the 200 value appears in a green cell.
When the New Formatting Rule window appears, select Format only top or bottom ranked values as the rule type.
Then select Top in the first drop down, and enter 1 in the final box. In our example, we've selected only the first top value.
Next, we need to select what formatting to apply when this condition is met. To do this, click on the Format button.

When the Format Cells window appears, select the Fill tab. Then select the color that you'd like to see for the highest value in the range. In this example, we've selected green. Then click on the OK button.

When you return to the New Formatting Rule window, you should see the preview of the formatting in the Preview box. In this example, the preview box shows green as the fill color. Next click on the OK button.

This will return you to the Conditional Formatting Rules Manager window.
You will need to click on the New Rule button again.

When the New Formatting Rule window appears, we need to set up the second condition.
Select Format only top or bottom ranked values as the rule type.
Then select Bottom in the first drop down, and enter 1 in the final box. In our example, we've selected only the first bottom value.
Next, we need to select what formatting to apply when this second condition is met. To do this, click on the Format button.

When the Format Cells window appears, select the Fill tab. Then select the color that you'd like to see for the lowest value in the range. In this example, we've selected red. Then click on the OK button.

When you return to the New Formatting Rule window, you should see the preview of the formatting in the Preview box. In this example, the preview box shows red as the fill color. Next click on the OK button.

Your Conditional Formatting window should now look like this.

Click on the OK button.
Now when you return to the spreadsheet, the conditional formatting will be applied. As you can see, the -3 value appears in a red cell while the 200 value appears in a green cell.

2. DELETE
If you just highlight the row or column and hit the delete key then the contents disappear

3. INSERT
If you just highlight the cell and press insert key then new cell will be add

4. UPDATE

Cells are not updating automatically

Written by,

Rameeshah Shahid

DATA MANIPULATION OPERATION - Introduction

Abstract

This write-up describe the brief concept about black box testing  and data manipulation operations .

Black box testing is attempts to find errors in the external behavior of the code like incorrect or

missing functionality, interface errors, errors in data structures used by interfaces, behavior or

performance errors. Data manipulation is the process of changing data to make it organized or

meaningful form

Introduction

Black box Testing

Black box testing is the Software testing method which is used to test the software without knowing the internal structure of code or program. -. For example, in a black box test on a software design the tester only knows the inputs and what the expected outcomes should be and not how the program arrives at those outputs. The tester does not ever examine the programming code and does not need any further knowledge of the program.

 

Advantages

·         The tester does not need knowledge of any specific programming languages.

·         Test is performed from a user’s point-of-view and not of the designer’s

·         Test cases can be designed as soon as the specifications are complete.

Disadvantages

·         The reason for a failure is not found.

·         Testing every possible input stream is not possible because it is time-consuming and this would eventually leave many program paths untested.

·         Chances of having repetition of tests that are already done by programmer.

Purpose of Each Consistency Area

Data manipulation is the process of changing data in an effort to make it easier to read or more organized. For example, a log of data could be organized in alphabetical order, making individual entries easier to locate. Data manipulation is often used on web server logs to allow a website owner to view their most popular pages as well as their traffic sources.

A data manipulation language (DML) is a family of syntax elements similar to a computer programming language used for selecting, inserting, deleting and updating data in a database. Performing read-only queries of data is sometimes also considered a component of DML.

Data Manipulation Operations

 Select

 Retrieve data from web application and mobile application

Insert

Insert data into a database, web application and mobile application

Update

Updates existing data within a table or new record enter in a database , web application and mobile application

 Delete

 Deletes records from desktop application, web app and mobile app

Desktop App

Web Application

Mobile App

Reference

http://it.toolbox.com/blogs/enterprise-solutions/gui-screen-design-checklist-20426

http://agile.csc.ncsu.edu/SEMaterials/BlackBox.pdf

https://en.wikipedia.org/wiki/Data_manipulation_language

http://www.computerhope.com/jargon/d/datamani.htm

http://www.techonthenet.com/excel/questions/cond_format3_2007.php

Written by,

Rameeshah Shahid