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
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.
Information Technology quick practice
3 questions from Unit 1, Unit 2, Unit 3
Answer on screen and each one is marked straight away, with the worked answer.
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.