9618/11

Computer Science 9618/11October/November 2024

Cambridge AS Level · Theory Fundamentals · worked solutions for every part, with the mark scheme

8
questions
75
marks
90
minutes

Topics Information Representation · Processor Fundamentals · System Software · Hardware · Ethics and Ownership · Databases

Q1Medium-EasyInformation Representation
(a)

State one difference between a tebibyte and a gigabyte.

1M
(b)
3M
(i)

Convert the unsigned binary integer into hexadecimal.

110001100111

1M
(ii)

Convert the two’s complement binary number into denary.

100110010111

1M
(iii)

Convert the Binary Coded Decimal (BCD) into denary.

010101110011

1M
(c)

Subtract the denary number 23 from the two’s complement binary number 01001010

Perform this calculation using binary subtraction.

Show your working.

2M
(d)

State one reason why binary addition and subtraction can result in overflow.

1M
Q2Medium-HardDatabases

A shop repairs electronic devices, for example mobile phones and tablet computers. The shop owner stores the data about the repairs using a file-based approach.

(a)

Give one limitation of using a file-based approach to store the data and explain how a relational database addresses this limitation.

3M
(b)

The shop owner creates a relational database called FIXIT.

The database stores data about the customers and the devices for repair.

Some devices need new parts that are ordered from suppliers.

The database FIXIT is designed to include the following tables:

PART(PartID, Description, Price, SupplierID)

CUSTOMER(CustomerID, FirstName, LastName, ContactNumber)

REPAIR(RepairNumber, StartDate, EndDate, CustomerID, Device)

REPAIR_PART(PartID, RepairNumber, Quantity)

11M
(i)

Complete the entity-relationship (E-R) diagram for the given tables.

3M
(ii)

The table shows sample data for the table REPAIR_PART.

PartIDRepairNumberQuantity
ACD128SA00223
PPOR543DWW00221
TR45300231
PPOR543DWW00232
WED500245

Write a Structured Query Language (SQL) script to define the table REPAIR_PART.

Include constraints (restrictions) on the data that can be entered into each field where appropriate.

5M
(iii)

Suppliers send invoices to the company for the parts that are used. A new table, INVOICE, stores the data about each invoice and whether it has been paid or not.

The design for the table INVOICE is shown:

INVOICE(InvoiceID, SupplierID, AmountDue, Paid, DatePaid)

The table shows sample data for the table INVOICE.

InvoiceIDSupplierIDAmountDuePaidDatePaid
000001JK67522.50TRUE01/01/2024
000002WR443358.99FALSE
000003JK67510.21FALSE

Write an SQL script to return the total amount due to the supplier with the ID of JK675 for all the invoices that have not currently been paid.

3M
(c)

Complete the table by writing a definition for each of the database terms.

TermDefinition
Referential integrity
Candidate key
Tuple
3M
Q3MediumProcessor FundamentalsSystem SoftwareHardware

A computer system has a dual-core Central Processing Unit (CPU).

(a)

State the purpose of the system clock and the Control Unit (CU) in a CPU.

System clock .............................................................................................................................

CU .............................................................................................................................................

2M
(b)
5M
(i)

The number of cores in the processor affects the performance of the computer system.

Identify one other feature of a processor that can affect the performance of a computer system and state why it affects the performance.

Feature ..............................................................................................................................

Reason ..............................................................................................................................

2M
(ii)

A solid state (flash) memory drive is automatically recognised by the computer when it is plugged into a port in the computer.

Identify an appropriate type of port to connect the solid state memory drive to the computer.

Explain how this port provides an automatic connection.

Port ....................................................................................................................................

Explanation ........................................................................................................................

3M
(c)

Identify two disadvantages of using Dynamic RAM (DRAM) instead of Static RAM (SRAM) in a computer system.

1 ................................................................................................................................................

2 ................................................................................................................................................

2M
(d)

The computer system is used to store data received from a temperature sensor every five seconds. The data is stored on an optical disc using an optical disc reader/writer.

7M
(i)

Describe the principal operation of an optical disc reader/writer.

4M
(ii)

The computer uses a buffer when writing data to the optical disc.

Explain the use of a buffer when writing data to the optical disc.

3M
Q4MediumSystem SoftwareInformation Representation

A student uses a laptop to write a program that is saved as a text file.

(a)

The laptop has utility software and an Operating System (OS).

4M
(i)

Describe the file management tasks carried out by an OS.

2M
(ii)

Explain the need for back-up software.

2M
(b)

The student compresses the file before it is emailed to their teacher as an attachment.

6M
(i)

Explain the benefits to the teacher of the attachment being a compressed file.

3M
(ii)

Describe one lossless method of compressing a text file.

3M
(c)

The student used a program library when writing their program.

Explain the benefits to the student of using library files when writing a program.

3M
(d)

The program code is written using an Integrated Development Environment (IDE).

4M
(i)

One presentation feature found in a typical IDE is prettyprint.

Identify and describe one other presentation feature found in a typical IDE.

Feature ..............................................................................................................................

Description ........................................................................................................................

2M
(ii)

One debugging feature found in a typical IDE is single stepping.

Identify and describe one other debugging feature found in a typical IDE.

Feature ..............................................................................................................................

Description ........................................................................................................................

2M
Q5Medium-EasyHardware

A security system has both a floodlight (very bright light) and an audio alarm.

The data from multiple sensors is analysed and used to:
• turn on the floodlight
• sound the audio alarm.

Sensors can be used to detect:
• if doors are open
• the external daylight level
• if people are detected within a set distance.

(a)

Complete the table to identify the most appropriate type of sensor for each scenario.

ScenarioType of sensor
A door is open.
The external daylight level is below a set amount.
A person is detected within 2 metres.
1M
(b)

The floodlight (X) and audio alarm (Y) operate according to the following criteria:

ParameterDescription of parameterBinary valueCondition
Aexternal daylight level1Low
0High
Bfront door1Open
0Closed
Cperson is within 2 m1Detected
0Not detected
Dback door1Open
0Closed
Esecurity system1Switched on
0Switched off

The floodlight turns on (X = 1) if:
• the security system is switched on
and
• the external daylight level is low
and
• a person is detected within 2 m.

The audio alarm turns on (Y = 1) if:
• the security system is switched on
and
• one or more doors are open, or a person is detected within 2 m.

Write logic expressions for the security system.

X = ............................................................................................................................................

Y = ............................................................................................................................................

2M
(c)

Explain whether the security system is an example of a monitoring system or a control system.

3M
Q64MMedium-EasyEthics and Ownership

A car park system uses a camera to record the registration number of each car as it enters and leaves the car park.

Explain how artificial intelligence is used in the car park system to identify the car’s registration number.

Similar questions
Q7EasyEthics and Ownership

Software is distributed with a licence.

(a)

Give two benefits of distributing software using a shareware software licence.

1 ................................................................................................................................................

2 ................................................................................................................................................

2M
(b)

Give two benefits of distributing software using a commercial software licence.

1 ................................................................................................................................................

2 ................................................................................................................................................

2M
Q8Medium-EasyProcessor Fundamentals

A computer designed using the Von Neumann model for a computer system contains general purpose registers and special purpose registers.

(a)

Describe the purpose of the Status Register (SR).

2M
(b)

Identify two differences between general purpose registers and special purpose registers.

1 ................................................................................................................................................

2 ................................................................................................................................................

2M