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

M16/4/COMSC/SP2/ENG/TZ0/XX Computer science Standard level Paper 2 © International Baccalaureate Organization 2016 14 pages 2216 – 7015 Thursday 5 May 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 – 12 1 hour – 2 – Option A — Databases 1. CrossCountryXL is a transport company that delivers items from different retailers. Each retailer has many suppliers. (a) Construct the entity-relationship diagram for this scenario. [3] CrossCountryXL constructs a relational database to store data about the items that suppliers supply to retailers. The following tables form part of this database. • The SUPPLIER table contains contact details for each supplier. Each supplier supplies only one item • The SUPPLY table identifies the supplier’s item. The attribute “Nature_Of_Goods” takes a value of “P” for perishable or “NP” for non-perishable items • The ITEM table contains the item details. Some of the data in these tables is shown below and on the following page. The underlined attribute indicates the primary key in each table. SUPPLIER Supplier_ID Name Email_ID Location 98769171 Joyce [Email removed] Paris 34567890 Ahmed [Email removed] Seville 54959299 John [Email removed] Rotterdam 32010309 George [Email removed] Frankfurt 45908919 Ram [Email removed] London …… …… …… …… SUPPLY Supplier_ID Item_ID Nature_Of_Goods 98769171 X391 NP 34567890 B453 P 54959299 X892 P 32010309 X903 NP 45908919 B670 P …… …… …… (Option A continues on the following page) M16/4/COMSC/SP2/ENG/TZ0/XX