SLR 10 - Databases Flashcards

1
Q

Database benefits?

A

-Easier to retrieve, add, delete, update and modify data
-Easier to backup and make copies
-Can be accessed by multiple people at the same time in different locations

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

What is a Table

A

Entity/File

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

What is a Record

A

Rows/Tuples

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

What is a Field

A

Columns/Attributes

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

What is a flat file often saved as?

A

Comma-separated Value (CSV)

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

What’s the typical use of a flat file?

A

-Storing contact details
-Small product databases
-Maintaining a game or music collection

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