NTRCA college written syllabus

E:\NTRCA\Exam\17th Exam'20\Written\Syllabus\Written_College level_17th Exam-2020 (1-52 code) (Main).doc    84 
environment; Data Modeling: the Entity-Relationship Diagram and its symbols and constructs; The 
Relational Model and Normalization: relational model, normalization, transformation of an entityrelationship 
data diagram into a relational model; SQL - A Standard Navigation Language for Relational 
Databases; Overview of Object-Oriented Databases: object-oriented data model, implementation of 
object persistence using relational databases. Indexing and Hashing: Basic Concepts, Ordered Indices, 
B+-Tree Index Files, B-Tree Index Files, Static Hashing, Dynamic Hashing, Comparison of Ordered 
Indexing and Hashing; Query Processing: Overview, Measures of Query Cost, Selection Operation, 
Sorting, Join Operation, Evaluation of Expressions; Query Optimization: Introduction, Transformation 
of Relational Expressions, Catalog Information for Cost Estimation, Statistical Information for Cost 
Estimation, Cost-based optimization; Transactions: Transaction Concept, Transaction State, Concurrent 
Executions, Serializability; Concurrency Control: Lock-Based Protocols, Timestamp-Based Protocols; 
Recovery System: Failure Classification, Storage Structure, Recovery and Atomicity, Log-Based 
Recovery, Recovery With Concurrent Transactions; Data Analysis and Mining: Data Mining, Decision 
tree, Bayes theory, Randomize tree; Database System Architectures: Centralized and Client-Server 
Systems, Server System Architectures, Parallel Systems, Distributed Systems, Network Types; Parallel 
Databases: Introduction, I/O Parallelism, Interquery Parallelism, Intraquery Parallelism, Intraoperation 
Parallelism, Interoperation Parallelism; Distributed Databases: Heterogeneous and Homogeneous 
Databases: Distributed Data Storage, Distributed Transactions, Commit Protocols; Additional should 
be included: Database Design, Database Tuning Security and Authorization, Multidimensional query. 
 
Data Communications and Networking (Answer 01x10=10): Introduction: Overview of the 
Internet, Overview of Networking Protocols, Network Edge, Network Core, Protocol Layers / Service 
Model, General Networking Example; Application Layer: Principles of Networking Applications, Web 
and HTTP, FTP, E-mail, DNS; Transport Layer: Transport Layer Services, Multiplexing and De 
multiplexing, Connectionless Transport: UDP, Principles of Reliable Data Transport, Connection- 
Oriented Transport: TCP, Principles of Congestion Control, TCP Congestion Control; Network Layer: 
Datagram Networks, Inside a Router, Details of the Internet Protocol (IP), IP Sub netting, Routing 
Algorithms (Link State, Distance Vector), Routing in the Internet (Routing Information Protocol (RIP), 
Open Shortest Path First (OSPF), Border Gateway Protocol (BGP)).