S1
Introduction Course
S2
Introduction course
Computing
Standard Grade
Information Systems
Intermediate II
Information Systems
Higher
Internet
Safety
Business Studies
Dept

13. Supermarket Sweep

Working with databases often requires you to SEARCH (using either Simple or Complex search methods) for possible information and SORT the RESULTS (using either Simple or Complex methods) .

 

 

What you have to do!

  1. Using the Supermarket database, for final practice, answer the following questions in your progress grids.
    • Remember to use your skills that you practiced in Exercises 1 - 4. If you can't remember, look at the movies to remind yourself.

 

1. a. How many records are in this database?.
  b. How many different fields are there in each record?
  c. How many different layouts are in this database?
   
2. Sort the database in order of the code number.

Write down the code number of the 19th item shown.
   
3. Sort the database with stock levels arranged in descending order.

Write down the code number of the of the first item shown.
   
4. Sort the database in order of cost.

Write down the code number of the cheapest.
     
5. a. Find all the records where the goods type is Dairy.
  b. How many records are shown?
  c. For the records found, sort the stock levels in ascending order.

Write down the stock level of the last item on the list.
     
6. a. Find all the records where the cost is greater than £1.70
  b. How many records are shown?
  c. For the records found, sort the the cost in ascending order.

Write down the code number of the first item in the list.
     
7. a. Find all the canned goods where the stock level is less than 100.
  b. How many records are shown?
  c. For the records found, sort the stock level in ascending order.

Write down the code number of the 2nd item on this list.
     
8. a. Find all the goods costing less than or equal to £1.55 and the stock level is greater than 70.
  b. How many records are shown.
  c. For the records found, sort the cost and then the stock level in ascending order.
Write down the code number of the 20th item in the list.
   
9. Add the following new records to the database (don't worry about including a picture)
 
Code Number
Item Name
Goods Type
Stock Level
Cost
233
Hoover bags
Household
57
£2.60
271
Rich Tea
Biscuits
146
£0.42
     
10. Delete the following records from the database.
 
Code Number
Item Name
Goods Type
Stock Level
Cost
827
Pack of Eggs
Dairy
42
£0.88
285
Lentil Soup
Canned
102
£0.40
     
11. The items with the code numbers 431 and 513 have the wrong details included. Use the information in the table to Amend or Edit these records to include the correct details.
 
Code Number
Item Name
Goods Type
Stock Level
Cost
431
Mars Multipack
Biscuits
244
£1.42
513
Twix Multipack
Biscuits
42
1.12
     
12. a. Find all records where the code number is greater than 600.
  b. Sort the items in the list in ascending order of code number.
  c. Create a list layout with your name and class included in a footer. The list should only contain only the fields code number, item name and cost.

 

 

Congratulations!

You are now an expert in Sorting, Searching and using Databases.

 

 

You are now ready for your assessment!


S1 Courses

 

 

 

Home | S1 Topics | S2 Topics
Computing Standard Grade | Info Systems Intermediate II | Info Systems Higher | Internet Safety
Log into Glow | School Website | Contact Us