Computer science Higher level Paper 2 - Databases and application questions - Exam instructions

Aug 27, 2026

Upload by Maeve

This document contains the International Baccalaureate Computer Science Higher Level Paper 2 examination for 30 October 2023, including instructions to candidates and the structure of answer options. It presents Option A—Databases with database design and query tasks set in a restaurant scenario, covering reasons for using databases, data storage formats, relational table structure, composite primary keys, and query-related issues. It also includes steps to create queries for listing specific customer visit history and outlines mark allocations.

LanguageEnglish

CategoryExam

FormatPDF

Pages25

Reading Time1 h 3 min

AccessFree to download

Instructions to candidates

Options and question ranges

Option A—Databases

Database vs spreadsheet storage rationale

DateOfVisit field benefits and ordering

Restaurant database table structure

Composite primary key vs OrderlineID

Potential query issues from duplicated UnitPrice fields

Query steps for specific customer visits

© International Baccalaureate Organization 2023 All rights reserved. No part of this product may be reproduced in any form or by any electronic or mechanical means, including information storage and retrieval systems, without the prior written permission from the IB. Additionally, the license tied with this product prohibits use of any selected files or extracts from this product. Use by third parties, including but not limited to publishers, private teachers, tutoring or study services, preparatory schools, vendors operating curriculum mapping services or teacher resource digital platforms and app developers, whether fee-covered or not, is prohibited and is a criminal offense. More information on how to request written permission in the form of a license can be obtained from [https://ibo.org/become-an-ib-school/ib-publishing/l](https://ibo.org/become-an-ib-school/ib-publishing/l)icensing/applying-for-alicense/ . © Organisation du Baccalauréat International 2023 Tous droits réservés. Aucune partie de ce produit ne peut être reproduite sous quelque forme ni par quelque moyen que ce soit, électronique ou mécanique, y compris des systèmes de stockage et de récupération d’informations, sans l’autorisation écritepréalable de l’IB. De plus, la licence associée à ce produit interdit toute utilisation de tout fichier ou extrait sélectionné dans ce produit. L’utilisation par des tiers, y compris, sanstoutefois s’y limiter, des éditeurs, des professeurs particuliers, des services de tutorat oud’aide aux études, des établissements de préparation à l’enseignement supérieur, des fournisseurs de services de planification des programmes d’études, des gestionnaires de plateformes pédagogiques en ligne, et des développeurs d’applications, moyennant paiement ou non, est interdite et constitue une infraction pénale. Pour plus d’informations sur la procédure à suivre pour obtenir une autorisation écrite sous la forme d’une licence, rendez-vous à l’adresse [https://ibo.org/become-an-ib-school/](https://ibo.org/become-an-ib-school/)[ ](https://ibo.org/become-an-ib-school/)[ib-publishing/licensing/applying-for-a-license/.](ib-publishing/licensing/applying-for-a-license/.) © Organización del Bachillerato Internacional, 2023 Todos los derechos reservados. No se podrá reproducir ninguna parte de este productode ninguna forma ni por ningún medio electrónico o mecánico, incluidos los sistemas dealmacenamiento y recuperación de información, sin la previa autorización por escrito del IB. Además, la licencia vinculada a este producto prohíbe el uso de todo archivo ofragmento seleccionado de este producto. El uso por parte de terceros—lo que incluye, a título enunciativo, editoriales, profesores particulares, servicios de apoyo académico oayuda para el estudio, colegios preparatorios, desarrolladores de aplicaciones yentidades que presten servicios de planificación curricular u ofrezcan recursos para docentes mediante plataformas digitales—, ya sea incluido en tasas o no, está prohibido y constituye un delito. En este enlace encontrará más información sobre cómo solicitar una autorización porescrito en forma de licencia: [https://ibo.org/become-an-ib-school/ib-publishing/l](https://ibo.org/become-an-ib-school/ib-publishing/l)icensing/ applying-for-a-license/ . Computer science Higher level Paper 2 30 October 2023 Zone A morning Zone B morning Zone C morning 1 hour 20 minutes 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 [65 marks] . | Option | Questions | | --- | --- | | Option A—Databases | 1 – 4 | | Option B—Modelling and simulation | 5 – 8 | | Option C—Web science | 9 – 13 | | Option D—Object-oriented programming | 14 – 18 | 8823–7012 23 pages © International Baccalaureate Organization 2023 – 2 – 8823–7012 Option A—Databases 1. A restaurant stores information abou

FAQs

What should candidates do according to the examination instructions?

Do not open the examination paper until instructed, and answer all questions from one of the options. The maximum mark for the paper is stated as 65 marks.

Which options are available in Paper 2 and how are the question numbers distributed?

Option A—Databases covers questions 1–4, Option B—Modelling and simulation covers 5–8, Option C—Web science covers 9–13, and Option D—Object-oriented programming covers 14–18.

In Option A—Databases, what database concept is tested using the restaurant example?

The questions test database usage decisions, date formatting benefits, relational schema design with composite primary keys, reasons for key choices, potential query issues from duplicated fields, and constructing steps for queries to retrieve customer visit data.

Aug 27, 2026

Upload by Maeve