Computer Science · May / June 2024 · Paper 2 SL · Question 1
Adapt for 2027Data types, ERDs, composite keys and data consistency are database design (A3.2); counting results in a query uses SQL aggregate functions (A3.3.4, HL only). Includes Higher Level only content, which Standard Level students do not study.
IBCS
As printed in the paper
The question as text
1. Environmental systems and societies (ESS) students are collecting data about the plant species found on sand dunes as part of their internal assessment. The data is collected from 10 sites using a paper form (Figure 1). The form shown in Figure 1 is used to input data into the Environment database. Figure 1: An example of a data collection form. FIELD STUDY CENTRE 14/10/2019 Survey date: Sample site: 9 Aspect: South Gradient: 10 Comments: None Established dune, south facing Species Present Coverage % Marram grass 0 Sand couch grass 0 Sea holly 0 Sea spurge 0 Sea buckthorn 0 Gorse ✔ 40 Blackthorn ✔ 40 [LOGO] (Option A continues on the following page) (Option A, question 1 continued)
Read automatically from the paper; the printed page above is exact.
Show the answer and mark scheme
1(a)(i)[1]
1(a)(ii)[1]
1(b)[2]
1(c)[3]
1(d)[2]
1(e)[4]
1(f)[3]
Make a free account to save your answers and see your weak topics and ask the AI why a wrong answer is wrong.