Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Computer Science > SLR 10 - Databases > Flashcards

SLR 10 - Databases Flashcards

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

What does organising data allow for?

A

Adding
Modification
Deleting
Searching

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

What are the benfits of e-databases?

A

It’s easier to handle the data
Easier to backup and make copies
It can be accessed by multiple individuals

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

What is the term for a table?

A

Entity / File

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

What is the term for rows?

A

Records / Tuple

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

What is the term for columns?

A

Fields / Attributes

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

What is a flat file database?

A

It contains a single table
It is often saved as a CSV

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

When are flat files used?

A

For contact details
A small product database
Maintaining a collection

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

What are the problems of flat files?

A

Inefficient due to repetition
Takes up a large amount of storage
Slow to query
Difficult to maintain

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

What is the term for information split into several tables?

A

A relational database

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

What are the types of relationships?

A

1:1
1:M
M:M

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

What is the process of capturing data?

A

How to get data into the database

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

What is selecting data?

A

How to query the data and retrieve data

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

What is managing data?

A

How to manage, manipulate, add, edit & delete data

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

What is exchanging data?

A

How to exchange data with other people and systems

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

What are the methods of capture?

A

Paper-based data capture
OCR - Optical Character Recognition
OMR - Optical Mark Recognition

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

What is paper based capture?

A

The use of tickboxes to manually input data into a system

17
Q

What is the problem of paper based capture?

A

They’re slow and prone to errors
Every part must be labelled
Must be completed in black pen

18
Q

What is OCR?

A

It reads text by interpreting the shape of letters

19
Q

When is OCR often used?

A

For post offices or Road Cameras

20
Q

What is OMR?

A

Used for multiple choice tests
It is fast and reduces human error

21
Q

What is used for data retrieval?

A

SQL - Structured Query Language
QBE - Query by Example

22
Q

What are the methods of data management?

A

DML - Database Manipulation Language
DBMS - Database management System

23
Q

What are common methods of electronic data exchange?

A

XML, JSON and CSV
The EDI (Electronic Data interface)

24
Q

What are common methods of manual data exchange?

A

Memory Stick, Optical, HDD, Email or paper

25
Q

How does the EDI work?

A

2 Databuses interfacing to read & write directly from each other
Errors get replicated across systems

Computer Science (11 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions