PUBLIC PREVIEW · FREE SIGN-IN FOR THE FULL PDF

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

Computer scienceQuestion paper2016SLNovember

Full PDFs are free with an email account.

Resource overview

This question paper is listed under Computer science in the 2016 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.

N16/4/COMSC/SP2/ENG/TZ0/XX Computer science Standard level Paper 2 © International Baccalaureate Organization 2016 11 pages 8816 – 7015 Monday 7 November 2016 (afternoon) Instructions to candidates yy Do not open this examination paper until instructed to do so. yy Answer all of the questions from one of the options. yy 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 — W eb science 7 – 9 Option D — Object-oriented programming 10 – 14 1 hour – 2 – Option A — Databases 1. A college maintains a database to store information about the courses that it offers, as shown in the table below. CourseTable CourseID Course_Name Duration (Hours) Cost CS1200 Word Processing 10 30.00 CS1234 Databases 20 60.00 CS1201 Java Programming 105 150.00 CS5201 Java Programming – Advanced 50 90.00 CS1280 Python Programming 75 130.00 CS1331 C Programming 100 180.00 CS1209 Spreadsheets 20 30.00 … … … … (a) Outline the difference between data and information. [2] (b) Suggest an appropriate data type for each attribute in this database. [3] (c) Explain the role of data validation. [2] (d) State a validation check which might be helpful when entering a (i) CourseID; [1] (ii) Cost. [1] (e) (i) Identify the steps in a query, that could be constructed to produce a list of the names of courses with a duration between 40 and 80 hours. [3] (ii) Describe one function that is required to be performed on databases, other than the query function. [2] 2. The database schema is the definition that describes the entire configuration of a database. (a) Outline the characteristics of the three levels of the schema. [6] (b) (i) Explain two responsibilities of a database administrator. [4] (ii) Explain, with an example, how the database administrator would use a data definition language. [3] (c) Identify four consequences of poor data modelling in the design of a database. [4] (Option A continues on the following page) N16/4/COMSC/SP2/ENG/TZ0/XX
File information
Subject
Computer science
Document type
Question paper
Year
2016
Session
November
Level
SL
Paper
2
Examination zone
Not labelled in the archive
Language
Not labelled in the archive
File size
360 KB
Pages
11
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?