1.3.1 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. It uses unique keys to differentiate between the data.

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

What is an entity?

(in terms of a database)

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 consisting of a single table storing data on many entities

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 that links two tables

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 infromation collected in any type of way such as through sorting through it 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
12
Q

What is a use of a Flat File?

A

Used for spreadsheets or databases without integrated indexes

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