Quelpr
4 marksManipulating Data in a Database

CSEC Information Technology · 2022 · Paper 2 · Question 3(c)

Create a query by completing the query design view window to extract the fields ID, FirstName, LastName and Phone from the STUDENTS table, and the field SportName from the SPORTS table, for all married students who play football.

This question uses a figure or table from the paper — you'll see it when you practise.

The mark scheme is shown once you've answered.

Practise this question

Other parts of this question

  1. 3(a)Complete the table by inserting the MOST appropriate web technology concepts from the given list (Web browser, Hyperlink, Web server, Hypertext markup…[5 marks]
  2. 3(b)(i)State the feature that is used to establish and maintain the accuracy of data between the two database tables.[1 mark]
  3. 3(b)(ii)State why it is necessary to maintain the accuracy of data between the two database tables.[1 mark]
  4. 3(b)(iii)Outline how the one-to-many relationship is formed between the two database tables.[2 marks]
  5. 3(d)State the record IDs of the record(s) that would be extracted when the query designed in (c) is executed.[2 marks]
  6. 3(e)(i)There are four steps in implementing a program. List THREE of these steps.[3 marks]
  7. 3(e)(ii)Describe what is involved in any TWO of the steps listed in (e)(i).[2 marks]
  8. 3(f)Complete the pseudocode by writing a nested if-then-else statement to produce the required output based on the number of goals scored by Team A and Team B.[5 marks]

More practice: the rest of this paper · more Manipulating Data in a Database questions · all CSEC Information Technology past papers