PUBLIC PREVIEW · FREE SIGN-IN FOR THE FULL PDF

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

Computer scienceQuestion paper2017SLNovember

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 November. 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.

Computer science Standard level Paper 2 13 pages Monday 6 November 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 – 12 © International Baccalaureate Organization 2017 N17/4/COMSC/ SP2/ENG/TZ0/XX 8817 – 7015 Option A — Databases 1. (a) Define the term database transaction. [2] (b) Explain the importance of durability in a database transaction. [2] (c) Identify two different types of relationships within databases. [2] (d) Describe the nature of the data dictionary. [4] (e) Identify four responsibilities of a database administrator. [4] 2. A group of art students have taken three examinations in the school year. Each of the three examinations has a maximum mark of 100. Each student’s total mark for the year is the sum of the marks from the three examinations. The students have passed unless their marks meet one or both of the following failing conditions: y Scoring less than 30 marks on any one of the three examinations. y Scoring a total mark that is less than 150. Consider the following relation created by the teacher of this group of students. CLASS_TABLE Student_ID Student_Name Exam_One Exam_Two Exam_Three Total A1209 Ines Prest 30 39 30 99 A1422 Eva Maren 67 29 100 196 C4567 Joe Skrin 100 70 42 212 X0986 Perry Blare 54 68 30 152 B0078 Mia Lorres 26 100 100 226 (a) With reference to the relation CLASS_TABLE distinguish between data and information. [3] (b) (i) Define the term entity. [1] (ii) State the entity for this example relation. [1] (c) Identify an appropriate data type for Student_ID. [1] (d) Explain the role of data validation and data verification. [4] (e) Explain how Total could be validated. [2] (f) Describe the steps in a query that will output (i) the names of all students who earned the maximum mark on Exam_Two. [2] (ii) the Student_IDs of all candidates who passed. [4] (Option A continues on the following
File information
Subject
Computer science
Document type
Question paper
Year
2017
Session
November
Level
SL
Paper
2
Examination zone
Not labelled in the archive
Language
Not labelled in the archive
File size
433 KB
Pages
13
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?