9608 y15 sm 1

www.OnlineExamHelp.com

co m Cambridge International Examinations
Cambridge International Advanced Level

COMPUTER SCIENCE

9608/01

For Examination from 2015

Paper 1 Theory Fundamentals

1 hour 30 minutes

nlin

eE

xa

mH

elp
.

SPECIMEN MARK SCHEME

ww
w.O

MAXIMUM MARK: 75

This document consists of 7 printed pages and 1 blank page.
[Turn over

© UCLES 2012

www.OnlineExamHelp.com

2
1

(a) (i) The table/each student has a repeated group of attributes. // Each student has a number of subjects.
[1]
(ii) StudentName, TutorGroup and Tutor would need to be repeated for each record.

(b)
Table: Student
StudentName TutorGroup
Tom
Joe
Samir

6
7
6

Tutor
SAN
MEB
SAN

Table: StudentSubjectChoices
Student
Subject
Name
Tom
Physics
Tom
Chemistry
Tom
General Studies
Joe
Geography
Joe
French
Samir
Computer Science
Samir
Chemistry
Samir
Maths
Samir
General Studies

Level
A
A
AS
AS
AS
A
A
A
A

Mark as follows: complete Student table repetition of StudentName in StudentSubjectChoices table complete columns 2, 3, and 4

[1]

Subject
Teacher
SAN
MEB
DIL
ROG
HEN
VAR
MEB
COR
DIL
[1]
[1]
[1]

(c) (i) primary key...
- an attribute/combination of attributes
- chosen to ensure that the records in a table are unique // used to identify a record/tuple
[2]
(ii) StudentName + Subject (This is the only correct answer.)
(iii) -

[1]

There is a one-to-many relationship. // Student is the ‘one side’ table –
StudentSubjectChoices is the ‘many side’ table. the primary key (attribute StudentName) in Student links to StudentName in the StudentSubjectChoices table
(StudentName in the) StudentSubjectChoices table is the foreign key. //
StudentName is the foreign key that links the two tables.
[max 2]

(d) -

there are non-key attributes ...
SubjectTeacher ... dependent only on part of the primary key (i.e. Subject) // partial dependency

(e) -

there are dependent non-key attributes // there are non-key dependencies
TutorGroup is dependent on Tutor // Tutor is dependent on TutorGroup

[max 2]