A primary key is a table field that uniquely identifies each record and ensures that duplicate entries are not allowed

A foreign key is primary key of a parent table placed in a child table to ensure that any record added to a child table is related to the one in parent table.

A foreign key is a field (or a set of fields) in one table that refers to the primary key of another table. It is used to establish and enforce a link between the data in the two tables, ensuring referential integrity.

Manages memory (RAM) 

• Allocates memory to programs currently executing •

Ensures programs/data do not corrupt each other: Ensures all programs and data including itself is stored in correct memory locations

Manages processes: Ensures different processes can utilise the CPU and do not interfere with each other or crash •

Allows a user to run programs : On a multi-tasking O/S ensure that all tasks appear to run simultaneously

• Allocates time slices 
• Scheduling of programs
• Handles interrupt
• Allows a user to configure hardware

A variable is a memory location used to store a value

        Misreading error

• Sequential
• Random
• Serial
• Indexed-sequential

• Authenticity
• Users' needs
• Availability of documentation
• Cost
• Compatibility
• Upgradability
• Portability

• Artificial intelligence
• Parallel processing
• Natural language processing
• quantum computing

• Main document
• Data source
• merged document

Serial

• -more accurate/fewer errors over a longer distance
• -less expensive wiring  
• less chance of data being skewed/out of synchronization/order

• allowing the network to share resources like files and software for printers and computers
• support the network's implementation of security features
• controls user accounts
• supplies network administrators with network monitoring tools.

input

• from sensors
• from camera images [Max 2]

processing

• analyse data from sensors
• calculate average traffic flow/speed
• send signals to adjust change lights/timing

output

• change lights at the junction
• change timing plan

1. Operating system manages the computer hardware thus without it the programs cannot communicate directly to the hardware
2. Provide a user interface through which a user can give instructions to the computer. Without a user interface, it would be difficult to load or run programs
3. other programs depend on the operating system to load them into the memory , allocate resources and schedule processor time, Without operating , there would be nothing to co-ordinate the execution of multiples programs
4. The OS organizes data in files and directories, making it possible for programs to save, retrieve, and modify data.
5. Without it, programs wouldn’t know where or how to store data.
6. The OS controls access to files, memory, and devices, ensuring that one program doesn’t interfere with another.

TV remote, wireless mouse , wireless keyboard, used by robots to gauge distance and avoid obstacles,

Multimedia Capability - A laptop with strong multimedia capabilities is essential for a computer studies project submitted on CD-RW. This ensures that the laptop can efficiently handle multimedia content, providing a seamless experience in creating and presenting project materials.

Processor Speed - Opting for a laptop with a high processor speed is crucial. This feature enables the smooth execution of multiple applications simultaneously, enhancing overall project efficiency and reducing processing delays.

Hard Disk Capacity - Consider a laptop with ample hard disk capacity, as the Microsoft Office suite used in computer projects requires significant space for the installation and storage of project files. A spacious hard drive ensures that there is sufficient room for data and applications.

Main Memory Capacity - Given that students often work with multiple programs concurrently during a project, it's important to choose a laptop with an adequate main memory size. A smaller main memory may result in performance issues, hindering the seamless operation of various software applications during project development.

• Standards specify a set of rules for hardware and/or software used in network communications. Because all manufacturers must adhere to the standards when manufacturing network hardware or software, it means that all devices should be able to communicate, regardless of manufacturer.

• All nodes ‘listen’ for traffic to sense when the network is idle.
• When a node wishes to transmit, it transmits a ‘request to send’ frame’ (RTS)
• The intended receiving device will transmit a ‘clear to send’ (CTS) frame if it is available.
• All other nodes ‘sense’ the network is busy and wait a random amount of time before trying to transmit

• Portable
• Light
• Faster access speed
• No moving parts
• Efficient power consumption
• Durable
• Small physical size
• Large storage capacity

Network Failure - when the network becomes faulty or the network is down, users may not access network resources hence operations of an organization may be brought to a standstill

Security Issues:  A computer network can be accessed thus there is an increased chance of hacking

The rapid spread of viruses: Viruses can easily spread to terminals of a computer network which may be very expensive to clear

Cultural and moral effects: adult content may be shared in a networked environment which may be of negative impact on teenagers

Phased:
Advantages:

• only a small part of the operation affected if new system fails
•  no need to pay for two sets of wages

Disadvantages:

•  time consuming (each part needs testing fully before expanding system)

Pilot:
Advantages:

• if new system fails, only that part will be affected
• possible to gradually train staff on pilot before whole system changes over

Disadvantages:

•  time consuming (waiting to see how pilot works before rolling out to rest of the organisation)

Direct:
Advantages:

•  less likely to malfunction since fully tested
• immediate benefits/less time wasted
•  reduced costs (only one system so no need to duplicate staff)

Disadvantages:

• disastrous if the new systems does fail

Parallel:
Advantages:

•  if new system goes down, there is a backup system in place
• possible to gradually train staff/staff have time to get used to the new system

(i) Incorrect use of language, e.g. PLINT instead of PRINT
(ii) A mistake in the structure of the solution, e.g. a jump goes to the wrong line
(iii) Inappropriate arithmetic is used, e.g. division by 0 is attempted