Databases

Question 1

Record

Answer 1

Row/Collection of fields that relate to the same item

Question 2

Primary Key

Answer 2

Field that is unique for every record

Key field

Question 3

Key field

Answer 3

Field which is unique for every record

Primary key

Question 4

Composite key

Answer 4

Primary key consisting of two or more fields
One field can not be used for identification
But when combined

Question 6

Data Type

Answer 6

Determines the sort of data that can be stored

Question 7

Database

Answer 7

Organized collections of related data stored in organized manner

Question 8

Business data (example)

Answer 8

Costumer information
Product data
Supplier details

Question 9

Transport Data (Examples)

Answer 9

Flight Info

Train Info

Question 10

Search Engine (Example)

Answer 10

Google, Yahoo

Question 11

Social Networks (Example)

Answer 11

Facebook, LinkedIN

Question 12

Online Databases (Example)

Answer 12

Wikipedia

Question 13

Government Databases (Examples)

Answer 13

Criminal Record

Tax record

Question 14

Privacy (Definition)

Answer 14

Ability of individuals to be able to determine for themselves when, how and to what extent information about themselves is shared with others

Question 15

Data Integrity (Definition)

Answer 15

Safeguarding accuracy and completeness of stored data

Question 16

Validation

Answer 16

To only allow data of the described data type

Question 17

Secondary key

Answer 17

Not unique but for search tasks/ field by which a database is often searched
Index/Alternative key

Question 18

Index

Answer 18

not unique but for search tasks/ field by which a database is often searched
Secondary key/alternative key

Question 19

DBMS

Answer 19

Database Management System

Question 20

RDBMS

Answer 20

Relational Database Management System

Question 21

Difference Spreadsheetsoftware/Database

Answer 21

Spreadsheet: processing and calculation of numerical data
Database: organizing and storing large amounts of data

Question 22

Foreign key

Answer 22

Field whose sole purpose is to form part of a relationship with another table

Question 23

Alternative key

Answer 23

not unique but for search tasks/ field by which a database is often searched
Secondary key/Index

Question 24

Data redundancy

Answer 24

Data which is needlessly dublicated

Question 25

Flat File Database

Answer 25

Database which consists of one table

Question 26

Relational Database

Answer 26

Database containing multiple related tables and no redundant data

Question 27

Boolean Operators

Answer 27

AND, OR, and NOT operator used in a query

Question 29

Structured Query

Answer 29

language for managing databases by typing commands

Question 31

Form

Answer 31

screen used to input into a datbase

Question 33

Comma Separated Values (CSV)

Answer 33

File format for transferring data, which stores fields and records in a plain text file, separated by commas

Question 34

Data warehouse

Answer 34

vast databases containing many gigabytes of data

Question 35

Data types (examples)

Answer 35

Short text, long text, number, date

Question 36

Data Matching

Answer 36

Combining several databases to build up more information about a person or group

Question 37

Data Mining

Answer 37

Searching collections of data for hidden patterns

Question 38

Data Protection Act

Answer 38

UK law that governs the collection and use of personal data

Question 39

Consistency Check

Answer 39

Validation check in which two fields’ values are mutually dependent

Question 40

Difference Validation/Verification

Answer 40

Validation: Checks to ensure data is in the correct format
Verification: Checks to ensure data is correct

Question 41

Normalization

Answer 41

Process of converting a database from a flat file to a relational database

Question 42

Field

Answer 42

smallest piece of information in a database

Question 43

Query

Answer 43

method of extracting data from a database that matches specific criteria

Question 65

Table

Answer 65

Collection of records