Coding

Question 1

Algorithm

Answer 1

Contains the logic underlying an application, without reference to a specific computer language.

Question 2

Pseudo-code

Answer 2

A streamlined set of instructions that takes account of the way computers carry out tasks.

Question 3

Variables

Answer 3

A container for storing a value. We can rapidly change the variables value.

Question 4

Conditionals

Answer 4

A structure that allows us to run a bit of code eg if / else statement

Question 5

Functions

Answer 5

A way of grouping different tasks together

Question 6

Loops

Answer 6

A way of making a computer repeat a process several times until a condition has been met

Question 7

Temporary data

Answer 7

Data that is discarded when the program finishes

Question 8

Persistent data

Answer 8

Data is saved permanently eg databases

Question 9

Database

Answer 9

Shared collection of logically related data

Question 10

DBMS

Answer 10

Database Management System - a system for providing efficient, convenient storage and access to data

Question 11

Entity

Answer 11

Something like a specific student name or lecturer

Question 12

Entity type

Answer 12

category of entity eg students

Question 13

Attribute in a table

Answer 13

a piece of data giving information about an entity

Question 14

Record in a table

Answer 14

a row in a table

Question 15

Primary keys

Answer 15

a piece of data that uniquely identifies a record

Question 16

Foreign keys

Answer 16

Existing primary keys that are used in another table as an attribute

Question 17

one to many relationships

Answer 17

for one entity type, there are many of the other entity types

Question 18

Many to many relationships

Answer 18

for many entity types there are many entity types