9618_s21_qp_12
A paper of Computer Science, 9618
Questions:
8
Year:
2021
Paper:
1
Variant:
2
Login to start this paper & get access to powerful tools
1
Raj owns houses that other people rent from him. He has a database that stores details about the people who rent houses, and the houses they rent. The database, HOUSE_RENTALS, has the following structure: CUSTOMER(CustomerID, FirstName, LastName, DateOfBirth, Email) HOUSE(HouseID, HouseNumber, Road, Town, Bedrooms, Bathrooms) RENTAL(RentalID, CustomerID, HouseID, MonthlyCost, DepositPaid) Give the definition of the following database terms, using an example from the database HOUSE_RENTALS for each definition. Term Definition and example Field Entity Foreign key Tick (3) one box to identify whether the database HOUSE_RENTALS is in Third Normal Form (3NF) or not in 3NF. Justify your choice using one or more examples from the database HOUSE_RENTALS. In 3NF Not in 3NF Justification Example data from the table RENTAL are given: RentalID CustomerID HouseID MonthlyCost DepositPaid 15B5L 1000.00 Yes 3F 687.00 No 12AB 550.00 Yes 444.50 Yes Complete the following Data Definition Language (DDL) statement to define the table RENTAL. CREATE ( RentalID INTEGER NOT NULL, CustomerID INTEGER NOT NULL, HouseID (5) NOT NULL, MonthlyCost NOT NULL, DepositPaid BOOLEAN NOT NULL, (RentalID) ); Write a Data Manipulation Language (DML) script to return the first name and last name of all customers who have not paid their deposit.
8. Databases  →  8.1. Database Concepts
8. Databases  →  8.3. Data Definition Language (DDL) and Data Manipulation Language (DML)
Open
2
Aisha manages a team of software developers. Explain the reasons why it is important that Aisha acts ethically in relation to her team members. The team are developing a computer game where the user plays a board game (such as chess) against the computer. Describe how the computer would use Artificial Intelligence (Ato play the board game. The final game will be released under a licence. Tick (3) one or more boxes in each row to identify the licenceeach statement describes. Statement Free Software Foundation Open Source Initiative Shareware Commercial Software The user can edit the source code The user must always pay before being able to use the software The user can redistribute the software The user always gets a trial period
7. Ethics and Ownership  →  7.1. Ethics and Ownership
Open
4
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 Opcode Operand LDM #n Immediate addressing. Load the number n to ACC LDD Direct addressing. Load the contents of the location at the given address to ACC STO Store contents of ACC at the given address ADD Add the contents of the given address to the ACC INC Add 1 to the contents of the register (ACC or DEC Subtract 1 from the contents of the register (ACC or CMP Compare the contents of ACC with the contents of 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 IN Key in a character and store its ASCII value in ACC OUT Output to the screen the character whose ASCII value is stored in ACC END Return control to the operating system # denotes a denary number, e.g. #123 The current contents of the main memory and selected values from the ASCII character set are: Address Instruction ASCII code table (selected codes only) IN ASCII code Character CMP 100 A JPE 80 B CMP 101 C JPE 76 D JMP 80 LDD 102 INC ACC STO 102 JMP 70 LDD 102 DEC ACC STO 102 JMP 70 … Complete the trace table for the program currently in main memory when the following characters are input: A D Do not trace the program any further when the third input is required. Instruction address ACC Memory address Some bit manipulation instructions are shown in the table: Instruction Explanation Opcode Operand AND #n Bitwise AND operation of the contents of ACC with the operand AND Bitwise AND operation of the contents of ACC with the contents of XOR #n Bitwise XOR operation of the contents of ACC with the operand XOR Bitwise XOR operation of the contents of ACC with the contents of OR #n Bitwise OR operation of the contents of ACC with the operand OR Bitwise OR operation of the contents of ACC with the contents of can be an absolute address or a symbolic address # denotes a denary number, e.g. #123 The contents of the memory address 300 are shown: Bit Number The contents of memory address 300 represent an unsigned binary integer. Write the denary value of the unsigned binary integer in memory address 300. An assembly language program needs to test if bit number 2 in memory address 300 is a 1. Complete the assembly language instruction to perform this test. #4 An assembly language program needs to set bit numbers 4, 5, 6 and 7 to 0, but keep bits 0 to 3 with their existing values. Write the assembly language instruction to perform this action.
4. Processor Fundamentals  →  4.2. Assembly Language
4. Processor Fundamentals  →  4.1. Central Processing Unit (CPU) Architecture
Open
5
Seth uses a computer for work. Complete the following descriptions of internal components of a computer by writing the missing terms. The transmits the signals to coordinate events based on the electronic pulses of the . The carries data to the components, while the carries the address where data needs to be written to or read from. The performs mathematical operations and logical comparisons. Describe the ways in which the following factors can affect the performance of his laptop computer. Number of cores Clock speed Seth accesses both software and data using cloud computing. Give two benefits of storing data using cloud computing. Give two drawbacks of Seth using cloud computing. Draw one line from each term to its most appropriate description. Term Description Public IP address Private IP address Dynamic IP address Static IP address It is only visible to devices within the Local Area Network (LAN) It increments by 1 each time the device connects to the internet A new one is reallocated each time a device connects to the internet It can only be allocated to a router It is visible to any device on the internet It does not change each time a device connects to the internet
2. Communication  →  2.1. Networks including the internet
4. Processor Fundamentals  →  4.1. Central Processing Unit (CPU) Architecture
Open
6
A computer uses the ASCII character set. State the number of characters that can be represented by the ASCII character set and the extended ASCII character set. ASCII Extended ASCII Explain how a word such as ‘HOUSE’ is represented by the ASCII character set. Unicode is a different character set. The Unicode value for the character ‘1’ is denary value 49. Write the hexadecimal value for the Unicode character ‘1’. Write the denary value for the Unicode character ‘5’.
1. Information representation  →  1.1. Data Representation
Open
7
Jennifer is writing a computer program for her A Level homework. Jennifer uses a program library to help her write her computer program. Describe how a program library can be used while writing a computer program. Jennifer uses an Integrated Development Environment (IDE) to write her computer program. The IDE allows Jennifer to use both an interpreter and a compiler while creating her computer program. Describe the ways in which Jennifer can use both a compiler and an interpreter while developing the program. Identify two debugging tools that a typical IDE can provide.
5. System Software  →  5.2. Language Translators
Open
8
A company has several security measures in place to prevent unauthorised access to the data on its computers. Describe the difference between the security and privacy of data. Each employee has a username and password to allow them to log onto a computer. An employee’s access rights to the data on the computers is set to either read-only, or read and write. Identify one other software-based measure that could be used to restrict the access to the data on the computers. The company is also concerned about threats posed by networks and the internet. Identify two threats to the data that are posed by networks and the internet. Threat 1 Threat 2
6. Security, privacy and data integrity  →  6.1. Data Security
Open