Computer Science 0478/23 Oct Nov 2024 | Cambridge IGCSE Past Papers With Mark Scheme

1. Data Validation and Problem-Solving Methods | Identifying validation techniques, logic gates, and structured approaches to problem-solving.

2. Database Concepts and SQL Queries | Understanding fields, records, and primary keys, and writing SQL queries for data retrieval and sorting.

3. Algorithm Development and Pseudocode | Completing an algorithm for array processing, defining meaningful variable names, and writing pseudocode for user output.

4. Testing and Debugging | Identifying test data types, executing boundary and invalid input testing, and debugging logical errors in flowcharts.

5. Boolean Logic and Truth Tables | Completing truth tables, constructing logic circuits for automated systems, and analyzing circuit behavior.

6. Password Validation Algorithm | Implementing password rules, checking length, case sensitivity, and special characters using trace tables.

7. SQL Queries and Database Manipulation | Writing queries to filter, sort, and retrieve data from a stock database using conditions like weight and availability.

8. Sorting and Data Processing in Programming | Implementing sorting for litter collection data, identifying top performers, and generating award notifications in pseudocode.