4th SEM: WIRELESS DATA COMMUNCIATION - SYllabus

 

SKILL BASED SUBJECT

PAPER-2

WIRELESS DATA COMMUNICATION

UNIT-1 BASIC CONCEPTS OF OSI LAYERS

Data Communication – Networks – Protocol and Standards – Line Configuration – Topology – Transmission Modes – Categories of Networks – Internetworks- OSI Models – Functions of OSI Layers.

UNIT-II SIGNALS AND TRANSMISSION MEDIA

Analog and digital – Periodic and Non Periodic signals – Analog Signals – Time And Frequency Domain - Composite Signals- Digital signals – Guided Media – UnGuided Media – Transmission Impairment – Performance.

UNIT-III ERROR DETECTION, CORRECTION AND DATA LINK CONTROL

Type of errors –Detection-Vertical Redundancy Check (VRC) -Longitudinal Redundancy Check (LRC) Cyclic Redundancy Check (CRC) – check sum – Error Corrections – Flow Control – Error Control.)SWITCHING & NETWORK DEVICES: Circuit Switching-Packet Switching-Message Switching Repeaters-Bridges-Routers-Gateways-other Devices - Routing Algorithms-Distance Vectors Routing- Link State Routing.

UNIT- IV: WIRELESS NETWORKS

Wireless LAN: Advantages and Disadvantages-Infrared Vs Radio Transmission – Infrastructure Networks- Ad hoc Networks – Bluetooth- Wireless ATM: Working GroupServices- Reference Model – Functions – Radio Access Layer – Handover- Handover reference model- Requirements and Types.

UNIT-V TCP/IP PROTOCOL SUITE: PART I, PROTOCOLS & NETWORK SECURITY

Overview Of TCP/IP – Network Layer – Addressing – Subnetting – Other Protocols In The Network Layer – Transport Layer – Client/Server Model – BootStrap Protocol and DHCP - Domain Name System (DNS) – Tel Net –File Transmission Protocol (FTP) –Simple Mail Transfer Protocol (SMTP) – SNMP Protocol – Hyper Text Transmission Protocol (HTTP) – World Wide Web (WWW) –Four Aspects of Security – Privacy – Digital Signature – PGP – Access Authorization.

Text Book

1. Data Communication and Networking 2nd Edition Behrouz A. Forouzan, McGraw Hill Education 2014.

2. Stojmenovic and Cacute, Handbook of Wireless Networks and Mobile Computing, Wiley, 2002, ISBN 0471419028.

Reference Books

1. Data and Communication Network, William Stalling PHI 2014.

2. Computer Networks, Andrew S. Tanenbaum , David J. Wetherall, 5th Edition, Prentice Hall. 2010

E REFERENCES

1. http://nptel.ac.in/video.php?subjectId=117102062

SYLLABUS IN PDF 

 

4th SEM: RDBMS LAB

 

CORE PRACTICAL - 4

RELATIONAL DATABASE MANAGEMENT SYSTEMS LABS

LAB EXERCISES:

1. Execute a single line query and group functions.

2. Execute DDL Commands.

3. Execute DML Commands

4. Execute DCL and TCL Commands.

5. Implement the Nested Queries.

6. Implement Join operations in SQL

7. Create views for a particular table

8. Implement Locks for a particular table.

9. Write PL/SQL procedure for an application using exception handling.

10. Write PL/SQL procedure for an application using cursors.

11. Write a PL/SQL procedure for an application using functions

12. Write a PL/SQL procedure for an application using package

 CLICK FOR THE LAB PROGRAMS IN PDF

4th SEM: RDBMS - SYLLABUS

 

SEMESTER IV

CORE PAPER-4

RELATIONAL DATABASE MANAGEMENT SYSTEMS

UNIT- I : DATABASE ARCHITECTURE AND ER DIAGRAM

Database system applications - Purpose of database systems - View of data- Database languages - Database architecture - Database users and administrators - History of database systems-Entity relationship modeling: entity types, entity set, attribute and key, relationships, relation types, roles and structural constraints, weak entities, enhanced E-R and object modeling, sub classes; super classes, inheritance, specialization and generalization

UNIT- II: RELATIONAL DATA MODEL

Relational model concepts, Relational constraints, Relational Languages : Relational Algebra, The Tuple Relational Calculus - The Domain Relational Calculus - SQL: Basic Structure-Set Operations- Aggregate Functions-Null Value-Nested Sub Queries-Views Complex Queries Modification Of Database-Joined Relations-DDL-Embedded SQL-Dynamic SQL-Other SQL Functions- -Integrity and Security.

 

 

UNIT - III: DATA NORMALIZATION

Pitfalls in relational database design – Decomposition – Functional dependencies – Normalization – First normal form – Second normal form – Third normal form – Boyce-codd normal form – Fourth normal form – Fifth normal form.

UNIT- IV: STORAGE AND FILE ORGANIZATION

Disks - RAID -Tertiary storage - Storage Access -File Organization – organization of files - Data Dictionary storage

UNIT- V: QUERY PROCESSING AND TRANSACTION MANAGEMENT

Query Processing - Transaction Concept - Concurrency Control - Locks based protocol Deadlock Handling -Recovery Systems.

TEXT BOOK

1. Abraham Silberschatz, Henry Korth, S.Sudarshan, Database Systems Concepts, Sixth Edition, McGraw Hill, 2010. 2. Raghu Ramakrishnan and Johannes Gehrke, Database management systems, Third Edition,2002

REFERENCES

1. Bipin Desai, An Introduction to database systems, Galgotia Publications, 2010. 2. RamezElamassri, Shankant B-Navathe, Fundamentals of Database Systems, Pearson, 7th Edition, 2015

E - REFERENCES

1. NPTEL, Introduction to database design, Dr P Sreenivasa Kumar Professor CS&E, Department, IIT, Madras

2. NPTEL, Indexing and Searching Techniques in Databases Dr. Arnab Bhattacharya, IIT Kanpur

 

   SYLLABUS IN PDF