Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

A-ICT- IB- Tom > database > Flashcards

database Flashcards

database

1
Q

alternative key

A

Field by which a database is often searched.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

auditing

A

Recording database transactions made by users (e.g. all edits, reads) for security purposes.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Boolean operators

A

AND, OR, and NOT operators used in a query.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

character check

A

Ensuring a field contains only the specified character types.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

check digit

A

Way of checking mathematically if a item of data has been correctly entered.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Comma Separated Values

A

In computing, a comma-separated values (CSV) file stores tabular data (numbers and text) in plain text. Each line of the file is a data record. Each record consists of one or more fields, separated by commas. The use of the comma as a field separator is the source of the name for this file format.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

composite key

A

Primary key which consists of more than one field.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

computer matching

A

Combining several databases to build up more information about a person or set of people.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

consistency check

A

Validation check in which two fields’ values are mutually dependent.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

CSV

A

File format for transferring data, which stores fields and records in a plain text file, separated by commas. See also TSV (Tab Separated Values).

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

data entry form

A

Screen used to input data into a database.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

data integrity

A

Ensuring data is correct, consistent, and update to date.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

data matching

A

Combining several databases to build up more information about a person or set of people.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

data mining

A

Searching collections of data for hidden patterns.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Data Protection Act

A

UK law that governs the collection and use of personal data.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

data redundancy

A

Data in a database which is needlessly duplicated.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

data types

A

Format of data in a field, such as text, number, or date.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

data warehouses

A

Vast databases containing many gigabytes of data.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

Database Management System

A

Software used to create, enter, edit, and retrieve data in a database.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

DBMS

A

Software used to create, enter, edit, and retrieve data in a database.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

field

A

Single item of data about a single record in a database.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

field size

A

Validation technique. Number of characters that can be stored in a field.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

flat file database

A

Database which consists of just one table.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

foreign key

A

Database field whose sole purpose is to form part of a relationship with another table.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

forms

A

Screen used to input data into a database.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

index

A

Field by which a database is often searched.

27
Q

input mask

A

Validation technique. Ensures only the specified characters can be entered into a field.

28
Q

key field

A

Field which contains a different value for every record in that table.

29
Q

knowledge discovery

A

Searching collections of data for hidden patterns.

30
Q

length check

A

Validation technique. Number of characters that can be stored in a field.

31
Q

lookup

A

Using a list of values to limit what can be entered into a field. For example, for the ‘Gender’ field, the values are limited to ‘male’ and ‘female’

32
Q

normalization

A

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

33
Q

online encyclopaedias

A

Web site containing a large number of articles for research purposes.

34
Q

opt-in

A

System in which users must explicitly decide to participate.

35
Q

opt-out

A

System in which users must explicitly decide not to participate.

36
Q

parameter query

A

Database query whose criteria are decided by the user at run-time.

37
Q

personal data

A

Data which could identify a user, or lead to social impacts such as identity theft.

38
Q

personally identifiable data

A

Data which could identify a user, or lead to social impacts such as identity theft.

39
Q

presence check

A

Validation technique. Requires a field to be completed.

40
Q

primary key

A

Field which contains a different value for every record in that table.

41
Q

privacy policy

A

Policy governing what data a company or web site will collect about you and how it will be used.

42
Q

queries

A

Method of extracting data from a database that matches specific criteria

43
Q

range check

A

Validation technique. Ensures a field is between a certain range of values.

44
Q

RDBMS

A

Relational DBMS. See Database Management System.

45
Q

record

A

Collection of fields that represent a single entity, such as a person.

46
Q

redundancy

A

Data in a database which is needlessly duplicated.

47
Q

redundant data

A

Data in a database which is needlessly duplicated.

48
Q

relational database

A

Database containing multiple related tables and no redundant data.

49
Q

searching

A

Method of extracting data from a database that matches specific criteria

50
Q

secondary key

A

Field by which a database is often searched.

51
Q

secondary use

A

Using data for a purpose other than the one for which it was collected.

52
Q

sensitive data

A

Data such as medical records which, if shared, could cause serious negative impacts on the data subject.

53
Q

sorting

A

Ordering records based on a field (e.g. alphabetically).

54
Q

SQL

A

Language for managing databases by typing commands.

55
Q

Structured Query Language

A

Language for managing databases by typing commands.

56
Q

Tab Separated Values

A

File format for transferring data, which stores fields and records in a plain text file, with fields separated by a tab character. See also CSV.

57
Q

tab-delimited text files

A

File format for transferring data, which stores fields and records in a plain text file, with fields separated by a tab character. See also CSV.

58
Q

table

A

In databases, a collection of records representing a type of item.

59
Q

Trans-border data flow

A

Transfer of data between countries.

60
Q

TSV

A

File format for transferring data, which stores fields and records in a plain text file, with fields separated by a tab character. See also CSV.

61
Q

validation

A

Checks to ensure whether data is in the correct format.

62
Q

verification

A

Checking whether data is correct , i.e. is the value entered in a field the actual value?

63
Q

web databases

A

research this

64
Q

Personal information Managers

A

research this

A-ICT- IB- Tom (33 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions