Skip to content

Course home

Algorithms

Algorithms

EasyMediumHard
12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576
Question 26

An ecological database tracks marine research at various reef locations. There is a one-to-many relationship between these tables:

tbl_ReefSites
ReefID
ReefName
Latitude
Longitude
tbl_SpeciesSightings
SightingID
SpeciesName
Count
ReefID
SightingTimestamp

To establish this relationship:

a.

Identify the common field name that must be used to link these two tables.

[1]
b.

State which of the two tables represents the 'many' side of this relationship.

[1]
Markscheme

Algorithms Questions

  1. GCSE
  2. /Computer Science
  3. /Algorithms

159 exam-style questions on Edexcel GCSE Computer Science Algorithms, covering Constructs for solving problems, Variables, constants and data structures, Arithmetic, relational and logical operators, Tracing algorithm output with trace tables, Types of error and correcting logic errors, Standard algorithms (sorts and searches), and Evaluating algorithm fitness and efficiency. Each one has a worked solution and a mark scheme showing where the marks go.

Question bank