Skip to main content
grasp.study
About
Explore
Pricing
Log in
Try it for free
Back to course
👋
Welcome to a Grasp lesson
Create a free account
to keep studying and create your own study path.
GATE CS 2026 Mastery Course
·
Module 12
Databases and Computer Networks
ER Diagrams to Relational Schemas
Model data requirements using Entity-Relationship (ER) diagrams and translate them into relational database schemas.
2
Advanced Queries: Relational Algebra & SQL Mastery
Formulate complex queries using Relational Algebra and advanced SQL, including joins, subqueries, and aggregation.
3
Relational Schema Normalization (3NF & BCNF)
Normalize relational schemas to 3NF and BCNF using functional dependencies and Armstrong's axioms.
4
Concurrency Control: Conflict Serializability and Locking Protocols
Analyze transaction schedules for conflict serializability using precedence graphs and apply lock-based concurrency control protocols.
5
Data Link Layer Protocols: Flow and Medium Access Control
Analyze Data Link Layer protocols for flow control (Stop-and-Wait, GBN, SR) and medium access control (CSMA/CD).
6
IP Addressing, Subnetting, and Routing Algorithms
Calculate subnet masks and IP address ranges for given requirements and trace routing using Distance Vector and Link State algorithms.
7
Core Network Protocols Explained
Describe the function of core network protocols like TCP, UDP, ARP, and ICMP, including the TCP 3-way handshake.
8
TCP Congestion Control & Application Protocols
Analyze TCP's congestion control mechanisms (AIMD, slow start) and the operation of application layer protocols like DNS and HTTP.
End of course,
Back to course
Previous module
Operating Systems
Next module