This topic explores the mechanisms and protocols used for exchanging data between different computer systems. It covers the technical aspects of data compr
Topic Synopsis
This topic explores the mechanisms and protocols used for exchanging data between different computer systems. It covers the technical aspects of data compression, encryption, database management, network architecture, and web technologies.
Key Concepts & Core Principles
- Serial vs. parallel transmission: Serial sends one bit at a time over a single wire (e.g., USB), while parallel sends multiple bits simultaneously over multiple wires (e.g., older printer cables). Serial is better for long distances due to less interference.
- Synchronous vs. asynchronous transmission: Synchronous uses a shared clock to synchronise sender and receiver, allowing continuous data flow; asynchronous uses start and stop bits to frame each byte, making it simpler but less efficient.
- Protocols and the TCP/IP stack: Protocols are sets of rules for communication. The TCP/IP stack has four layers (application, transport, internet, link) that handle data encapsulation, addressing, and reliable delivery.
- Error detection methods: Parity bits, checksums, and cyclic redundancy checks (CRC) are used to detect errors during transmission. For example, a parity bit checks if the number of 1s is even or odd.
- Network topologies: Star, bus, ring, and mesh topologies each have advantages and disadvantages in terms of cost, performance, and fault tolerance. Star is common in modern LANs due to its centralised management.
Exam Tips & Revision Strategies
- Be prepared to interpret and write SQL queries using SELECT, FROM, WHERE, JOIN, and wildcards
- Ensure you can explain the benefits and drawbacks of lossy vs lossless compression in specific scenarios
- Practice drawing or interpreting entity relationship diagrams
- Understand how the PageRank algorithm influences search engine results
- Be ready to explain the ACID properties in the context of transaction processing
Common Misconceptions & Mistakes to Avoid
- Confusing symmetric and asymmetric encryption processes
- Failing to correctly identify primary and foreign keys in database design
- Incorrectly applying 3NF normalisation rules
- Misunderstanding the role of specific layers in the TCP/IP stack
- Confusing client-side and server-side processing roles
Examiner Marking Points
- Distinction between lossy and lossless compression
- Application of run length encoding and dictionary coding
- Understanding of symmetric and asymmetric encryption
- Relational database concepts including keys, normalisation to 3NF, and referential integrity
- Interpretation and modification of SQL queries
- Transaction processing concepts (ACID, record locking, redundancy)
- TCP/IP stack, DNS, and protocol layering
- Packet vs circuit switching