9618 MJ2021 Paper 11 Solution A Level Computer Science Solution by Inqilab Patel

9618 MJ2021 Paper 11 Solution
1 Images are being created to advertise holidays.
Some of the images are bitmap images and some are vector graphics.
(a) Complete the table by defining the image terms.
Drawing list
Pixel
Colour depth [3]
(b) The bitmap images are photographs of the holiday locations.
(i) 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.
1 .........................................................................................................................
2 ................................................................................................................. [2]
(ii) 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.
File size ...........................MB [2]
(c) The photographs are compressed before they are uploaded to a web server.
Customers download the photographs from this web server.
(i) Explain the reasons why compressing the photographs will benefit the customers. [3]
(ii) 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. [3]
2 An organisation uses a database to store data about the types of bird that people have seen.
(a) The database is managed using a Database Management System (DBMS).
(i) State what is meant by a data dictionary and give one example of an item typically found in a data dictionary.
Definition
Example [2]
(ii) State what is meant by data integrity and give one example of how this is implemented in a database.
Definition
Example [2]
(b) 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)
(i) Complete the table by identifying two foreign keys and the database table where each is found.
Foreign key Database table [2]
(ii) 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) [1]
(iii) Part of the database table BIRD_TYPE is shown:
BirdID Name Size
0123 Blackbird Medium
0035 Jay Large
0004 Raven Large
0085 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.