SLR10 Flashcards

1
Q

What is a database

A

An organised collection of data

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

What does a database need to be able to do

A

Add data
Modify data
Delete data
Find data

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

Where were databases stored before the developments of technology

A

Physical paper format in filing cabinets

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

What did technology do to make the functionality of databases better

A

Made it easier to retrieve data, back up data, access data and modify data

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

How is a flat file data base stored

A

In a table

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

What are the names of the columns and rows in a flat file database

A

Fields and records

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

What are the benefits of a flat file database (3)

A
  1. They are really easy to set up
  2. They are really simple
  3. They require little maintenance
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What are the losses of a flat file database (3)

A
  1. Can become inefficient quickly due to repeated data
  2. Making them slow
  3. Using up unnecessary space
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What are the benefits of a flat file database compared to relational database

A
  1. Simple to manage
  2. Great for a small database
  3. In expensive
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What are the drawbacks of a flat file database compared to relational database (2)

A
  1. Takes up a lot of unnecessary spade on the computer
  2. Increased data redundancy
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What are the benefits of a relational database compared to flat file database (2)

A
  1. More data efficient
  2. Much better for expansion
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What are the drawbacks of a relational database compared to flat file database (2)

A
  1. Very time consuming to set up
  2. Much more expensive to set up
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What is a relational database

A

A database that has been split over multiple tables

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

What are the three different ways relational databases can be linked

A
  1. One to One
  2. One to Many
  3. Many to Many
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

When linking relational databases which is considered to be the worst

A

Many to Many

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

What is the most important thing in making a relational database effective

A

You are able to find things quickly

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

What is a primary key in a relational database

A

An item of data that keeps record in every table unique in some way

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

How can secondary index be made in relational databases

A

From a piece of data (field) this will be used as the search key

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

When working in a database what are the 4 ways of handling data

A
  1. Capturing
  2. Selecting
  3. Managing
  4. Exchanging
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

In a database what is the process of capturing

A

Getting the data into the database

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

In a database what is the process of selecting

A

Being able to query or search for the data

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

In a database what is the process of managing

A

This is the action of manipulating the data (add, edit and delete)

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

In a database what is the process of exchanging

A

Moving the data from one device to another

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

What effect will data being in a paper format have on the data itself

A

The data has to be imputed into a computer, to avoid human error and save time Data Capture Forms allow a computer to scan the data off of a paper without anyone having to input any information into the computer

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

What are the 2 different types of Data Capture Form

A

OCR (Optical Character Recognition)
OMR (Optical Mark Recognition)

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

What is Optical Character Recognition

A

A process that reads text by interpreting the shapes of the letters (works much better with printed text over handwritten as each letter is exactly the same whereas everyone’s handwriting is different)

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

Give an example of Optical Character Recognition

A

Speed cameras

28
Q

What is Optical Mark Recognition

A

Reads markings then converts this into the correct data and files it

29
Q

Give an example of Optical Mark Recognition

A

Multiple choice questions

30
Q

Name the 5 manual methods of exchanging data

A
  1. Memory sticks
  2. Email
  3. Paper based
  4. Optical media
  5. Removable hard disk
31
Q

How do databases exchange data automatically

A

Through an interface that deals with both databases known as an EDI (Electronic Data interchange) which takes data and sends it to a set destination

32
Q

What is XML and JSON

A

XML = Extensible Markup Language
JSON = JavaScript Object Notation
These are both open formats for structuring data but JSON is hardly used as XML has mostly replaced it. Both used for transporting data

33
Q

What is CSV

A

Comma-Separated Values
The structure of the database is known as it will always be the same due to each record being stored on a separate line and each field being separated by a comma. This make is it easy to extract data from a CSV file

34
Q

What is normalisation

A

When a database is created with everytime a record or field is added there is a high chance of repetition this can lead to large amounts of unnecessary space being taken up. This can be fixed by rearranging the data this is known as the three normal forms (normalisation)

35
Q

How do we get to the first normal form

A

