Cambridge International AS & A Level

*1243813249*

Cambridge International AS & A Level

COMPUTER SCIENCE Paper 1 Theory Fundamentals

You must answer on the question paper. No additional materials are needed.

9608/11 October/November 2020

1 hour 30 minutes

INSTRUCTIONS Answer all questions. Use a black or dark blue pen. Write your name, centre number and candidate number in the boxes at the top of the page. Write your answer to each question in the space provided. Do not use an erasable pen or correction fluid. Do not write on any bar codes. You may use an HB pencil for any diagrams, graphs or rough working. Calculators must not be used in this paper.

INFORMATION The total mark for this paper is 75. The number of marks for each question or part question is shown in brackets [ ]. No marks will be awarded for using brand names of software packages or hardware.

DC (CJ) 188576/2 ? UCLES 2020

This document has 16 pages. Blank pages are indicated.

[Turn over

2 1 Draw one or more lines to link each language translator to the most appropriate statement(s).

Language translator

Statements

Converts a low-level language instruction into binary

Compiler Interpreter

Stops as soon as it finds a syntax error

Needs the source code to be present when the user's program is run

Reports all errors found at the end of the process

Corrects syntax errors as they are detected

Converts a high-level language into a different form

Creates an executable file [3]

? UCLES 2020

9608/11/O/N/20

3 2 A veterinary surgery cares for sick animals. The surgery has a file-based database that stores

data about the pets, their owners, and appointments made with the surgery. The surgery wants to upgrade to a relational database. (a) Explain the reasons why the surgery should upgrade their database.

................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ................................................................................................................................................... ............................................................................................................................................. [4] (b) The design for the surgery database, SURGERY, is: PET(PetID, OwnerFirstName, OwnerLastName, PetName, PetBreed,

PetDateOfBirth, TelephoneNumber)

APPOINTMENT(AppointmentID, Date, Time, StaffID, PetID) (i) Give one reason why the database design for SURGERY is not in Third Normal Form

(3NF). ........................................................................................................................................... ..................................................................................................................................... [1]

? UCLES 2020

9608/11/O/N/20

[Turn over

4 (ii) The database needs to be normalised to 3NF. A pet may have more than one owner and

an owner may have more than one pet.

The appointment table does not need to change and has been repeated below.

Give the name and attributes of three additional tables in 3NF. Identify the primary key(s) in each table.

APPOINTMENT(AppointmentID, Date, Time, StaffID, PetID)

Table 1 ...............................................................................................................................

...........................................................................................................................................

...........................................................................................................................................

Table 2 ...............................................................................................................................

...........................................................................................................................................

...........................................................................................................................................

Table 3 ...............................................................................................................................

...........................................................................................................................................

........................................................................................................................................... [4]

(c) Part of the table APPOINTMENT is shown. The veterinary surgery uses Data Manipulation Language (DML) statements to search for appointments.

AppointmentID 222010 222011 222012 222013

Date 02/02/2021 02/02/2021 02/02/2021 02/02/2021

Time 12:40 12:40 12:50 13:00

StaffID JK1 PP2 JK1 JK1

PetID 20CF 10DT 9RR 7MR

(i) Identify the industry standard language that provides both DML and Data Definition Language (DDL) statements.

...........................................................................................................................................

..................................................................................................................................... [1]

? UCLES 2020

9608/11/O/N/20

5 (ii) Write a DDL statement to update the table APPOINTMENT and define AppointmentID

as the primary key. ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... ..................................................................................................................................... [2] (iii) Complete the DML script to display the times and Pet IDs of all appointments on 02/02/2021 with staff ID of `JK1', in descending order of time. SELECT ........................................................ , ........................................................

FROM APPOINTMENT

WHERE ........................................................ AND ........................................................ ORDER BY Time ........................................................ ;

[3] (d) New pet owners complete a paper-based form to register their pets at the surgery.

(i) Describe two verification checks that can be carried out when the data from the paperbased form is entered into the database. 1 ........................................................................................................................................ ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... 2 ........................................................................................................................................ ........................................................................................................................................... ........................................................................................................................................... ........................................................................................................................................... [4]

? UCLES 2020

9608/11/O/N/20

[Turn over

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download