9608_w17_qp_12
A paper of Computer Science, 9608
Questions:
7
Year:
2017
Paper:
1
Variant:
2
Login to start this paper & get access to powerful tools
2
The diagram shows three items of software that translate program code. Draw one line from each context to the correct item of translation software. Assembler Interpreter Compiler Context Item of translation software The source code is written in a high-level language. An executable file is produced. The source code uses instructions from the processor’s instruction set. The source code and translation software must both be in main memory at execution time. A web page contains some JavaScript code. A programmer is developing software and has both a compiler and interpreter for the high-level language used. Describe two benefits of using each form of translation software. Benefits of a compiler Benefits of an interpreter
1. Theory Fundamentals  →  1.5. System software
3. Advanced Theory  →  3.4. System software
Open
3
A Local Area Network is used by school staff who access data stored in a Database Management System (DBMS). Explain the difference between security and privacy of data. Give an example for this application where privacy of data is a key concern. Name and describe two security measures the Network Manager has in place to protect the security of the data held in the DBMS. A task for staff at the start of the school year is to key in new pupil data from a paper document. The data is entered to a screen form and includes the data verification of some fields. Describe what is meant by verification.
1. Theory Fundamentals  →  1.6. Security, privacy and data integrity
Open
4
The following diagram shows the components and buses found inside a typical personal computer (PC). A B C Control unit Main memory F E D Some components and buses only have labels A to F to identify them. For each label, choose the appropriate title from the following list. The title for label D is already given. • Control bus • Address bus • Arithmetic Logic Unit (ALU) • General purpose registers • Secondary storage • System clock A B C D Data bus E F Clock speed is a factor that affects the performance of a PC. Explain this statement. An assembly language program can contain both macros and directives. Explain what is meant by these terms. Macro Directive Give an example of the use of a directive. The following 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 LDD Direct addressing. Load the contents of the given address to ACC. LDV #n Relative addressing. Move to the address n locations from the address of the current instruction. Load the contents of this address to ACC. STO Store the contents of ACC at the given address. INC Increment the contents of ACC. OUTCH Output the character corresponding to the ASCII character code in ACC. JPE Following a compare instruction, jump to if the compare was True. JMP Jump to the given address. CMP #n Compare the contents of ACC with number n. The program given in part is to be translated using a two-pass assembler. The program has been copied here for you. Label Instruction StartProg: LDV #Offset CMP Value JPE EndProg OUTCH LDD Offset INC STO Offset JMP StartProg EndProg: END Offset: Value: On the first pass, the assembly process adds entries to a symbol table. The following symbol table shows the first five entries, part way through the first pass. The circular labels show the order in which the assembler made the entries to the symbol table. Complete the symbol table. Use circular labels to show the order in which the assembler makes the entries. Symbol table Symbolic address Relative address StartProg Offset UNKNOWN Value
1. Theory Fundamentals  →  1.4. Processor fundamentals
Open
5
The IEEE Software Engineering Code of Ethics uses eight key principles shown in the right-hand column of the following diagram. Tom is employed as a tester with a software company. He is keen to become a trainee programmer. The middle column in the diagram labels six incidents which have happened to Tom this week. The table that follows the diagram describes each incident. Public Client and Employer Product Judgement Management Profession Colleagues Self Incident A Incident B Incident C Incident D Incident E Incident F Ethical behaviour Unethical behaviour IEEE category Incident Description A Tom has received some phishing emails. He reported this to the bank they were supposed to have come from. B Tom has asked his manager if they will pay for him to attend a programming course. C Tom is testing beta versions of new games software at work. He copies the software on to CD-Rs and sells them to his friends. D Tom has completed the application forms to join the Chartered Institute for IT. E Tom finds it difficult to work with one of his colleagues. His way of dealing with this has been to refuse to speak with the colleague. F Tom’s manager had considered the testing of a new game was completed. Tom reported to his manager that he thought there were still bugs which needed to be rectified. Draw a line on the diagram to link each of the six incidents to either ethical behaviour or unethical behaviour. Consider each incident you have identified as ethical behaviour. Draw a line from each incident to indicate the IEEE category it maps to.
1. Theory Fundamentals  →  1.7. Ethics and ownership
Open
6
A personal computer (PC) is extensively used for a wide range of applications, including the three shown in the following table. Write in the table, a suitable input device, output device, or both needed for each application. Do not give a monitor, keyboard or mouse in your answers. Application Input device Output device Capture the text from a paper document, in order that the text can be word processed Producing a replica of a small plastic component from a washing machine A museum has interactive information facilities throughout the building Explain the basic internal operation of a hard disk drive.
1. Theory Fundamentals  →  1.3. Hardware
3. Advanced Theory  →  3.4. System software
1. Theory Fundamentals  →  1.5. System software
Open
7
A company takes customer service for its clients very seriously. The client • The client names are unique. A visit • The company arranges a date for a visit to gather feedback from a client. • A visit to a client never takes more than one day. • Over time, the client receives many visits. Staff (Interviewers) • One or more staff attend the visit. • If there is more than one staff member visiting, each performs a separate interview. Interviews • Each interview is classified as either ‘general’ or by some specialism, for example, marketing, customer service or sales. • A report is produced for each interview, InterviewText. • Each interview is conducted by a single staff member. The client, visit, staff and interview data will be stored in a relational database. Underline the primary key for each table in the following suggested table designs. STAFF(StaffID, StaffName, Department) CLIENT(ClientName, Address, Town) VISIT(ClientName, VisitDate) INTERVIEW(ClientName, VisitDate, StaffID, SpecialistFocus, InterviewText) For each of the pairs of entities, A, B and C, draw the relationship between the two entities. A CLIENT VISIT B VISIT INTERVIEW C INTERVIEW STAFF The company decides to produce a visit report, VisitReportText, for each visit made. This text will be produced from the one or more interview texts obtained at the visit. State how one or more of the given table designs can be changed to add this attribute. Client ABC Holdings are now trading under the name of Albright Holdings. Write an SQL script to update this client’s record in the database. UPDATE SET WHERE Describe why this update could cause problems with the existing data stored. Write an SQL script to display the Staff ID of each member of staff who performed an interview when they visited New Age Toys on 13/10/2016. At present, all interviews are performed in the UK. Many clients now operate in other countries in Europe. The company wants to perform interviews with the client’s staff in other countries. Not all interview staff are willing to travel outside of the UK. State how one or more of the table designs should be revised to store this information.
1. Theory Fundamentals  →  1.8. Database and data modelling
Open