Beta

Edexcel International A Level Information Technology, Unit 4

Relational Database Development

Unit 4 has 3 topics and 15 subtopics. Pick the ones you keep getting wrong and LOCKIN sets you a paper laid out like the real exam, with a mark scheme.

Unit 4 is a practical exam. As well as written questions, you can take a practical task pack laid out like the real paper, with the starting files to download and a mark scheme to check against.

Try it, no account needed

Topics (2 of 3 chosen)

LOCKIN practice paper

Information Technology

Unit Unit 4

Total marks

8

Answer all questions.

With an account you choose from every topic in the unit, set the difficulty and the number of questions, and print the paper.

What's in Unit 4

You can choose any of these on its own, or several for one paper.

Use of features of database solutions

  • Choosing database features for a context
  • Analysing user needs
  • Database design and user experience

Questions are usually worth 2 to 9 marks.

Relational database concepts

  • Tables, fields and data types
  • Relationships, keys and referential integrity
  • Validation rules and test data
  • Error messages and data entry aids

Questions are usually worth 1 to 11 marks.

Database solutions

  • Importing, updating and exporting data
  • Creating relational structures from data
  • Queries, calculated fields and reports
  • Forms, menus and action buttons
  • System outputs: tables, reports and charts
  • Macros
  • Testing a database solution
  • Evaluating a database solution

Questions are usually worth 1 to 11 marks.

Information Technology units

Build a Unit 4 paper free