logo

Cambridge IGCSE Information and Communication Technology practice

Paper 3 structured question: Create a database structure

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

Attempt questionCreate a database structure revisionRevise the key idea

At a glance

3

Paper

3

Marks

Topic

Create a database structure

Exam-style question

Try this first

Paper 3Practical TestPractical3 marks

Analyzing a database table after importing data and assigning data types.

Results Table

Sample Database Table Fields and Data Types

The table below shows fields imported from a .csv file with assigned data types and display formats.

Field NameData TypeSub-type/Format
CustomerIDPrimary Key (Text)N/A
OrderDateDate/TimeDD/MM/YYYY
OrderAmountNumericCurrency, 2 decimal places
IsMemberBooleanCheckbox
  1. a

    Identify Identify the primary key and explain its importance in this database table.

    Aim for approximately 3 distinct marking points.

    [3]

0 of 1 part 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

Related practice questions

Question 1 of 5

Choose an answer, get feedback, then move sideways through the set.

0 of 4 attempted

Paper 3 structured question: Create a database structure

Paper 3Practical TestPractical4 marks

Method

Database Development Method

You are tasked with developing a database by importing data from a .csv file and designing a data entry form. The form must include specified fields with appropriate font styles and sizes, adequate spacing, and input controls such as radio buttons and drop-down menus.

  1. a

    Describe Describe a method to ensure the reliability and accuracy of data entry when designing the form. Include how you would control variables and repeats in your plan.

    Aim for approximately 4 distinct marking points.

    [4]