Data Communication and Networking Standards Refernce Books

Books:
Behrouz A Forouzan, “Data communications and Networking”, Fourth Edition , Mc-Graw
Hill
Achyut Godbole, “Data communications and Networks, TMH
Dr.Sidnie Feit, “TCP/IP” ,Second Edition, TMH
Reference:
W.Stallings,”Data and Computer Communications”,Eight Edition,Pearson Education

Data Communication and Networking Standards Sem 2

Introduction to data communications and networking Introduction, Fundamental concepts, Data communications, Protocol, standards, standard organizations, signal propagation, analog and digital
signals, bandwidth of signal and a medium, Fourier analysis and the concept of bandwidth of a signal, The data transmission rate and bandwidth.


Network Models
Layered Tasks, The OSI reference model , Layers in the OSI reference model , TCP/IP protocol suite , Addressing IPv4

Information Encoding , Errors Detection and Correction Introduction, Representing different symbols, Minimizing errors , Multimedia , Multimedia and Data compression. Error classification, types
of errors, redundancy, detection versus correction , hamming distance , cyclic redundancy check.

Media and Transmission modes
Data and signals, Periodic analog signals, Digital signals, Transmission impairment, Data rate limits, Performance, Digital to digital, Analog to digital conversion , Transmission modes, Digital to analog conversion , Analog to analog conversion, Guided media and Unguided media 

Network topologies ,Switching and routing algorithms Mesh, star, tree, ring, bus, hybrid, switching basics , circuit switching, packet switching and Message switching , routing algorithms

IP version 6
Overview , Terminology, IPv6 addresses , Special addresses , IP v 6 header
formats, IPv6 extension headers , IPv6 autoconfiguration , configuration via
DHCP v6 , IPv6 transition

DBMS Reference Books

Books:
A Silberschatz, H Korth, S Sudarshan, “Database System and Concepts”, fifth Edition McGraw-
Hill ,
Rob, Coronel, “Database Systems”, Seventh Edition, Cengage Learning

DBMS Sem 2

Introduction to Databases and Transactions :
What is database system, purpose of database system, view of data,
relational databases, database architecture, transaction management,

Data Models : The importance of data models, Basic building blocks, Business rules, The evolution of data models, Degrees of data abstraction.

Database Design, ER-Diagram and Unified Modeling Language: Database design and ER Model:overview, ER-Model, Constraints, ERDiagrams, ERD Issues, weak entity sets, Codd’s rules, Relational
Schemas, Introduction to UML

Relational database model: Logical view of data, keys, integrity rules. Relational Database design: features of good relational database design, atomic domain and Normalization (1NF, 2NF, 3NF, BCNF).

Relational Algebra and Calculus: Relational algebra: introduction, Selection and projection, set operations, renaming, Joins, Division, syntax, semantics. Operators, grouping and ungrouping, relational comparison.
Calculus: Tuple relational calculus, Domain relational Calculus, calculus vs algebra, computational capabilities.

Constraints, Views and SQL: What is constraints, types of constrains, Integrity constraints, Views: Introduction to views, data independence, security, updates on views, comparison between tables and views
SQL: data definition, aggregate function, Null Values, nested sub queries, Joined relations. Triggers.

Transaction management and Concurrency control: Transaction management: ACID properties, serializability and concurrency control, Lock based concurrency control (2PL, Deadlocks),Time stamping methods, optimistic methods, database recovery management.

Microprocessor and microcontrollers Reference Books

References
William Stallings, “Computer Organisation and Architecture” ( 4th Edition ) - PHI, 1998.
Andrew C. Tanenbaum, “Structured Computer Organisation” (3rd Edition) -, PHI.
Computer System Architecture - M. Morris Memo, PHI, 1998.
John P Hayes, “Computer Architecture and Organisation” - McGraw Hill, 1998.
Digital Computer Fundamentals, Malvino
Microprocessor Architecture and Programming and Applications with the 8085, R.S. Gaonkar,
PRI (3rd Edition)
Digital Computer Fundamentals, Thomas C Bartee, TMG
The 8051 Microcontroller and Embedded systems by M. A. Mazidi, J. G. Mazidi and R. D.
McKinlay, Pearson Education.