Data Handling Software a field

A record is a collection of detail about a person or thing. Includes a number of fields.

1. 
   Give an example of a range check that could be used.
   
2. 
   What is verification?
   

Complete the data structure table below:

Which field would be the key field? Why is the key field important?

When searching you must state the Field Name, Condition and the Value an example to find people with phone insurance is displayed below:

1. 
   Display all phones on the 3 network.
   
2. 
   Display all phones with greater than 500 texts.
   
3. 
   Display all phones whose contract set to expire before the 12^th May 2007.
   
4. 
   Display all phones that have 500 mins exactly.
   

A complex search asks two questions as part of the same search. An example to find all T-Mobile phones with exactly 1000 texts is displayed below:

Text = 1000

Network = 3

Network = Orange

5. 
   Display all phones on the 3 network with phone insurance.
   
6. 
   Display all phones with greater than 500 texts or greater than 400 mins.
   
7. 
   Display all phones whose network is orange and monthly rate is less than £30.00.