Database- Concepts Summary Flashcards

1
Q

Database

A

Collection of data items. Structured to allow easy access for a number of different application programs.

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

Table

A

Each group of similar data with rows and columns.

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

Record

A

Collection of data items, relating to the individuals that the record describes.

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

Field

A

Part of a record designed to hold a single data item

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

Primary key/ Key field

A

A field that uniquely identifies an individual record in a table

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

Query

A

A question used to receive selected information

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

Report

A

Presentation of selected data

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

Macro

A

Small program to preform a repetitive task

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

Relationship

A

A link between to tables in a database

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