k-scheme syllabus

K-Syllabus

Sub Code: 15051

Computer Network And Security

UNIT	TOPIC
I	Data Communications
II	OSI Model and Data link layer
III	LAN Protocols and ISDN
IV	TCP/IP suit
V	Introduction to network security

Unit 1:

1.1 Data Communication :
Components of a data communication – Data flow: simplex – half duplex – full duplex; Networks – Network criteria – Types of Connections: Point to
point – multipoint; Topologies: Star, Bus, Ring, Mesh, Hybrid – Advantages and Disadvantages of each topology.

1.2 Types of Networks (Geographical Based):
LAN – MAN – WAN

1.3 Signals and Modulation:
Analog and Digital signals - Need for Modulation – Amplitude Modulation – Frequency Modulation – Pulse Modulation – Concepts only (no derivation).

1.4 Transmission Media :
Classification of transmission media - Guided – Twisted pair – Coaxial – Fiber optics – Unguided – Radio waves –Infrared – LOS – VSAT – cabling and
standards

1.5 Network devices:
Features and concepts of Hubs – Bridges – Switches - Routers – Gateways

Unit 2:

2.1 Network Models:
Protocol definition - standards - OSI Model – layered architecture –
functions of all layers.

2.2 Error detection & correction:
Types of errors – detection versus correction – CRC – Hardware implementation - parity check and checksum – Hamming code.

2.3 Flow and Error control:
Introduction – ARQ – Stop & Wait ARQ – Features and disadvantages of stop-and-wait ARQ - Go- Back - N – ARQ – Selective repeat ARQ - Comparison of Flow control protocols

Unit 3:

3.1 Character oriented Protocol:
BSC Frames – Bit oriented Protocol – HDLC – Transfer modes of HDLC – HDLC frame format - HDLC operation

3.2 802.X Protocols :
Concepts and PDU format of CSMA/CD (802.3) – Token bus (802.4) – Token ring (802.5) – Ethernet – type of Ethernet (Fast Ethernet, gigabit Ethernet) –
Comparison between 802.3, 802.4 and 802.5

3.3 FDDI :
Frame format – Advanatges and disadvantages of FDDI.

3.4 Switching :
Circuit– Packet– Message.

3.5 ISDN : Concepts – Services – Layers – Broad Band ISDN.

Unit 4:

4.1 Overview of TCP / IP :
OSI & TCP/IP – Transport Layers Protocol – connection oriented and connectionless Services – Sockets - TCP & UDP.

4.2 Network Layers Protocol :
IP – Interior Gateway Protocols (IGMP, ICMP, ARP, RARP Concept only).

4.3 IP Addressing :
Subnetting & Supernetting – Dotted Decimal Notation – IPv6 (concepts only)

4.4 Application Layer Protocols:
FTP– Telnet – SMTP– HTTP – DNS – POP.

Unit 5:

5.1 Introduction to network security:
definition & basic concepts – Basic concepts of RAID levels ( 0,1 and 5).

5.2 Types of attacks:
Access attacks –modification attacks – denial of service attacks.

5.3 Hacker Techniques:
Historical Hacking techniques & open sharing – bad passwords – advanced techniques sniffing switches networks–Malicious code identification–viruses–
Trojan horses–worms - SPAM.

5.4 Threats:
Definition – Targets- Agents – Events

5.5 Firewall :
Types –Developing firewalls

5.6 VPN:
Definition – Benefits – Issues – VPN – Server– Authentication – System – VPN Protocol.

Reference Books:

1. Data Communication and networking - Behrouz A.Forouzan Tata McGraw-Hill, New Delhi
2. Computer Communication Networks - Achyut S. Godbole Tata McGraw-Hill, New Delhi
3. Data and Computer Communications - William Stallings Prentice-Hall of India, Eighth Edition
4. Computer Networks Andrew - S.Tanenbaum Prentice-Hall of India, New Delhi
5. Network Security A beginner’s Guide Eric Maiwald Tata Mc Graw-Hill., Second Edition

---

Full Syllabus & Reference Books

Sub Code: 15052

UNIT	TOPIC
I	Basic Concepts
II	Client/Server Technology & Relational Database Approach
III	Structured Query Language
IV	PL/SQL
V	Enhanced Database Models

Unit 1:

Introduction:
Definition of Data, Data base and DBMS – Need for database –Advantages of database Systems - File based database systems – Disadvantages –
Record based database systems - Data base characteristics

Database terms :
Concurrency, Consistency, Data Availability, Reliability, Transparency Data Integrity

Components of a DBMS:
Database Engine – Data Dictionary – Query Processor –Report Writer – Forms Generator – Application Generator -Security

Data abstraction:
Schema – Data independence- Architecture of a database system DBMS system architecture types: Personal computer system – Centralized system –
Client / Server system – Distributed system.

