Quelpr
1 markDatabase Terminology

CSEC Information Technology · 2022 · Paper 2 · Question 3(b)(ii)

Database tables STUDENTS and SPORTS are joined in a one-to-many relationship.

State why it is necessary to maintain the accuracy of data between the two database tables.

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)(iii)Outline how the one-to-many relationship is formed between the two database tables.[2 marks]
  4. 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…[4 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 Database Terminology questions · all CSEC Information Technology past papers