All basic databases start at 0NF this is also known as a flat file database to turn this into a 1NF database we must
1. Make sure all fields are unique
2. The values in the fields should be from the same domain
3. Fields in values all need to be atomic (only one in each)
4. No two records can be identical
5. Each table needs a primary key

36
Q

How do we get to second normal form

A
  1. First we need to make sure that the database is in 1NF
  2. Then remove all partial dependency’s (a partial dependency is when one or more of the fields depends on only one part of the primary key)
37
Q

How do we get to the third normal form

A
  1. Make sure the database is in 2NF
  2. Remove any transitive dependencies
  3. Remove any none key dependencies
  4. Each key must only have one purpose
38
Q

Can a database in 3NF be denormalized

A

Yes if normalised correctly

39
Q

What happens when you use indexing in a database that has been normalised

A

Sacrifices a small amount of space to maintain the index data structure

40
Q

What does SQL stand for

A

Structured Query Language

41
Q

What it SQLs purpose

A

Fast / efficient retrieval, deletion and manipulation of data held in rational databases

42
Q

What commands are used in SQL (10)

A
  1. SELECT
  2. OR
  3. FROM
  4. DELETE
  5. WHERE
  6. INSERT
  7. LIKE
  8. DROP
  9. AND
  10. JOIN
43
Q

In SQL what does the SELECT command do

A

Allows you to select which field in a table you are referring to

44
Q

In SQL what does the OR command do

A

Allows you to combine two statements into one in your WHERE broadening your field of search;
G% OR H% means any record beginning with “G” or “H”

45
Q

In SQL what does the FROM command do

A

Allows you to select which table you are referring to

46
Q

In SQL what does the DELETE command do

A

Also known as DELETE FROM. Allows you too delete a full record from a table

47
Q

In SQL what does the WHERE command do

A

Allows you to select which record in a table you are referring to

48
Q

In SQL what does the INSERT command do

A

Also known as INSERT INTO. Allows you to add / create an entirely new record into a table

49
Q

In SQL what does the LIKE command do

A

Allows you to narrow your field of search in WHERE whilst not just choosing one record

50
Q

In SQL what does the DROP command do

A

Also known as DROP TABLE which means the process of deleting an entire table

51
Q

In SQL what does the AND command do

A

Allows you to add another statement to your WHERE further narrowing your field of search

52
Q

In SQL what does the JOIN command do

A

Allows you to join two tables into one

53
Q

How is information stored in a database

A

In records

54
Q

How does SQL differ from a procedural language

A

SQL describes what needs to be achieved. A procedural language describes how something should be achieved.

55
Q

What is SQL used for

A

Database creation and manipulation

56
Q

What is transaction processing

A

Any information processing that is divided into individual, indivisible operations

57
Q

In transaction processing can a transaction be partially complete

A

No
All transactions must either be fully completed or completely fail

58
Q

What does CRUD stand for and what does it link up with in SQL

A

Create = INSERT / CREATE
Read = SELECT
Update = UPDATE
Delete = DELETE

59
Q

What set of rules does the DBMS (Database Management System) follow

60
Q

What does ACID stand for

A

Atomicity
Consistency
Isolation
Durability

61
Q

What does Atomicity mean (ACID) (2)

A
  1. A change to a database must be either completely performed or not at all.
  2. It is known as Atomicity from its derivative word atom meaning it cannot be halved
62
Q

What does consistency mean (ACID) (2)

A
  1. Referential integrity is where any change in the database must retain the overall state of the database
  2. A good example of consistency is moving money from one bank account into another. The money that has left the first account must equal the money that will be paid into the second account
63
Q

What does isolation mean (ACID) (3)

A
  1. One transaction cannot be interrupted by another transaction
  2. A database management system enforces isolation by implementing a system of record locking
  3. The lock is only removed once the transaction is complete
64
Q

What is record locking

A

When records in a transactions are placed in a read-only state

65
Q

What does durability mean (ACID) (2)

A
  1. Once a change has been made to a database it must not be lost due to system failure
  2. To make sure all data is safe it is kept in a non-volatile storage