9608_w17_qp_11
A paper of Computer Science, 9608
Questions:
7
Year:
2017
Paper:
1
Variant:
1
Login to start this paper & get access to powerful tools
1
Each of the following bytes represents an integer in two’s complement form. State the denary value. 0111 0111 Denary 1000 1000 Denary Express the following integer in two’s complement form. -17 State in denary, the range of integer values that it is possible to represent in two’s complement integers using a single byte. Lowest value Highest value Convert the following denary integer into Binary Coded Decimal (BCD). A 3-digit BCD representation has been incorrectly copied. It is shown as: State how you can recognise that this is not a valid BCD representation. Describe a practical application where BCD is used.
1. Theory Fundamentals  →  1.1. Information representation
3. Advanced Theory  →  3.1. Data representation
Open
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 A web page contains a client-side script. Each instruction in the source code consists of an op code and an operand. The source code is required at run-time. When the source code is translated, copies of the executable program can be distributed without the need for the source code. The Java programming language is said to be machine or platform independent. Describe what is meant by machine independent. Describe how a Java source code program is translated.
1. Theory Fundamentals  →  1.5. System software
3. Advanced Theory  →  3.4. System software
2. Fundamental Problem-solving and Programming Skills  →  2.4. Software development
Open
3
A Local Area Network is used by staff in a hospital to access data stored in a Database Management System (DBMS). Name two security measures to protect computer systems. A frequent task for staff is to key in new patient data from a paper document. The document includes the patient’s personal ID number. The Patient ID is a seven digit number. The database designer decides to use a check digit to verify each foreign key value that a user keys in for a Patient ID. When a user assigns a primary key value to a Patient ID, the DBMS adds a modulus-11 check digit as an eighth digit. The DBMS uses the weightings 6, 5, 4, 3, 2 and 1 for calculating the check digit. It uses 6 as the multiplier for the most significant digit. Show the calculation of the check digit for the Patient ID with the first six digits 786531. Complete Patient ID Name and describe two validation checks that the DBMS could carry out on each primary key value that a user keys in for a Patient ID. Validation check Description Validation check Description
1. Theory Fundamentals  →  1.6. Security, privacy and data integrity
1. Theory Fundamentals  →  1.8. Database and data modelling
Open
4
The diagram shows the components and buses found inside a typical Personal Computer (PC). General purpose registers A B C Arithmetic Logic Unit (ALU) 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 • System clock • Data bus • Control unit • Main memory • Secondary storage A B C D Address bus E F 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 Op code LDM #n 1100 0001 Immediate addressing. Load number n to ACC. LDD 1100 0010 Direct addressing. Load the contents of the given address to ACC. LDV #n 1100 0011 Relative addressing. Move to the address n locations from the address of the current instruction. Load the contents of this address to ACC. STO 1100 0100 Store the contents of ACC at the given address. DEC 1100 0101 Decrement the contents of ACC. OUTCH 1100 0111 Output the character corresponding to the ASCII character code in ACC. JNE 1110 0110 Following a compare instruction, jump to if the compare was False. JMP 1110 0011 (Unconditionally) jump to the given address. CMP #n 1110 0100 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. The program now starts with a directive which tells the assembler to load the first instruction of the program to address 100. Label ORG #0100 StartProg: LDV #CountDown CMP Num1 JNE CarryOn JMP Finish CarryOn: OUTCH LDD CountDown DEC STO CountDown JMP StartProg Finish: LDM #88 OUTCH END CountDown: Num1: On the first pass of the two-pass process, the assembler adds entries to a symbol table. The following symbol table shows the first eleven entries, part way through the first pass. The circular labels show the order in which the assembler made the entries to the symbol table. Symbol table Symbolic address Absolute address StartProg CountDown UNKNOWN Num1 UNKNOWN CarryOn UNKNOWN 104 11 Finish UNKNOWN Explain how the assembler made these entries to the symbol table. The assembler software must then complete the second pass building up the executable file. Name the second table needed when the assembler software carries out the second pass. The following shows two of the program instructions in machine code. Machine code Instruction Binary Hexadecimal OUTCH 1100 0111 C7 JNE CarryOn A B Each of the numbers A and B represents the complete instruction in two bytes, one byte for the op code and one byte for the operand. Use the following instruction set to write the numbers for A and B. A B Instruction Explanation Op code Operand Op code LDM #n 1100 0001 Immediate addressing. Load number n to ACC. LDD 1100 0010 Direct addressing. Load the contents of the given address to ACC. LDV #n 1100 0011 Relative addressing. Move to the address n locations from the address of the current instruction. Load the contents of this address to ACC. STO 1100 0100 Store the contents of ACC at the given address. DEC 1100 0101 Decrement the contents of ACC. OUTCH 1100 0111 Output the character corresponding to the ASCII character code in ACC. JNE 1110 0110 Following a compare instruction, jump to if the compare was False. JMP 1110 0011 (Unconditionally) jump to the given address. CMP #n 1110 0100 Compare the contents of ACC with number n.
1. Theory Fundamentals  →  1.4. Processor fundamentals
Open
6
Raj has joined a software company as a trainee programmer. He was given the company’s Code of Conduct document during his induction training. The handbook has a section headed ‘Ethical Behaviour’. Describe what is meant by ethics. Raj is assigned to work as a new member of a development team. In his first week, Raj feels uncomfortable working with one of his colleagues. He is unfamiliar with the programming language used by the team. Next week, he will be working on the site of one of the company’s clients with a colleague. Raj is very nervous about working in an unfamiliar workplace. Raj has a review with his manager after his first three weeks. The Code of Conduct document was produced by the Human Resources section. It closely follows the ACM/IEEE Software Engineering Code of Ethics that uses these eight key principles: Public Client and Employer Product Judgement Management Profession Colleagues Self There are issues Raj will want to raise with his manager. • Describe two of these issues. • Circle the key ACM/IEEE principle this comes under. • Suggest what action should be taken to demonstrate ethical behaviour. Issue 1 Description ACM/IEEE principle (Circle one only) Public Client and Employer Product Judgement Management Profession Colleagues Self Possible action
1. Theory Fundamentals  →  1.7. Ethics and ownership
Open
7
A clinic is staffed by several doctors. The clinic serves thousands of patients. Each day and at any one time, there is only one doctor in the clinic available for appointments. The clinic stores patient, doctor and appointment data in a relational database. Underline the primary key for each table in the following suggested table designs. PATIENT(PatientID, PatientName, Address, Gender) DOCTOR(DoctorID, Gender, Qualification) APPOINTMENT(AppointmentDate, AppointmentTime, DoctorID, PatientID) Complete the following entity-relationship (E-R) diagram for this design. The doctors are concerned that many patients make appointments but do not attend them. Describe the changes to the table designs that could be made to store this information. The doctors are about to set up a new clinic in the neighbouring village, SITE-B. The original location is identified as SITE-A. A new table is designed to store the ID of the doctor who is able to work at each site. DOCTOR-AVAILABILITY(DoctorID, Site) Five entries stored in the table are: DoctorID Site SITE-A SITE-A SITE-B SITE-B SITE-B State what this data shows about the availability of the doctor with the ID of 098. Opening a new clinic in the neighbouring village will not require any additional table for storing appointments. It will need a change to the existing appointment table design. Show the revised APPOINTMENT table. APPOINTMENT( ) The doctor with the ID of 117 has recently been allocated a new DoctorID of 017. Write an SQL script to update this doctor’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 date and time of all appointments made by the patient with the PatientID of 556.
1. Theory Fundamentals  →  1.8. Database and data modelling
Open