CA-401 INTRODUCTION TO DBMS, COMPUTER NETWORK & NUMERICAL ANALYSIS 4th Semester-
Introduction to database management system:-
ER Model
Various models of DBMS-Hierarchical, Network, Relational, File organization
Architecture of DBMS
Concept of SQL
Clientserver DBMS
Normalization (up to 3NF)
Concept of Transaction management and log based recovery.
Introduction to computer network
Network model
Layered tasks, internet model (peer-to-peer process, function of layers),OSI model.
Signal: analog & digital, transmission impairment (attenuation, distortion, noise)
Transmission media:-
Guided, unguided
Connecting device
Repeaters, hubs, bridges, two layers switch, router & three layer switches.
Internet address: classful address, classless address, subnetting.
Introduction to numerical analysis
Bisection method, Forward and backward method, Rung Kutta method etc.