Consider the following pseudocode snippet: RECEIVE age FROM (INTEGER) KEYBOARD IF age >= 18 THEN SEND ‘You are eligible to vote.’ TO DISPLAY ELSE SEND ‘You are not eligible to vote yet.’ TO DISPLAY END IF (a) Identify the type of selection control structure used in this pseudocode. (b) What will be displayed if the […]
Reading Selection Controlled Algorithm (2 marks) Read More »
A developer is using a subprogram to calculate VAT in an accounting software. Explain why this is a good practice using the concept of abstraction.
The Concept of Abstraction (1 mark) Read More »
Identify and explain the benefits of using subprograms in a software application.
Benefits of Subprograms (3 marks) Read More »
Describe one real-world scenario where abstraction is used in computer systems to simplify a process.
Real-World Abstraction (2 marks) Read More »
Explain how decomposition helps in solving complex problems in computer programming.
Decomposition and Complex Problems (2 marks) Read More »
The Books table contains BookID, Title, and Author. A book needs to be deleted from the database where the Title is “The Lord Of The Rings”. Construct the SQL DELETE statement for this operation.
SQL DELETE (2 marks) Read More »
Given a table Orders with columns OrderID, ProductID, Quantity, and OrderDate, write an SQL statement to update the Quantity of an order to 3 where the OrderID is 102.
SQL UPDATE (3 marks) Read More »
A table Players contains columns PlayerID, PlayerName, and Score. Write an SQL query to insert a new record into the table.
SQL INSERT INTO (3 marks) Read More »
Write an SQL query to retrieve the CustomerName and PurchaseDate for all records in the Purchases table where the PurchaseAmount is greater than £500.00. Results should be ordered by PurchaseDate in descending order.
SQL Query Writing (4 marks) Read More »
Describe the purpose of the SELECT statement in SQL.
The SELECT Statement (1 marks) Read More »
