Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

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
forms
Screen used to input data into a database.
26
index
Field by which a database is often searched.
27
input mask
Validation technique. Ensures only the specified characters can be entered into a field.
28
key field
Field which contains a different value for every record in that table.
29
knowledge discovery
Searching collections of data for hidden patterns.
30
length check
Validation technique. Number of characters that can be stored in a field.
31
lookup
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
normalization
Process of converting a database from a flat file database to a relational database.
33
online encyclopaedias
Web site containing a large number of articles for research purposes.
34
opt-in
System in which users must explicitly decide to participate.
35
opt-out
System in which users must explicitly decide not to participate.
36
parameter query
Database query whose criteria are decided by the user at run-time.
37
personal data
Data which could identify a user, or lead to social impacts such as identity theft.
38
personally identifiable data
Data which could identify a user, or lead to social impacts such as identity theft.
39
presence check
Validation technique. Requires a field to be completed.
40
primary key
Field which contains a different value for every record in that table.
41
privacy policy
Policy governing what data a company or web site will collect about you and how it will be used.
42
queries
Method of extracting data from a database that matches specific criteria
43
range check
Validation technique. Ensures a field is between a certain range of values.
44
RDBMS
Relational DBMS. See Database Management System.
45
record
Collection of fields that represent a single entity, such as a person.
46
redundancy
Data in a database which is needlessly duplicated.
47
redundant data
Data in a database which is needlessly duplicated.
48
relational database
Database containing multiple related tables and no redundant data.
49
searching
Method of extracting data from a database that matches specific criteria
50
secondary key
Field by which a database is often searched.
51
secondary use
Using data for a purpose other than the one for which it was collected.
52
sensitive data
Data such as medical records which, if shared, could cause serious negative impacts on the data subject.
53
sorting
Ordering records based on a field (e.g. alphabetically).
54
SQL
Language for managing databases by typing commands.
55
Structured Query Language
Language for managing databases by typing commands.
56
Tab Separated Values
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
tab-delimited text files
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
table
In databases, a collection of records representing a type of item.
59
Trans-border data flow
Transfer of data between countries.
60
TSV
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
validation
Checks to ensure whether data is in the correct format.
62
verification
Checking whether data is correct , i.e. is the value entered in a field the actual value?
63
web databases
research this
64
Personal information Managers
research this

A-ICT- IB- Tom (33 decks)

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