9618_s23_qp_11
A paper of Computer Science, 9618
Questions:
6
Year:
2023
Paper:
1
Variant:
1
Login to start this paper & get access to powerful tools
1
Images are being created to advertise holidays. Some of the images are bitmap images and some are vector graphics. Complete the table by defining the image terms. Term Definition Drawing list Pixel Colour depth The bitmap images are photographs of the holiday locations. Colour depth and image resolution are both included in the file header of a bitmap image. Identify two other items that could be included in the file header of each photograph. One of the photographs has a bit depth of 8 bytes and an image resolution of 1500 pixels wide and 3000 pixels high. Calculate the file size of the photograph in megabytes. Show your working. Working File size MB The photographs are compressed before they are uploaded to a web server. Customers download the photographs from this web server. Explain the reasons why compressing the photographs will benefit the customers. An image can be compressed using run‑length encoding (RLE). Explain the reasons why RLE may not reduce the file size of a bitmap image. Give one example in your answer.
1. Information representation  →  1.2. Multimedia Graphics
1. Information representation  →  1.3. Compression
Open
2
An organisation uses a database to store data about the types of bird that people have seen. The database is managed using a Database Management System (DBMS). State what is meant by a data dictionary and give one example of an item typically found in a data dictionary. Definition Example State what is meant by data integrity and give one example of how this is implemented in a database. Definition Example The database, Birds, stores information about the types of bird and the people who have seen them. Data about each bird seen is stored with its location and data about the person who saw the bird. Database Birds has the following tables: BIRD_TYPE(BirdID, Name, Size) BIRD_SEEN(SeenID, BirdID, Date, Location, PersonID) PERSON(PersonID, FirstName, LastName, EmailAddress) Complete the table by identifying two foreign keys and the database table where each is found. Foreign key Database table The database Birds has been normalised. Draw one line from each Normal Form to the most appropriate definition. Normal Form Definition All fields are fully dependent on the primary key. There are no repeating groups of attributes. There are no partial dependencies. First Normal Form (1NF) Second Normal Form (2NF) Third Normal Form (3NF) Part of the database table BIRD_TYPE is shown: BirdID Name Size Blackbird Medium Jay Large Raven Large Robin Small The database only supports these data types: • character • varchar • Boolean • integer • real • date • time Write a Structured Query Language (SQL) script to define the table Bird_Type. The database tables are repeated here for reference: BIRD_TYPE(BirdID, Name, Size) BIRD_SEEN(SeenID, BirdID, Date, Location, PersonID) PERSON(PersonID, FirstName, LastName, EmailAddress) Complete the SQL script to return the number of birds of each size seen by the person with the ID of J_123. SELECT BIRD_TYPE.Size, (BIRD_TYPE.BirdID) AS NumberOfBirds FROM BIRD_TYPE, WHERE = "J_123" AND BIRD_TYPE.BirdID = BIRD_TYPE.Size;
8. Databases  →  8.1. Database Concepts
8. Databases  →  8.3. Data Definition Language (DDL) and Data Manipulation Language (DML)
Open
3
A computer has an Operating System (OS). Describe how the Operating System manages the peripheral hardware devices of the computer. Hardware management is one key management task carried out by the Operating System. Identify two other key management tasks carried out by the Operating System. The Operating System has utility software including defragmentation software. Explain how defragmentation can improve the performance of the computer. The computer stores data in binary form. State the difference between a kibibyte and a kilobyte. Convert the denary number 964 into Binary Coded Decimal (BCD). Convert the positive binary integer 11110010 into hexadecimal. Give the smallest and largest two’s complement binary number that can be represented using 8 bits. Smallest Largest Add the following two binary integers using binary addition. Show your working. 1 0 1 1 0 0 0 0 + 0 0 0 1 1 0 1 1 Show the result of a 3‑place right logical shift on the binary number:
5. System Software  →  5.1. Operating Systems
4. Processor Fundamentals  →  4.1. Central Processing Unit (CPU) Architecture
Open
4
A networked closed‑circuit television (CCTsystem in a house uses sensors and cameras to detect the presence of a person. It then tracks the person and records a video of their movements. Data from the CCTV cameras is transmitted to a central computer. This computer has both Read Only Memory (ROM) and Random Access Memory (RAM). Describe the contents of the ROM in the central computer. The central computer has Dynamic RAM (DRAM). Identify two advantages of using DRAM instead of Static RAM (SRAM). The central computer stores the video files on secondary storage. Describe two reasons why magnetic storage is more appropriate than solid state storage for this computer. The CCTV system uses Artificial Intelligence (Ato identify the presence of a person in the house and to track their movements. Describe how AI is used in this system. The CCTV cameras are connected to a network and transfer their data wirelessly to the central computer. Each device on the network has an IP address. Complete the description of IP addresses. An IPv4 address contains groups of digits. Each group is represented in bits and the groups are separated by full stops. An IPv6 address contains groups of digits. Each group is represented in bits. Multiple groups that only contain zeros can be replaced with a . The network makes use of subnetting. Describe two benefits of subnetting a network.
2. Communication  →  2.1. Networks including the internet
4. Processor Fundamentals  →  4.1. Central Processing Unit (CPU) Architecture
Open