Topic 3 - Data Flashcards

(62 cards)

1
Q

What is Binary?

A

A Base-2 numbering system. (only has 2 digits - 0 and 1)

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

What is Denary?

A

A Base-10 numbering system (from 0 - 9)

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

What is a nibble (in bits)?

A

4 bits.

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

When there is an extra digit in a binary calculation, what is this called?

A

Overflow.

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

What does ‘1’ represent in Sign and Magnitude?

A

Negative

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

What does ‘0’ represent in Sign and Magnitude?

A

Positive

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

What is a Hexadecimal?

A

A Base-16 numbering system (16 digits. It shares 0-9 with denary then uses letters A-F)

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

Why are Hexadecimals used?

A

They simplify long streams of bits

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

What are Real Numbers?

A

Numbers with an integer part and a fractional part.

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

What is the scientific notation of representing floating point binary?

A

Mantissa x Base^Exponent

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

What is the name of the subset that ASCII is in?

A

Unicode

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

Why is Unicode better than ASCII?

A

It can represent a wider range of characters (e.g. from other languages such as: é)

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

What is a Bitmap?

A

An image stored as an array of individual pixels.

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

What is a Pixel?

A

An individual picture element.

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

What is Colour Depth?

A

The number of bits allocated to represent each colour

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

What is ‘Resolution’ of an image?

A

The detail it holds within an image.

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

How can ‘Resolution’ be displayed as?

A

width x height OR the number of ‘Pixels Per Inch (PPI) ‘

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

What are Analogue Signals?

A

They’re continuous, they don’t have defined ranges, and are represented often by waves.

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

What are Digital Signals?

A

They form discrete values (they fall within a defined range and can only take certain values).

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

What are three everyday examples of Analogue Signals?

A

Sound, temperature and light intesity

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

What is Sampling?

A

The process of recording an analogue signal at regular intervals.

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

What is ‘Sampling Frequency’ ?

A

The average number of samples obtained per second. Measured in Hertz (Hz)

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

What is Quantisation?

A

The process of approximating the analogue values to predetermined discrete levels.

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

What is a bit?

A

1 or 0

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
What is a byte?
8 bits / 2 nibbles
26
What is a Kilobyte (in bytes) ?
1024 bytes (2^10 bytes)
27
What is a Megabyte in KB?
1024 KB (2^20 bytes)
28
What is a Gigabyte in MB?
1024 MB (2^30 bytes)
29
What is a Terabyte in GB?
1024 GB (2^40 bytes)
30
What is the formula of Transfer Rate?
Transfer rate = b/s
31
What is data compression?
The reduction of file size whilst retaining the underlying information.
32
What is Lossy Compression?
Some of the original data is lost
33
What are two examples of lossy algorithms?
MP3 (audio) and JPEG (images)
34
What is Lossless Compression?
Compresses the data without losing any data
35
What is an example of Lossless Compression?
Run-length encoding (RLE)
36
How does RLE work?
It collects all the like terms together (e.g. y y y = 3y)
37
What is encryption?
The process of making data secret to that only authorized viewers can decrypt and read the data, and third parties cannot.
38
What are the 5 steps of encryption?
1. Message written in plaintext 2. Message is encrypted into ciphertext 3. Message is sent 4. Message is received 5. Message is decrypted back into plaintext
39
Why is encryption used (2 reasons) ?
1. To protect data | 2. To verify the sender
40
How does a Caesar Cipher algorithm work?
Letters in the alphabet are shifted depending on the shift key
41
What are the two arrangements of data?
Structured and unstructured
42
What are the differences between structured and unstructured data?
Structured - arranged in an organised and defined way. | Unstructured - cannot be easily mapped by a computer in predefined fields.
43
What is a Database?
A collection of information that is organised so that it can be easily accessed, managed and updated.
44
What is a Relational database?
Consists of tables linked together with each other by key fields.
45
What is a table?
A two-dimensional representation of data that is stored in rows and columns.
46
What is a Field?
Single piece of data about an entity
47
What is a Record?
The group of fields about a specific entity (a row)
48
What is a Report?
A presentation of data from the database
49
What are Queries?
Requests of data stored in the database
50
What is an Entity?
An object/person/thing about which data is stored.
51
What is an Entity Relationship?
A model used to identify entities and how they relate when designing a database.
52
What is a relationship?
Link between entities.
53
What is a primary key?
A field that uniquely identifies a record.
54
What is a Composite Key?
A combination of fields in a table used to uniquely identify a record.
55
What is a Foreign Key?
A field in one table that is a primary key in another table.
56
What is Structured Query Language (SQL) ?
A specialised programming language for creating database structures and managing data in them.
57
What does INSERT do?
Enters a record into the table and stores the value in the specified column.
58
How does INSERT work?
INSERT INTO TableName (Field1, Field2...) | VALUES ("abc123", "abc123")
59
How do you create a table?
CREATE TABLE TableName | ColumnName datatype, ...
60
How do you UPDATE something?
UPDATE TableName SET (ColumnName = Value, ...) WHERE ;
61
How do you DELETE something?
DELETE * FROM TableName; (deletes everything) DELETE FROM Student WHERE Student
62
How do you SELECT something?
SELECT (ColumnName) FROM TableName [WHERE ] [ORDER BY (ColumnName,...)];