Worksheet Two

1) Why do we sometimes use abbreviations (shorten words) when we enter information into databases

-------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------

-------------------------------------------------------------------------------------

2) Using abbreviations in databases is sometimes known as coding.

Suggest suitable coding for the car manufacturer field below.

Car manufacturer

Ford
Mercedes

Mazda

Nissan

Toyota

--------------------------------------------------------------------------------------

--------------------------------------------------------------------------------------

3) Write down a search procedure to find all of the Ford cars in a database.

---------------------------------------------------------------------------------------
 

4) Write down a search condition to find all of the Red Ford Fiesta cars in a database.

---------------------------------------------------------------------------------------

5) Why do spelling mistakes in a database lead to inaccurate searches?

----------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------