9608_w20_qp_11
A paper of Computer Science, 9608
Questions:
8
Year:
2020
Paper:
1
Variant:
1
Login to start this paper & get access to powerful tools
1
Draw one or more lines to link each language translator to the most appropriate statement. Language translator Statements Compiler Interpreter Converts a low-level language instruction into binary Stops as soon as it finds a syntax error Needs the source code to be present when the user’s program is run Reports all errors found at the end of the process Corrects syntax errors as they are detected Converts a high-level language into a different form Creates an executable file
1. Theory Fundamentals  →  1.5. System software
2. Fundamental Problem-solving and Programming Skills  →  2.4. Software development
3. Advanced Theory  →  3.4. System software
Open
2
A veterinary surgery cares for sick animals. The surgery has a file-based database that stores data about the pets, their owners, and appointments made with the surgery. The surgery wants to upgrade to a relational database. Explain the reasons why the surgery should upgrade their database. The design for the surgery database, SURGERY, is: PET(PetID, OwnerFirstName, OwnerLastName, PetName, PetBreed, PetDateOfBirth, TelephoneNumber) APPOINTMENT(AppointmentID, Date, Time, StaffID, PetID) Give one reason why the database design for SURGERY is not in Third Normal Form (3NF). The database needs to be normalised to 3NF. A pet may have more than one owner and an owner may have more than one pet. The appointment table does not need to change and has been repeated below. Give the name and attributes of three additional tables in 3NF. Identify the primary keyin each table. APPOINTMENT(AppointmentID, Date, Time, StaffID, PetID) Table 1 Table 2 Table 3 Part of the table APPOINTMENT is shown. The veterinary surgery uses Data Manipulation Language (DML) statements to search for appointments. AppointmentID Date Time StaffID PetID 02/02/2021 12:40 JK1 20CF 02/02/2021 12:40 PP2 10DT 02/02/2021 12:50 JK1 9RR 02/02/2021 13:00 JK1 7MR Identify the industry standard language that provides both DML and Data Definition Language (DDL) statements. Write a DDL statement to update the table APPOINTMENT and define AppointmentID as the primary key. Complete the DML script to display the times and Pet IDs of all appointments on 02/02/2021 with staff ID of ‘JK1’, in descending order of time. SELECT , FROM APPOINTMENT WHERE AND ORDER BY Time ; New pet owners complete a paper-based form to register their pets at the surgery. Describe two verification checks that can be carried out when the data from the paper- based form is entered into the database. Appointments can be booked between 09:00 and 16:50 on Monday to Friday. Describe the ways in which the appointment date and time can be validated to make sure they are reasonable. The surgery has five computers that can all access the database. A copy of the database is stored centrally. Complete the description of this type of network model by filling in the missing terms. The model has one that stores all the data for the surgery. The other computers are . When a user requests data, a request is sent to the . The surgery wants to keep all data secure. The surgery network is not connected to the Internet. Identify two authentication techniques the surgery could use to restrict access to the data.
1. Theory Fundamentals  →  1.8. Database and data modelling
Open
3
Ria manages a team of software developers. The team is creating a mobile application game for a client. Ria wants to ensure that her team works to the ACM/IEEE Software Engineering Code of Ethics. Explain the ways in which Ria and her team can ensure that they follow the Code of Ethics in relation to the product and their colleagues. Product Colleagues Ria’s client wants to sell the game for a profit. The client cannot decide which type of software licence to use to distribute the game. Identify two types of licence that Ria could recommend to her client and justify the use of each licence. Licence 1 Justification Licence 2 Justification
1. Theory Fundamentals  →  1.7. Ethics and ownership
Open
4
The following table shows assembly language instructions for a processor that has one general purpose register, the Accumulator (ACC). Instruction Explanation Op code Operand LDD Direct addressing. Load the contents of the location at the given address to ACC. LDM #n Immediate addressing. Load the denary number n to ACC. LDI Indirect addressing. The address to be used is at the given address. Load the contents of this second address to ACC. CMP Compare the contents of ACC with . STO Store contents of ACC at the given address. ADD Add the contents of the given address to ACC. SUB Subtract the contents of the given address from the contents of ACC. OUT Output to screen the character whose ASCII value is stored in ACC. INC Add 1 to the contents of the register (ACC or . JPE Following a compare instruction, jump to if the compare was True. END Return control to the operating system. The current contents of the main memory are: Address Instruction LDD 200 ADD 201 ADD 202 SUB 203 STO 204 END … Tick (✓) one box to indicate which one of the following statements is true after program execution. Statements Tick (✓) Memory location 204 contains 400 Memory location 204 contains 41 Memory location 204 contains 231 Memory location 204 contains 29 The current contents of the main memory are: Address Instruction LDM #120 ADD 121 SUB 122 STO 120 END … Tick (✓) one box to indicate which one of the following statements is true after program execution. Statement Tick (✓) Memory location 120 contains 135 Memory location 120 contains 118 Memory location 120 contains 0 Memory location 120 contains 16 The current contents of the main memory are: Address Instruction LDI 200 ADD 200 ADD 201 STO 205 END … Tick (✓) one box to indicate which one of the following statements is true after program execution. Statement Tick (✓) Memory location 205 contains 607 Memory location 205 contains 601 Memory location 205 contains 603 Memory location 205 contains 606 Identify two modes of addressing that are not used in parts , or . Assembly language instructions can be put into groups. Tick (✓) one box on each row to indicate the appropriate instruction group for each assembly language instruction. Assembly language instruction Arithmetic Data movement Jump instruction Input and output of data STO 120 JPE 200 ADD 3 LDD 20 INC ACC OUT
1. Theory Fundamentals  →  1.4. Processor fundamentals
Open
5
Oscar is watching a concert on his laptop computer. The concert is streamed to his computer at the same time as it is taking place. Identify whether Oscar is using real-time or on-demand bit streaming. Justify your choice. Streaming method Justification The video of the concert repeatedly stops and restarts while Oscar is watching it on his laptop computer. His friend is watching the same video of the concert at the same time, in a different location, but he does not experience the same problem as Oscar. Give three possible reasons why Oscar’s video constantly stops and starts again. The video of the concert is made up of a sound track and multiple images. Two successive frames of one section of the video are shown. The pixel colours are represented by letters. BL BL BL RD RD RD BL BL BL RD RD RD K K K K K K BL BL BL RD RD RD LG LG LG DG DG DG LG LG LG DG DG DG Y Y K Y Y K BK BK BK BK BK BK W K W W W DG W K W W W DG P P P P P P P P P P P P Frame 1 Frame 2 Explain the way in which progressive encoding can be used to transmit Frames 1 and 2. Explain, using Frames 1 and 2 as an example, the way in which temporal redundancy can be used to compress a video. Give another type of redundancy technique that can be used to compress a video. MP4, WMV and AVI are all examples of a type of format that combines sound and image components into a video. Identify the type of format that combines the sound and image components into a video.
1. Theory Fundamentals  →  1.1. Information representation
1. Theory Fundamentals  →  1.2. Communication and Internet technologies
Open
8
Joshua’s laptop is connected to the router on his home network. The laptop has a private IP address. The router has both public and private IP addresses. Explain the reasons why Joshua’s laptop has a private IP address only, but the router has both a private and a public IP address. Joshua visits a website by entering its Uniform Resource Locator (URL). Describe how the URL is converted into a matching IP address. Give one example of a valid IPv4 address.
1. Theory Fundamentals  →  1.2. Communication and Internet technologies
Open