Computer Systems
A protective barrier helps prevent unauthorised access to a network by filtering incoming and outgoing traffic.
What is a Firewall?
Legislation covering the collection and storing of personal data.
What is GDPR?
Common design methods used to visualise software solutions prior to coding.
What are flowcharts and structure diagrams?
A process that involves converting plain text into a scrambled format making it unreadable thus protecting it from unauthorised access.
What is encryption?
An SQL operation that combines rows from two or more tables based on a related column.
What is a database join?
Documentation that details the requirements for an application to run successfully on a specific device.
What is a technical specification document?
A type of graphic that uses mathematical equations to define shapes, allowing for scalability without loss of quality.
What is a vector graphic?
A validation method used to ensure that a required field cannot be left blank.
What is a presence check?
Aspects of code quality assessing its efficiency, suitability for the intended purpose, ability to handle unexpected data, and being understood by another programmer.
What is code evaluation, fitness for purpose, robustness, and readability?
A component of the CPU that holds data temporarily whilst it is being processed.
What is a register?
A documentation tool that provides a detailed description of entities, their attributes, and their relationships within a database.
What is a data dictionary?
Programming constructs that allow you to assign values, make decisions, concatenate strings, perform arithmetic operations and create loops.
What is assignment, selection, concatenation, arithmetic operations, fixed and conditional loops?
A translator program that will produce a list of errors upon completion, resulting in no further need for translation and a stand-alone executable file.
What is a compiler?
A database constraint that ensures foreign key values match the primary key values in related tables.
What is referential integrity?
Visiting each element in an array only once.
What is traversing a 1D array?