Data models:
Relational – Hierarchical – Network.

Unit 2:

Client/server technology:
Client – server – distributed and co-operative processing – peer- to-peer processing – application components - transaction management

Relational data structure:
Relation – Domains & Attributes – Keys – Extensions – Intensions – Data structures – Tables – Data Integrity – Manipulation views – managing
data concurrency in a multi–user system - Data Security – Data Availability.

Table:
Columns, Rows, Primary Key, Secondary Key, Foreign key

E-R model:
Entities and attributes – Relationships – One to one –One to many - Many to one – Many to Many relationships – Normalizing the model.

Normalization: Introduction - 1NF - 2NF – 3NF - guidelines – Codd’s Rules.

Database Administration :
DBA Tasks – DBA Tools – User Privileges - Performance monitoring and tuning – query tracing - Backup and Recovery

Unit 3:

Data Definition Language:
Statements - Data Manipulation Language – statements - Retrieval operations

SQL Commands :
Selecting Columns from a table, Selecting Rows from a table - Built– in functions – Update Operations

Queries :
Simple query – where clause – group by – order by clauses -sub queries – correlated sub-queries. Set Operations – Union, minus

Constraints :
Alter table – table-level constraints.

Base Table:
Indexes – types – simple – compound ; Join – types – simple – Equi-join,
Non-equi join, self join, outer join

Creating and using Views:
creating a view, querying a view of more than one table.

Working with Numbers :
Displaying Numbers, Arithmetic Expressions

Functions and Operators:
Number Functions - sin(), cos(), tan(), sqrt(), Aggregate functions –count(), avg() Conversion functions – to_char(), to_date(), NVL(), Date
Functions – sysdate(), months_between(), add_moths(), Arithmetic, Logical and set Operators

Transaction control statements:
Commit, rollback, savepoint

Triggers:
Trigger definition – Trigger Events - Built-in Trigger – User defined Trigger – database triggers

Unit 4:

Introduction :
variables – literals – data types – advantages of PL/SQL

Control statements :
if ; iterative control – loop, while, for , goto ; exit when

Cursors :
Types – implicit, explicit – parameterized cursors – cursor attributes

Exceptions:
Types – internal , user-defined , handling exceptions – raise statement

PL/SQL tables and records:
Declaring PL/SQL tables - referring PL/SQL tables, inserting and fetching rows using PL/SQL table, deleting rows; records - declaration of
records - deleting records

Sub programs:
Functions - procedures - in, out, inout parameters; purity functions - packages - package specification - advantages of packages - private and public items -
cursors in packages.

Unit 5:

Data warehousing :
Definition - DSS and EIS ( Definition) - Characteristics and functioning and architecture of Data Warehousing - Data marts - Data warehousing Life
Cycle - data modeling (Multidimensional Database) for data warehousing - Building of data warehouse - OLAP, MOLAP, ROLAP - Data warehouse and views - Future open issue for data warehouse

Data Mining :
What is data mining Technology - Relationship to Data warehousing - Association rules - Classification - Clustering - Approaches to data mining problems -
Applications of Data mining problem - Commercial tools of data mining - Knowledge Discovery

Reference Books:

1. Database Management System - Date ,C.J., Galgotia Publications
2. Fundamentals of Database System - Elmasri, R.A.,Navathe, Shyam B. Narosa Publishing House.
3. Database Management System - Post, Gerald V ,Tata McGraw-Hill, 2004
4. An introduction to Database Systems - Bipin C Desai Galgotia Publications ( P) Ltd., 2005
5. Database system concepts - Abraham Silberschatz, Henry F Korth and Sudharshan S Mc Graw Hill Publishin Company Limited, 2004
6. Database Management Systems - Raghu Ramakrishnan Mc Graw Hill Publishing Company Limited, 2004

.net

Sub Code: 15071

UNIT	TOPIC
I	Introduction to .Net Framework
II	Introduction to VB.Net
III	Application Development on .Net
IV	Introduction to ASP.Net
V	XML Web Services

Unit 1

1.1 Introduction to .NET framework :
Managed Code and the CLR- Intermediate Language, Metadata and JIT Compilation - Automatic Memory Management.

1.2 Language Concepts and the CLR:
Visual Studio .NET - Using the .NET Framework.

1.3 The Framework Class Library:
.NET objects - ASP .NET - .NET web services – Windows Forms

Unit 2:

2.1 Elements :
Variables and constants – data types – declaration. Operators – types – precedence. Expressions. Program flow – Decision statements – if .. then, if..then..else, select..case– Loop statements – while..end while, do..loop, for..next, for..each..next.

2.2 Types:
Value data types – Structures, Enumerations. Reference data types- Single-dimensional – Multi-dimensional arrays – jagged arrays – dynamic arrays

