1.3, 1.4, 1.5 Flashcards

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

When is a table in First Normal Form (1nf)?

A

A table is in First Normal Form if it contains no repeating attributes or groups of attributes.

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

When is a table in Second Normal Form (2nf)?

A

A table is in Second Normal Form if it is in first normal form and has no partial dependencies.

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

When is a table in Third Normal Form (3nf)?

A

A table is in Third Normal Form if it is in second normal form and contains no non-key dependencies.
A non key dependency is when the attribute depends on the value of the primary key and nothing else.

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

What is a LAN?

A

Local Area Network – A network spread over a small geographical area. Doesn’t use third party hardware.

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

What is a WAN?

A

Wide Area Network – A network spread over a large geographical area. Tends to be made up of multiple LANs. Uses third party hardware.

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

What is a NIC?

A

Network interface card that converts the data produced by a computer into a format that can travel along a network connection.

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

What is a Hub?

A

It is the most basic networking device that connects multiple computers or other network devices together. Unlike a network switch or router, a network hub has no routing tables or intelligence on where to send information and broadcasts all network data across each connection.

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

What is a switch?

A

A Switch is a high-speed device that receives incoming data packets and redirects them to their destination on a local area network.

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

What is a router?

A

A router is a networking device that forwards data packets between computer networks. A packet is typically forwarded from one router to another router through the networks that constitute an internetwork (e.g. the Internet) until it reaches its destination node.

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

What is a Wireless Access Point?

A

A WAP is a hardware device or configured node on a LAN that allows wireless capable devices and wired networks to connect through a wireless standard, including Wi-Fi or Bluetooth.

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

What is serial transmission?

A

One bit is sent at a time.

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

What is parallel transmission?

A

All bits are sent at once.

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

What is simplex transmission?

A

Data can only travel in one direction.

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

What is duplex transmission?

A

Data can travel in both directions at the same time.

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

What is half-duplex transmission?

A

Data can travel in both directions but not at the same time.

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

What is bit rate?

A

The number of bits that can be transferred in a given period of time. It is measured in units called ‘baud’. Baud rate is the number of bits per second.

17
Q

What is The Data Protection Act 1998?

A

This law applies to information stored both on computers and in organised paper filing systems. The law covers personal data, which is any data which can be used to identify a living person.

18
Q

What is The Computer Misuse Act 1990?

A

Concerns the malicious use of computers.
Three primary offences:
Unauthorised access to computer materials.
Unauthorised access with intent to commit further offences.
Unauthorised modification of computer material.

19
Q

What is The Copyright, Design and Patents Act 1988?

A

This act was brought in to protect people’s property online. The Act was extended to include computer programs as a type of literary work, meaning that copyright automatically applies to code.

20
Q

What is The Regulation of Investigatory Powers Act 2000?

A

It covers investigation, surveillance and interception of communication by public bodies. Governments can legally look at online conversations in the interests of national security if they have a warrant.

21
Q

What is TCP/IP?

A

A suite of protocols that governs data transmission on the internet

22
Q

What is HTTP?

A

Governs data transmission between a client and web server

23
Q

What is HTTPS?

A

Governs data transmission between a client and web server in a secure manner, by encrypting the data

24
Q

What is FTP?

A

Governs the transfer of files, such as documents, images, or audio, across a network

25
Q

What is POP?

A

Governs the retrieving of emails from the email server, deleting the remote copy of the email once it has downloaded locally to your computer

26
Q

What is IMAP?

A

Governs the retrieving of emails from an email server, leaving the email on the remote server

27
Q

What is SMTP?

A

Governs the sending of emails to an email server