1.3.2 Databases Flashcards

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

What is a database?

A
  • An organised collection of data
  • Allows for easy adding, modification, deletion and searching
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Benefits of using electronic databases

A
  • Easier to retrieve, add. delete, update and modify data
  • Easier to back up and make copies of the data
  • Can be accessed by multiple people at the same time + from different locations
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is a flat file?

A
  • Consists only a single table, can be created easily using either database/spreadsheet software
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What are the advantages of a flat file?

A
  • Very simple + quick to set up
  • Require little expertise to maintain
  • Suitable for storing small amounts of data
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Typical uses of flat files

A
  • Storing contact details
  • Small product database
  • Maintaining a game/music collection
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Disadvantage of flat files

A

Can be inefficient as they include a lot of repetitive data which takes up space

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

If only flat file databases were used, they would quickly…

A
  • Take up unnecessary space
  • Be slow to query
  • Become difficult to maintain
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What is a relational database?

A

A database which recognises the difference between entities + uses different tables for each entity

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

What is an entity?

A

An item of interest about which information is stored

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

What is a primary key?

A

A unique identifier (field) for each record in a table

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

What is a foreign key?

A

Attribute which relationally links two tables together

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

What is a secondary key?

A

An index other than a primary key used to search and sort through the database with more convenience and speed

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

What does capturing data mean?

A

The process of getting the information that will be stored in the database

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

Different methods of capturing data

A
  • Paper based forms
  • Optical character recognition
  • Optical mark recognition
  • Automated ways e.g. QR codes and barcodes
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What methods do banks use to capture data from cheques?

A
  • Magnetic Ink Character Recognition
  • Used for all the details apart from the amount which must be entered manually
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

Paper based forms

A

Data input is manual + involves human reading the form + typing the info into a computer based system

17
Q

How are errors reduced when inputting the data from a paper based form?

A
  • Form clearly labelled
  • Complete in black pen and capital letters
  • Use of tick boxes
  • Squares for entering each letter separately
18
Q

Optical Character Recognition

A
  • Automatically reads text by interpreting the shape of the letter // works best w/ printed text than hand written text
19
Q

Optical Character Recognition examples

A
  • Post Office uses OCR software to read postcodes and route mail
  • Road cameras use automatic number plate recognition software to handle congestion charging + identify drivers who are speeding