INF2603 Supp 2025 exam paper — questions

🔒 Scan locked

  1. Question 1.1 · Entity relationship modelling · 1.5 marks

    Indicate whether the following statement is true or false: a weak relationship exists if the primary key of the related entity contains at least one primary key component of the parent entity.Show the full question

  2. Question 1.2 · The relational model · 1.5 marks

    Indicate whether the following statement is true or false: the DIVIDE operation uses one single-column table (for example, column "a") as the divisor and one two-column table (for example, columns "a" and "b") as the dividend.Show the full question

  3. Question 1.3 · Entity relationship modelling · 1.5 marks

    Indicate whether the following statement is true or false: a design trap occurs when a relationship is improperly or incompletely identified and is therefore represented in a way that is not consistent with the real world.Show the full question

  4. Question 1.4 · SQL · 1.5 marks

    Indicate whether the following statement is true or false: the HAVING clause is used to restrict the output of a GROUP BY query by applying conditional criteria to the grouped rows.Show the full question

  5. Question 1.5 · Normalisation and dependencies · 1.5 marks

    Indicate whether the following statement is true or false: a table that displays data redundancies yields anomalies.Show the full question

The full Spot Map and the marks by year — and this paper’s scan.