A database administrator is writing an automated script to archive inactive user accounts. During a test run, some active accounts are incorrectly flagged for deletion. The administrator decides to construct a trace table to debug the script.
Explain how the administrator uses a trace table to locate and resolve this logical error.
159 exam-style questions on Edexcel GCSE Computer Science Algorithms, covering Constructs for solving problems, Variables, constants and data structures, Arithmetic, relational and logical operators, Tracing algorithm output with trace tables, Types of error and correcting logic errors, Standard algorithms (sorts and searches), and Evaluating algorithm fitness and efficiency. Each one has a worked solution and a mark scheme showing where the marks go.