Database Terminology

Question 1

Data

Answer 1

Raw facts that represent real world things eg. 32

Question 2

Information

Answer 2

Data that’s been manipulated/transformed so it’s meaningful eg. max temp for today is 32 degrees

Question 3

Accurate

Answer 3

Free from error, correct, true

Question 4

Reliable

Answer 4

Trustworthy, dependable

Question 5

Verifiable

Answer 5

Able to be proven or checked

Question 6

Relevant

Answer 6

Closely connected or appropriate to the matter in hand

Question 7

Timely

Answer 7

Done at a proper, favourable time

Question 8

Flexible

Answer 8

Able to be adapted (changed) or varied

Question 9

Database

Answer 9

Collection of relevant/related data

Question 10

Flat file database

Answer 10

Database that stores all data in a single table with no links to any other table or file

Question 11

Field

Answer 11

A heading-category in which data is stored eg surname, date

Question 12

Record

Answer 12

Set of data about an event, person or thing, each record has the same set of fields eg firstname, surname, age, address

Question 13

Sort

Answer 13

To arrange information in a particular order

Question 14

Criteria

Answer 14

A condition used for comparison or judgement eg, sex, F

Question 15

Filter

Answer 15

To restrict/reduce a list of results based on a particular criteria

Question 16

Form

Answer 16

A user friendly interface which allows the user to view or edit the data stored, or navigate around the database

Question 17

Report

Answer 17

A summary of data stored, used for printing purposes