PUBLIC PREVIEW · FREE SIGN-IN FOR THE FULL PDF

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

Computer scienceQuestion paper2018SLMay

Full PDFs are free with an email account.

Resource overview

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

Computer science Standard level Paper 2 15 pages Monday 7 May 2018 (morning) 1 hour 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 — Web science 7 – 9 Option D — Object-oriented programming 10 – 12 © International Baccalaureate Organization 2018 M18/4/COMSC/ SP2/ENG/TZ0/XX 2218 – 7015 Option A — Databases 1. Galaxy Bank is a US based bank with many banks (branches) across the country. Galaxy Bank uses a relational database to support its operations. Each branch has many customers and each customer may take out a number of loans. (a) Construct the entity relationship diagram (ERD) that shows the relationship between the bank branch, the customers and their loans. [2] Some of the data in the LOANS table is shown below. The underlined attribute indicates the primary key. LOANS Loan_ID Customer_ID Amount Type XY080911 668848616 500 000 Home RD050789 987887982 430 000 000 Venture RG903540 124567552 231 900 000 Venture XY348801 648782904 800 000 Home ED569891 456783356 230 000 Education … … … … (b) With reference to the table LOANS, state the output of the following query: SELECT LOANS.Loan_ID, LOANS.Customer_ID, LOANS.Amount, LOANS.Type FROM LOANS WHERE (LOANS.Amount > 600000) AND ((LOANS.Type = "Home") OR (LOANS.Type = "Venture")); [2] (Option A continues on the following page) M18/4/COMSC/ SP2/ENG/TZ0/XX – 2 –
File information
Subject
Computer science
Document type
Question paper
Year
2018
Session
May
Level
SL
Paper
2
Examination zone
Not labelled in the archive
Language
Not labelled in the archive
File size
399 KB
Pages
15
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?