2.3 Windows programming:
Creating windows Forms – windows controls – Button, Check box, Combo box, Label, List box, Radio Button, Text box. Events – Click, close, Deactivate, Load, Mousemove, Mousedown, MouseUp.

2.4 Menus and Dialog Boxes:
Creating menus – menu items – context menu - Using dialog boxes – showDialog() method.UNIT - III APPLICATION DEVELOPMENT USING ADO .NET

Unit 3:

3.1 Features of ADO.NET:
Architecture of ADO.NET – ADO.NET providers – Connection – Command – Data Adapter – Dataset.

3.2 Accessing Data with ADO.NET:
Connecting to Data Source, Accessing Data with Data set and Data Reader - Create an ADO.NET application - Using Stored Procedures.

Unit 4:

4.1 ASP.NET Features:
Change the Home Directory in IIS - Add a Virtual Directory in IIS- Set a Default Document for IIS - Change Log File Properties for IIS - Stop, Start, or Pause a Web Site.

4.2 Creating Web Controls:
Web Controls - HTML Controls, Using Intrinsic Controls, Using Input Validation Controls, Selecting Controls for Applications - Adding web controls to a Page.

4.3 Creating Web Forms:
Server Controls - Types of Server Controls - Adding ASP.NET Code to a Page.

Unit 5:

5.1 Overview of XML :
XML Serialization in the .NET Framework -SOAP Fundamentals-Using SOAP with the .NET Framework.

5.2 Introduction to web services:
Web Services protocol and standards – WSDL Documents - Overview of UDDI - Calling a Web Service from a Browser - Calling a Web Service by Using a Proxy - Creating a simple web service - Creating and Calling a Web Service by Using Visual Studio .NET.

Reference Books:

1. Introduction to Visual basic.NET - NIIT Prentice Hall of India,2005
2. Introducing Microsoft .NET- David S. Platt Microsoft Press”, Saarc Edition, 2001
3. Introduction to Microsoft® ASP.NET Work Book - Microsoft- Microsoft Press
4. Developing XML Web Services Using Microsoft® ASP.NET -Microsoft- Microsoft Press
5. Designing Microsoft ASP.NET Applications-Douglas J. Reilly-Microsoft Press
6. ASP.NET-Danny Ryan and Tommy Ryan-Hungry Minds Maran Graphics
   

Embeded System

Sub Code: 14062

UNIT	TOPIC
I	ARM Introduction
II	LPC 2148 ARM CPU
III	LPC 2148 Peripherals
IV	Oprating Systems Overview
V	µC/OS-II

Unit 1:

Introduction - The ARM Architecture Overview - Instruction set Summary - Processor operating states- Memory formats - Memory Interface - Bus interface signals - Addressing
signals Addressing timing - Data Timed Signals - Debug interface - Debug systems - Debug interface signals - ARM7TDMI Core and system state - About Embedded ICE-RT Logic – Instruction Set.

Unit 2:

Introduction: - Architectural Overview - Memory Mapping -Block Diagram - System control block functions: PLL - Power Control - Reset - VPB Divider - Wakeup Timer - Memory Acceleration Module - Timer0 and Timer1- PWM - RTC - On Chip ADC - On Chip DAC- Interrupts- Vector Interrupt Controller.

Unit 3:

General Purpose Input/Output Ports (GPIO) - Universal Asynchronous Receiver/Trasmitter (UART) - I2C Interface – Multimaster and Multislave communication - SPI Interface - SSP Controller – USB 2.0 Device Controller.

Unit 4:

Introduction OS – Function of OS – Defining an RTOS – Differences in Embedded Operating Systems – Introduction to Kernel – Resources – Shared Resources - Defining a Task – Task States -Multitasking - Scheduling and Scheduling Algorithms - Context Switching – Clock Tick – Timing of Task.

Unit 5:

Introduction – Features and Goals of µC/OS – II – Requirements of µC/OS – II - Support Devices for µC/OS – II – File Structure in µC/OS – II - Task Management Functions – Creating a Task - Time Management Functions – OS Delay Functions - Implementation of Scheduling and rescheduling.

Reference Books:

1. Embedded Systems Architecture - Tammy Noergaard
2. ARM System Developer’s Guide – Andrew N.Sloss
3. ARM Architecture Reference Manual - David Seal
4. ARM System-on-Chip Architecture (2nd Edition) by Steve Furbe
5. MicroC/OS – II The Real Time Kernel Jean J. Labrosse
6. Real Time Concepts for Embedded Systems – by Qing Li and Caroline Yao
7. Embedded / Real Time Systems : Concepts , Design & Programming by Dr. K.V.K.K
   PRASAD 1. LPC 2148 User Manual