1.3.2 Databases Flashcards

You may prefer our related Brainscape-certified flashcards:
1
Q

What is a relational database?

A

A database which recognises the difference between entities and uses different tables for each entity.

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

What is an entity?

A

An item of interest about which information is stored.

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

What is a flat file?

A

A database that consists of a single file, usually about one entity.

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

What is a primary key?

A

A unique identifier for each record in a table.

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

What is a foreign key?

A

The attribute which links two tables together.

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

What is a secondary key?

A

An index other than the primary key used to search and sort through the database with more convenience and speed.

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

What does capturing data mean?

A

The process of getting the information that will be stored in the database.

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

What method do banks use to capture data from cheques?

A

Magnetic Ink Character Recognition (MICR) is used for all of the details apart from the amount which must be entered manually.

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

What does selecting data mean?

A

Selecting data is the process of removing excess information to extract only the data you require.

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

What does managing the data mean?

A

To manipulate the information collected in any type of way such as sorting through it or selecting certain parts using SQL.

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

What is the most common language used to manipulate data in databases?

A

SQL (Structured Query Language).

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