9608_s20_qp_12
A paper of Computer Science, 9608
Questions:
7
Year:
2020
Paper:
1
Variant:
2
Login to start this paper & get access to powerful tools
1
Samira is creating an interactive, multimedia presentation for the entrance to her hotel. The presentation will be on a device that has a resistive touchscreen for user input. Complete the following paragraph about the basic operation of a resistive touchscreen. The resistive touchscreen has two layers with between the layers. When a finger touches the screen, the moves to touch the ; this creates a point of contact. The and position of this point is calculated. Samira uses a computer to draw a logo for her hotel and saves it as a vector graphic. The logo will be placed on the multimedia presentation and elsewhere, such as on signs at the entrance of the hotel. Samira emails the logo to a company that prints signs, and other documentation for the hotel. Describe how the logo is represented by the computer. State two reasons why the hotel logo is saved as a vector graphic instead of a bitmapped graphic.
1. Theory Fundamentals  →  1.1. Information representation
3. Advanced Theory  →  3.4. System software
Open
2
Amir has created a sound file using his desktop computer. Complete the table by writing the missing definitions and term about sound. Term Definition Sampling The number of samples per unit time Sampling resolution The file is too large to be emailed and the file size needs to be reduced. Name one lossless compression technique that can be used to reduce the size of the sound file. Describe one lossy compression technique that can be used to reduce the size of the sound file. Amir’s computer has system software, including utility software and an operating system. Explain how the disk formatter, disk contents analysis and disk repair utilities work together. Amir’s computer has several peripheral devices connected to it. State three peripheral management tasks performed by the operating system. Task 1 Task 2 Task 3 The peripheral devices are plugged into USB ports of the computer. Describe two benefits of connecting the peripheral devices using a USB port.
1. Theory Fundamentals  →  1.1. Information representation
1. Theory Fundamentals  →  1.4. Processor fundamentals
Open
4
Sophie is about to start a new job as a junior software developer. She is worried about joining a new team of people. State one ethical action that Sophie can take to help her to feel more confident about starting work. State two ethical actions that Sophie’s manager can take to help Sophie to feel more confident about starting work. State one ethical action that Sophie’s new colleagues can take to help Sophie to feel more confident about starting work. Explain why Sophie is asked to sign a professional code of conduct before starting work.
1. Theory Fundamentals  →  1.7. Ethics and ownership
Open
5
The steps 1 to 6 describe the first pass of a two‑pass assembler. The following three statements are used to complete the sequence of steps. A If it is already in the symbol table, it checks to see if the absolute address is known B When it meets a symbolic address, it checks to see if it is already in the symbol table C If it is known, it is entered Write one of the letters A, B or C in the appropriate step to complete the sequence. 1. The assembler reads the assembly language instructions 2. 3. If it is not, it adds it to the symbol table 4. 5. 6. If it is not known, it is marked as unknown. The assembler translates assembly code into machine code. The table shows the denary values for three assembler op codes. Op code Denary value LDD ADD STO Convert the denary value for the op code LDD into 8‑bit binary. Convert the denary value for the op code STO into hexadecimal. State why the denary value for the op code ADD cannot be represented in 8‑bit two’s complement form. Justify your answer. The table shows part of the instruction set for a processor. The processor has one general purpose register, the Accumulator (ACC), and an Index Register (. Instruction Explanation Op code Operand LDM #n Immediate addressing. Load the denary number n to ACC LDD Direct addressing. Load the contents of the location at the given address to ACC LDX Indexed addressing. Form the address from + the contents of the Index Register. Copy the contents of this calculated address to ACC LDR #n Immediate addressing. Load the denary number n to IX STO Store contents of ACC at the given address ADD Add the contents of the given address to ACC INC Add 1 to the contents of the register (ACC or CMP Compare contents of the address given with the contents of ACC JPE Following a compare instruction, jump to if the compare was True JPN Following a compare instruction, jump to if the compare was False JMP Jump to the given address OUT Output to screen the character whose ASCII value is stored in ACC END Return control to the operating system
1. Theory Fundamentals  →  1.4. Processor fundamentals
Open
6
A software development company has a relational database, SOFTWARE_MANAGEMENT. The database stores details of the customers who have purchased software, as well as the software and licences that customers have purchased. The SOFTWARE_MANAGEMENT database has the following tables: CUSTOMER_DETAILS(CustomerID, CompanyName, Address1, Address2, City) SOFTWARE_PURCHASED( SoftwareName, SoftwareDescription, CustomerID, LicenceType, LicenceCost, RenewalDate) Explain why this database is not in Third Normal Form (3NF). Refer to the tables in your answer. Do not attempt to normalise the tables. Give an example from the database SOFTWARE_MANAGEMENT for each of the following database terms. Term Example Entity Foreign key Attribute The company also develops computer games. They extend the relational database SOFTWARE_MANAGEMENT by adding a new table. The new table, GAME_DEVELOPMENT, stores details about the games and the software development teams creating them. The table shows example data in GAME_DEVELOPMENT. GameName Genre TeamNumber DevelopmentStage ManagerID Bunny Hop Platform Analysis 23KP Fried Eggs Retro Programming stage 1 9RTU Create‑a‑game Action Acceptance testing 11TF Complete the Data Definition Language (DDL) statement to create the table GAME_DEVELOPMENT. CREATE ………………………………………………………… ………………………………………………………… ( GameName VarChar, Genre VarChar, ………………………………………………………… ………………………………………………………… , DevelopmentStage VarChar, ManagerID VarChar, ………………………………………………………… (GameName) ); Another table, PRODUCT_MANAGER, is created. PRODUCT_MANAGER(ManagerID, FirstName, LastName) Complete the Data Manipulation Language (DML) statement to return the game name, genre and team number of all games managed by the product manager with the first name ‘James’ and the last name ‘Fitz’. ………………………………………………………… GameName, Genre, TeamNumber FROM GAME_DEVELOPMENT, PRODUCT_MANAGER WHERE PRODUCT_MANAGER.FirstName = "James" AND PRODUCT_MANAGER.LastName = "Fitz" AND ………………………………………………………………………………………………… = …………………………………………………………………………………………………… ;
1. Theory Fundamentals  →  1.8. Database and data modelling
Open
7
A company allows customers to stream music from its servers over the Internet. The company’s internet connection is currently provided through copper cables. Identify two pieces of hardware, other than the cables, that enable the servers to connect to the Internet. Describe the purpose of each device. Device 1 Purpose Device 2 Purpose The company wants to upgrade their internet connection to fibre‑optic cables. Give one benefit and one drawback to the company of upgrading to fibre‑optic cables. Benefit Drawback A customer enters a song title into a web page to listen to the song. The design of the web page is shown: Company Name Navigation Bar Enter song title: Search The web page will make use of both client‑side and server‑side scripting. Explain how client‑side scripting will be used in this web page. Explain how server‑side scripting will be used after the customer clicks the ‘Search’ button. The company needs to keep the data on its servers secure from online threats. Describe how a firewall will help to protect the data on the servers from online threats. Give one additional security measure that the company can use to protect the data on the servers from online threats.
1. Theory Fundamentals  →  1.2. Communication and Internet technologies
Open