Databases Flashcards

1
Q

Database

A

Is a collection of data that is stored in logical and organised manner.

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

Data

A

Raw facts and figures.

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

Advantages of database

A
  • the data we need can be found quickly
  • data can be filtered to retrieve only data we require
  • data can be validated
  • a backup copy can be easily made
  • saves space compared to a paper database
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Table

A

A structure in which data is stored.

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

Flat file database

A

A database whose records are stored in a single table.

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

Record

A

A collection of data about one single item in a database.

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

Field

A

One piece of data about an item in a database.

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

Data type

A

The format of the data in the field.

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