Pages in this set

Page 1

Preview of page 1

Page 2

Preview of page 2
THIS IS A NEW SPECIFICATION

ADVANCED SUBSIDIARY GCE INFORMATION AND COMMUNICATION
TECHNOLOGY
G061
Information, Systems and Applications
Candidates answer on the question paper

Monday 12 January 2009
OCR Supplied Materials:

Afternoon
None
Duration: 2 hours Other
Materials Required: None
*G061*
INSTRUCTIONS TO CANDIDATES
· Write your name clearly in capital…

Page 3

Preview of page 3

Page 4

Preview of page 4
2
A boat hire company has a head office in Cornwall and offers day trips to go whale watching.
The company has a website where customers can look at the different types of trips offered and
email for further information.
1 The website collects data from potential customers.
(a) (i)…

Page 5

Preview of page 5

Page 6

Preview of page 6

3
(c) The quality of information received by the company can be variable.
Describe, using examples related to the boat hire company, how the following can affect the
quality of information given by the customer:
Completeness ...........................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
............................................................................................................................................. [2]
Relevance .................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
............................................................................................................................................. [2]
Accuracy ...................................................................................................................................
...................................................................................................................................................…

Page 7

Preview of page 7

Page 8

Preview of page 8
4
2 The company stores details of customers and bookings in a database.
(a) Fig. 1 shows part of the bookings table.
Customer name Customer address Booking Booking
Paul Purple The Street, Poole, Dorset. 24/07/09
Maxine Mauve 14, Lake End, Maidstone, Kent. 20/06/09 31/07/09
Yasmin Yellow 28c Boxley Road, Norwich,…

Page 9

Preview of page 9

Page 10

Preview of page 10

5
(c) Describe three components of a data dictionary.
1 ................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
2 ................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
3 ................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
............................................................................................................................................. [6]
(d) Explain why the integer data type is not appropriate for storing a telephone number.
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
............................................................................................................................................. [2]
© OCR 2009
Turn over

Comments

No comments have yet been made

Similar ICT resources:

See all ICT resources »

Pages in this set

Page 1

Preview of page 1

Page 2

Preview of page 2
THIS IS A NEW SPECIFICATION

ADVANCED SUBSIDIARY GCE INFORMATION AND COMMUNICATION
TECHNOLOGY
G061
Information, Systems and Applications
Candidates answer on the question paper

Monday 12 January 2009
OCR Supplied Materials:

Afternoon
None
Duration: 2 hours Other
Materials Required: None
*G061*
INSTRUCTIONS TO CANDIDATES
· Write your name clearly in capital…

Page 3

Preview of page 3

Page 4

Preview of page 4
2
A boat hire company has a head office in Cornwall and offers day trips to go whale watching.
The company has a website where customers can look at the different types of trips offered and
email for further information.
1 The website collects data from potential customers.
(a) (i)…

Page 5

Preview of page 5

Page 6

Preview of page 6

3
(c) The quality of information received by the company can be variable.
Describe, using examples related to the boat hire company, how the following can affect the
quality of information given by the customer:
Completeness ...........................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
............................................................................................................................................. [2]
Relevance .................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
............................................................................................................................................. [2]
Accuracy ...................................................................................................................................
...................................................................................................................................................…

Page 7

Preview of page 7

Page 8

Preview of page 8
4
2 The company stores details of customers and bookings in a database.
(a) Fig. 1 shows part of the bookings table.
Customer name Customer address Booking Booking
Paul Purple The Street, Poole, Dorset. 24/07/09
Maxine Mauve 14, Lake End, Maidstone, Kent. 20/06/09 31/07/09
Yasmin Yellow 28c Boxley Road, Norwich,…

Page 9

Preview of page 9

Page 10

Preview of page 10

5
(c) Describe three components of a data dictionary.
1 ................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
2 ................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
3 ................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
............................................................................................................................................. [6]
(d) Explain why the integer data type is not appropriate for storing a telephone number.
...................................................................................................................................................
...................................................................................................................................................
...................................................................................................................................................
............................................................................................................................................. [2]
© OCR 2009
Turn over

Comments

No comments have yet been made