PUBLIC PREVIEW · FREE SIGN-IN FOR THE FULL PDF

Computer science · 2017 · May · Paper 2 · SL · Question paper

Computer scienceQuestion paper2017SLMay

Full PDFs are free with an email account.

Resource overview

This question paper is listed under Computer science in the 2017 examination archive. Its catalogue level is SL. The catalogue session is May. The information below helps you identify the document before opening the complete PDF. Subject, year and session labels come from the archive catalogue; the original cover remains the reference if a label differs. A file is not automatically suitable for your current syllabus simply because its subject name matches.

For revision, choose a manageable section and attempt it before consulting the matching markscheme. Keep a short error log separating knowledge gaps, method choices and unclear explanation. Compare the paper number, level and examination zone before pairing files. Older papers can be useful practice, but their topic coverage and format may differ from the course you are taking now.

The public preview contains file information and, where reliable text extraction is available, a limited opening excerpt. It is not a summary of unseen questions or a replacement for the original document. Create a free email account to read or download the complete file. No payment is required to unlock this archive resource.

This original usage overview is based on the archive metadata. It does not claim to summarise the complete file.

Opening excerpt

Opening text only, limited to at most 20% of pages, two page-equivalents and 2,200 characters. Clearly labelled personal identifiers have been removed. Text extraction may omit equations, tables or figures.

14 pages Monday 8 May 2017 (morning) 1 hour Instructions to candidates y Do not open this examination paper until instructed to do so. y Answer all of the questions from one of the options. y The maximum mark for this examination paper is [45 marks]. Option Questions Option A — Databases 1 – 3 Option B — Modelling and simulation 4 – 6 Option C — Web science 7 – 9 Option D — Object-oriented programming 10 – 11 © International Baccalaureate Organization 2017 M17/4/COMSC/SP2/ENG/TZ0/XX 2217 – 7015 Computer science Standard level Paper 2 Option A — Databases 1. A school stores details about the parents of its students in a database management system. (a) Outline two reasons for choosing to use a database for this storage. [2] (b) Identify one item of data that would be stored in this database management system. [1] (c) Outline a technique that could be used to reduce data input errors. [2] One of the functions of the system is to allow parents to pay for their children’s school lunches online. Parents are notified, by email, with the amount that they owe. After payment, a confirmation is sent to the parent by email. (d) Describe the interaction between the parent and the database management system when processing a payment. [5] (e) Explain how the database is accessed when many parents pay online at the same time. [3] 2. (a) Define the term relational database. [1] (b) Explain the role of entity-relationship diagrams when modelling data. [4] TABLE_1 and TABLE_2, shown below, are taken from a school’s relational database. TABLE_1 holds data about all of the students at the school and TABLE_2 holds data about participants in the school chess club. The tables’ primary keys are underlined. TABLE_1 Student_ID EmailAddress 12 [Email removed] 34 [Email removed] TABLE_2 Member_ID Student_ID Position 1 12 Captain 13 34 Secretary 11 21 Member (c) Limited to the data shown, outline an issue that may arise when using the tables. [2] (d) (i) Describe an issue that could occur after deleting, in TABLE_1, the record for the student whose Student_ID is 12. [2] (ii) With reference to the situation in part (d)(i), outline which property of data ensures that, in a
File information
Subject
Computer science
Document type
Question paper
Year
2017
Session
May
Level
SL
Paper
2
Examination zone
Not labelled in the archive
Language
Not labelled in the archive
File size
405 KB
Pages
14
FREE FULL RESOURCE

Read the complete document.

Register or sign in with your email to unlock the full PDF. No payment, password or membership is needed.

View full documentDownload complete PDF

Your link is valid for five minutes. You can request another link after signing in.

Tell us what you need.
CONTACT IBVIA

Let’s talk about your work.

Your enquiry: IB support

Continue to WhatsApp with your selected service already included. Add your subject, deadline and current draft in the chat.

For your first message

What are you working on?