Cambridge IGCSE Information and Communication Technology practice

Paper 1 structured question: Design

Try the question first, then check the answer and practise the same topic again.

Attempt question Design revision Revise the key idea

At a glance

Paper

Marks

Topic

Design

Exam-style question

Try this first

Paper 1Theory6 marks

Designing a student database system

Description

File Structure Example

A student database includes fields such as Student ID, Name, Gender, and Age. The Gender field uses coding conventions where 'M' represents male and 'F' represents female.

Field Name	Data Type	Field Length	Coding Convention
Student ID	Numeric	6	None
Name	Text	30	None
Gender	Text	1	M/F
Age	Numeric	2	None

a
Define Define what is meant by a 'coding convention' in the context of the Gender field.
Your answer
Aim for approximately 2 distinct marking points.
[2]
b
Explain Explain two validation checks that could be used for the Age field.
Your answer
Aim for approximately 4 distinct marking points.
[4]

0 of 2 parts answered

Answer every part before opening the mark scheme.

Common mistake

No common mistake is linked to this question yet.

Related flashcards

Flashcard 1 of 6

Press Space to flip, arrows to move