9618_s23_qp_13
A paper of Computer Science, 9618
Questions:
7
Year:
2023
Paper:
1
Variant:
3
Login to start this paper & get access to powerful tools
2
A university has two sites. Each site has several computer rooms. The computers are all connected as a WAN (wide area network). Identify two differences between a WAN and a LAN (local area network). The network uses different topologies in different areas of the sites. In one building there are five computers connected in a mesh topology. Describe what is meant by a mesh topology. Give two advantages of using a mesh topology instead of a bus topology. The computers in one room are set up as thin-clients in a client-server model. Describe the role of the different computers in this model. Students can connect their devices to the university network using cables or a wireless connection. Explain the benefits to the students of allowing them to use both wired and wireless connections. One site has split the network into several subnetworks. An IP address in a subnetwork is divided into two parts. Identify and describe the two parts of an IP address in a subnetwork.
2. Communication  →  2.1. Networks including the internet
Open
3
A mobile telephone is used to record a video. The mobile telephone has a touchscreen. There are different types of touchscreen. Complete the description of the principal operation of touchscreens. A touchscreen has two layers. When the user touches the screen, the layers touch and a is completed. A touchscreen has several layers. When the top layer is touched, there is a in the electric current. A microprocessor identifies the of the touch. The mobile telephone uses a built-in digital camera to record the video. The digital camera automatically focuses on the faces of people. Explain how Artificial Intelligence (Ais used by the camera to automatically focus on the faces of people. The video includes a sound recording. Describe how sound is represented in a computer. A second video is recorded. The sound in the second video needs to be more precise. Explain the reasons why increasing the sampling rate and the sampling resolution will improve the precision of the second recording. Sampling rate Sampling resolution
1. Information representation  →  1.2. Multimedia Sound
Open
4
A shop rents cars to customers. The shop uses a relational database to store information about the rentals. Describe two ways in which a relational database addresses the limitations of a file-based approach. Complete the table by writing the missing term or description for each database feature. Term Description An object that data is stored about. Tuple Secondary key A field in one table that is linked to a primary key in another table. The car rental database is not normalised. The current database design is: BOOKING(CarRegistration, StartDate, EndDate, CarModel, CarColour, CustomerFirstName) CUSTOMER(CustomerFirstName, CustomerLastName, EmailAddress, TelephoneNumber) Write a normalised database design for this database. All tables must be in Third Normal Form (3NF). Use the field names given and underline the primary key fields. The data is validated and verified when it is entered into the database. The car registration number must be: 1 letter, followed by 3 numbers, followed by 2 letters. For example, A123AA is valid but A12AA is invalid. One way that a registration number can be validated is by using a presence check to make sure the registration number has been entered. Describe two other ways that the car registration number can be validated. Describe two ways that the car registration number can be verified when it is entered into the database. State why the car registration number might be incorrect even after it has been validated and verified.
8. Databases  →  8.1. Database Concepts
Open
5
A programmer is developing a computer game in a high-level language to sell to the public. The programmer uses both an interpreter and a compiler at different stages of the development of the program. Explain the reasons why the programmer uses an interpreter while writing the program code. Explain the reasons why the programmer uses a compiler when the program has been written. The programmer needs to publish the game under a software licence so that it can be sold to the public. Identify the most appropriate type of software licence for the game and justify your choice. Licence Justification
5. System Software  →  5.2. Language Translators
7. Ethics and Ownership  →  7.1. Ethics and Ownership
Open
6
Data needs to be kept secure when stored on a computer and during transmission over a network. Explain how a digital signature is used to authenticate a digital document during transmission over a network. Complete the table by identifying and describing two types of software that can be installed on a computer to prevent threats over a network. Type of software Description ……………………… ……………………… ……………………… ………………………
6. Security, privacy and data integrity  →  6.1. Data Security
17. Security  →  17.1. Encryption, Encryption Protocols and Digital Certificates
Open
7
A computer stores data in binary form. Draw one line from each description to its matching denary value. Description Denary value The smallest integer that can be represented in 8-bit two’s complement. The largest integer that can be represented in 8-bit two’s complement. The largest unsigned integer that can be represented in 8 bits. −255 −128 −256 −127 The computer has a Control Unit (CU), system clock and control bus. Explain how the CU, system clock and control bus operate to transfer data between the components of the computer system. Complete the table by writing the register transfer notation for each stage of the Fetch-Execute (F-E) cycle given in the table. Stage description Register transfer notation The Program Counter (PC) is incremented The data in the address stored in the Memory Address Register (MAR) is copied to the Memory Data Register (MDR)
4. Processor Fundamentals  →  4.1. Central Processing Unit (CPU) Architecture
Open