Databases and SQL Flashcards

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

What is a Database?

A

A Database is a persistent store of organised data. Persistence means that the data in the database will remain there until its deleted.

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

What is a Primary Key?

A

A unique identifier for each record.

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

What is a Record?

A

Record Data for an object, person or place.

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

What is a Field?

A

Field Categories for each piece of data.

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

What is a Table?

A

A collection of records for a specific theme.

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

What is Data Redundancy?

A

Data Redundancy 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 Data inconsistency?

A

Leads on from Data Redundancy.

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

What is a relational database?

A

What is a relational database

Digital database based on the relational model of data

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

Why can data redundancy be a problem?

A

Makes the file larger than it needs to be

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

Why can data inconsistency be a problem?

A

More data there is the more likely there is an error

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

Explain the purpose of a foreign key

A

Something that links the primary key to the table.

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

Why might the primary key for one table, not be the same primary key in another table?

A

A table can only have one primary key

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