9618/12 · Oct/Nov 2024
Download PDFComplete the truth table for the logic expression:
Draw the logic circuit for the logic expression:
Embedded systems are used in many electronic devices.
Describe the drawbacks of embedded systems.
An embedded system has Dynamic RAM (DRAM). Identify one benefit of using DRAM instead of Static RAM (SRAM) in an embedded system.
Give two differences between Erasable Programmable ROM (EPROM) and Electrically Erasable Programmable ROM (EEPROM). Difference 1 Difference 2
A student has a computer.
The computer is designed using the Von Neumann model for a computer system. Complete the table by describing the purpose of each of the given registers.
The student needs to connect the computer to a monitor that has a screen resolution of pixels. The monitor also has built-in speakers. The computer has a Video Graphics Array (VGA) port and a High Definition Multimedia Interface (HDMI) port. Explain the benefits of connecting the monitor to the computer using the HDMI port instead of the VGA port.
The computer has an Operating System (OS). One of the key management tasks of the OS is process management. Describe the process management tasks performed by an OS.
A program is written in a high-level language by a team of three programmers using an Integrated Development Environment (IDE).
Describe how the programmers can use the debugging features of a typical IDE during the development of the program.
The programmers created a new program library whilst developing the program. Describe the benefits to the programmers of creating a program library.
The file containing the final program code will be sent by email for beta testing. Identify one security method that can be used to protect the program code from unauthorised access during email transfer. Explain how your chosen method protects the program code. Security method Explanation
A computer programmer is learning about the importance of acting ethically at work.
Explain the reasons why the computer programmer needs to act ethically towards colleagues and the public. Colleagues The public
The programmer writes a program to be used in a business. The source code of the program can be modified by the business. The business pays the programmer for the maintenance and security updates. Identify one suitable type of software licence for the program and describe the reasons for your choice. Type of software licence Reasons for choice
Explain the reasons why the programmer should copyright their program.
A company uses a relational database to store data about its customers, employees and the individual repair jobs that customers have booked.
Explain the benefits of using a relational database instead of a file-based approach.
The company decides which employees will work on each repair job. An employee can log into the database to access information about their repair jobs. The database is normalised and includes these tables: • CUSTOMER stores personal data about each customer • EMPLOYEE stores personal data about each employee • LOGIN_DATA stores the username and password for each employee • JOB stores the data about each repair job • JOB_EMPLOYEE stores the employees that are working on each repair job. Identify each relationship between the database tables and explain how each relationship can be implemented in the normalised database.
The database also has the table INVOICE that stores data about each invoice that is sent to a customer. Example data from the table INVOICE is given. InvoiceID | DateSent | Amount | Paid | JobID 29262 | 12/12/2023 | 105.20 | Y | 221 26765 | 11/11/2023 | 200.00 | Y | 315 13290 | 02/01/2024 | 50.00 | Y | 315 34090 | 05/02/2024 | 25.95 | N | 569 Write a Structured Query Language (SQL) script to return the total amount of all the invoices sent in the year 2023 that have been paid.
A student takes a photograph of a science experiment.
The photograph is saved as a bitmapped image. Define the following bitmap terms. Colour depth File header
Explain why changing the image resolution will affect the image quality and file size. Image quality File size
Identify one lossless method of compressing an image.
The student draws a picture on paper that is scanned into the computer and saved as a vector graphic. Define the vector graphic terms property and drawing list. Property Drawing list
The following table shows part of the instruction set for a processor. The processor has two registers, the Accumulator (ACC) and the Index Register (IX). Instruction | Explanation Opcode | Operand | LDM | #n | Immediate addressing. Load the number n to ACC LDD | <address> | Direct addressing. Load the contents of the location at the given address to ACC LDI | <address> | Indirect addressing. The address to be used is at the given address. Load the contents of this second address to ACC LDX | <address> | Indexed addressing. Form the address from <address> + the contents of the index register. Copy the contents of this calculated address to ACC LDR | #n | Immediate addressing. Load the number n to IX ADD | #n/Bn/&n | Add the number n to the ACC ADD | <address> | Add the contents of the given address to the ACC SUB | #n/Bn/&n | Subtract the number n from the ACC SUB | <address> | Subtract the contents of the given address from the ACC INC | <register> | Add 1 to the contents of the register (ACC or IX) DEC | <register> | Subtract 1 from the contents of the register (ACC or IX) <address> can be an absolute or a symbolic address # denotes a denary number, e.g. #123 B denotes a binary number, e.g. B01001010 & denotes a hexadecimal number, e.g. &4A
The current contents of memory are shown: Address | Data 19 | 25 20 | 23 21 | 2 22 | 4 23 | 15 24 | 50 25 | 22 The current contents of the ACC and IX are shown: ACC 50 IX 20 Complete the table by writing the content of the ACC and the IX after each set of instructions has run.
The instruction set also includes these bit manipulation instructions: Instruction | Explanation Opcode | Operand | AND | #n/Bn/&n | Bitwise AND operation of the contents of ACC with the operand AND | <address> | Bitwise AND operation of the contents of ACC with the contents of <address> XOR | #n/Bn/&n | Bitwise XOR operation of the contents of ACC with the operand XOR | <address> | Bitwise XOR operation of the contents of ACC with the contents of <address> OR | #n/Bn/&n | Bitwise OR operation of the contents of ACC with the operand OR | <address> | Bitwise OR operation of the contents of ACC with the contents of <address> LSL | #n | Bits in ACC are shifted logically n places to the left. Zeros are introduced on the right-hand end LSR | #n | Bits in ACC are shifted logically n places to the right. Zeros are introduced on the left-hand end. <address> can be an absolute or a symbolic address # denotes a denary number, e.g. #123 B denotes a binary number, e.g. B01001010 & denotes a hexadecimal number, e.g. &4A The current content of the ACC is shown: ACC 1 0 0 1 1 0 1 0 The table has three sets of instructions. The binary number 10011010 is reloaded into the ACC before each set of instructions is run. Complete the table by writing the content of the ACC after each set of instructions has run.
Explain how bit manipulation can be used to test whether the binary number stored in the ACC represents an odd denary number. Write the bit manipulation instruction that will be used. Explanation Instruction
A road bridge has a weight limit and a height limit for vehicles. For example, a vehicle must weigh less than and must have a height of less than . The bridge has a warning system. If a vehicle is approaching the bridge and it exceeds one or both limits, a sign displays a warning telling the driver of the vehicle to stop.
The bridge warning system uses sensors to detect if a vehicle exceeds the limits. Complete the table by identifying two different sensors that could be used by the system and describe how each sensor is used by the system.
Explain whether the bridge warning system is an example of a monitoring system or of a control system.