databases Flashcards

1
Q

What is a database?

A

A database is an organised way to store data so that it can easily be retrieved using queries.

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

What is a record?

A

It is a set of information about something.

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

What is a field?

A

It is an item of data in a record?

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

what is a flat file database?

A

A flat file data base stores a single table of data.

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

What is a primary key?

A

It is a field which stores unique data for each record in a table.

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

What is data redundancy?

A

It is where data is repeated in a database table.

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

What is a relational database?

A

A relational database contains multiple tables.

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

What is a foreign key?

A

It is a field in a table which references the primary key of another table.

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