Standard Grade Computing  
line decor
  HOME  :: General Purpose Packages:: Database & Expert Systems::Homework:: General Level Questions :: Set 2  
 General Purpose Packages | Industrial Applications | Commercial Data Processing | Computer Systems | Systems Software | Programming | Arrangements
line decor
 
  
 
 
General Homework Questions : Set 4
 
General Purpose Packages: Databases
   
KU
PS
1. Below is a record from the database which holds details of people who have registered an interest in the community centre.:    
 

Registration Number

156

Name

Drew Barrymore

Date of Birth

04/09/87

Sex

Female

Address Line 1

13 Hill Street

Address Line 2

Blues Town

Postcode

HS1 34B

Main Interest

Music
   
  a. Look at the above record and write down two field types that could be used in this database
2
  
     
 
  b. What type of check could be done on the Date of Birth field to ensure that it falls within the years 1904 to 2007.
1
  
         
  c. How could the database be used to identify the youngest person who has registered an interest in the community centre?    
         
  d. Complete the following paragraph which describes how you would obtain a paper copy of people born after 01/05/86 and who are interested in music.    
   

Perform a complex  _____________________       on the ‘Date of Birth’ field for a date

 ___________       01/05/86 AND the  _______________     field for ‘Music’. 

Produce a paper copy using a      __________________		  
4
         
2. Hannah works at a garden centre.  She keeps a database of flowers that are available to buy.  A record from the database is shown below:    
 

Plant name

Daffodil

Colour(s) of flower

Yellow, Orange

Height (metres)

0.3

Flowering month(s)

March, April

Price (each)

£0.24
  a. A customer is looking for tall plants to provide shade in a large garden.  Explain clearly how Hannah could obtain a list on screen of the tallest plants available, starting with the largest one.
3
     
  b. A customer would like a list of plants that will have purple flowers in April.  Explain clearly how Hannah would obtain this list.
3
     
  c. Hannah decides to make the database available to customers to allow them to answer some of their own questions in the shop.  Hannah decides not to use a mouse and a GUI (Graphical User Interface), as some people may not know how to use a mouse.  Hannah can alter the software’s user interface to get either a command driven package or a menu driven package.
    (i). Which interface should Hannah choose for beginner’s to use?
1
    (ii). Explain your answer.
1
         
 

 
 
 
  
 
RESOURCES
Walsh J: Computing Studies . - Chapter 4

DOWNLOADS
These questions are available in Word DOC format or PDF format. Download these questions by clicking on:
Word Document :Complete the answers on the sheet and print out. Save it to your own computer or in school to your network folder. Microsoft Word Programme necessary.

PDF format : Download this version to open on any computer. Answer the questions in a separate word processed document and print out, or write your answers in your jotter.