1.3, 1.4, 1.5 Flashcards
When is a table in First Normal Form (1nf)?
A table is in First Normal Form if it contains no repeating attributes or groups of attributes.
When is a table in Second Normal Form (2nf)?
A table is in Second Normal Form if it is in first normal form and has no partial dependencies.
When is a table in Third Normal Form (3nf)?
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.
What is a LAN?
Local Area Network – A network spread over a small geographical area. Doesn’t use third party hardware.
What is a WAN?
Wide Area Network – A network spread over a large geographical area. Tends to be made up of multiple LANs. Uses third party hardware.
What is a NIC?
Network interface card that converts the data produced by a computer into a format that can travel along a network connection.
What is a Hub?
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.
What is a switch?
A Switch is a high-speed device that receives incoming data packets and redirects them to their destination on a local area network.
What is a router?
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.
What is a Wireless Access Point?
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.
What is serial transmission?
One bit is sent at a time.
What is parallel transmission?
All bits are sent at once.
What is simplex transmission?
Data can only travel in one direction.
What is duplex transmission?
Data can travel in both directions at the same time.
What is half-duplex transmission?
Data can travel in both directions but not at the same time.