B.Sc (Information Technology)
PROGRAMME OUTCOMES

P O1: Ability to apply knowledge in mathematics, science fundamentals to solve problems.

P O2: Understanding the basic concepts of system software, hardware and computer graphics.

P O3: Ability to work teams as wells as individual to build software system and to use a range of programming languages and tools to develop computer programs to solve problems effectively.

P O4: Ability to select appropriate techniques to tackle and solve problems in the discipline of information security management.

P O5: Implement independent projects of their own choice using latest tools.



PROGRAMME SPECIFIC OUTCOMES

PS O1: Acquire academic excellence with professional skill for higher studies and research.

PS O2: Achieve greater heights in various sectors of IT Industrythrough analytical design and implementation skills.

PS O3: Identify and apply computing practices to succeed as an employee or an entrepreneurial pursuit.

PS O3: Be ethically and professionally responsible with the ability to relatecomputer applications to broader social context for the growth of the nation.

PS O3: Create, select and apply modern tools and techniques to analyze and develop a successful software system.

Syllabus

Hours/Week 6 Credits 5
Semester I

Objective: To Provide the Basic Concepts in Information Technology

Unit I: Introduction to Computers - Generation of Computers - Classfication of Digital Computer - Anatomy of Digital Computer.
Unit II: Architecture of Computer - CPU and Memory - Secondary Story Devices - Input Devices - Output Devices.
Unit III: Introduction to Computer Software - Programming Language - Operating Systems - Introduction to Database Management System - Data Mining and On-line Analytical Processing.
Unit IV: Computer Networks - WWW and Internet - Email - Intranets - Mobile Computing and Business on the Internet.
Unit V: Introduction to Multimedia - Multimedia Applications - Computers at Home, Education, Entertainment, Science, Medicine and Engineering - Introduction to Computer Security - Computer Viruses, Bombs, Worms.
TEXT BOOKS:
1. Fundamentals of Information Technology ,Alexis Leon And Mathews Leon, Vikas Publishing House Pvt. Ltd, 2009
REFERENCE BOOKS:
1. Information Technology - The Breaking Wave, Dennis P. Curtin ,Kim foley, KunalSen and Cathleen Morin, Tata-McGraw Hill Publications, 2005.

Course Outcomes (CO) : On completion of the course, students should be able to
Number CO Statement
CO1. Demonstrate that they can use digital technology in research, analysis and critical inquiry.
CO2. Understanding of the concepts of online security and privacy.
CO3. Knowledge of information technologies and digital cultures.
CO4. Evaluate and explain the ongoing changes in digital technology and their impacts on society.
CO5. Apply a variety of information technologies to their own work.
PO - CO MAPPING MATRIX:
CO PO PSO
PO1 PO2 PO3 PO4 PO5 PSO1 PSO2 PSO3
CO1 2 3 2 - 2 3 2 2
CO2 2 2 2 1 1 1 2 1
CO3 2 1 3 1 2 3 1 3
CO4 1 2 2 - 3 1 2 2
CO5 2 2 2 - 3 2 2 3
Hours/Week 3 Credits 2
Semester II

Objective: To Impart Practical Training in Word Processing Software

Use MS-Office or Open Office for the following
1. Text Manipulation
Change the font size and type
Aligning and justification of text
Underlining the text
Indenting the text
i. Prepare a Bio-data
ii. Prepare a Letter

2. Usage of Numbering, Bullets, Footer and Headers
Usage of Spell checks and Find and Replace
i. Prepare a document in newspaper formats
ii. Prepare a document with bullets and footers and headers


3. Tables and Manipulations
Creation, Insertion, Deletion (Columns & Rows) and usage of Auto Format
i. Create mark sheet using table and find out the total marks
ii. Create a calendar and Auto Format it.


4. Picture Insertion and Alignment
i. Prepare a greeting card
ii. Prepare a handout.


5. Mail merge concepts
i. Prepare a business letter for more than one company using mail merge
ii. Prepare an invitation to be sent to specific addresses in the data source


6. A Presentation that shows five different Greeting Cards with Pictures.
7. Prepare Slides that helps you to teach about ―Computer Networks.
8. A Presentation with different Animation Effects.
9. Prepare Slides that gives a Presentation about ―Computers using Macros.
10. Usage of Formula and Built – in – functions
11. Inventory report preparation
12. Invoice report preparation
13. Drawing graphs


Course Outcomes (CO) : On completion of the course, students should be able to
Number CO Statement
CO1. Demonstrate a basic understanding of computer hardware and software.
CO2. Demonstrate problem solving skills.
CO3. Applying logical skills to programming in a variety of languages.
CO4. Demonstrate basic understanding of network principles.
CO5. present conclusions effectively, orally, and in writing.
PO - CO MAPPING MATRIX:
CO PO PSO
PO1 PO2 PO3 PO4 PO5 PSO1 PSO2 PSO3
CO1 2 2 2 2 3 3 2 2
CO2 2 2 2 2 3 3 3 3
CO3 1 1 3 1 3 3 1 1
CO4 2 3 1 2 2 3 2 2
CO5 3 2 1 2 2 3 2 2
Hours/Week 6 Credits 5
Semester II

Objective: To impart basic knowledge of Programming Skills in C language.

Unit I: Introduction to C – Constants, Variables, Data types – Operator and Expressions.
Unit II: Managing Input and Output operations – Decision Making and Branching – Decision making and Looping.
Unit III: Arrays – Character Arrays and Strings – User defined Functions.
Unit IV: Structures and unions – Pointers – File management in C.
Unit V: Dynamic memory allocation – Linked lists- Preprocessors – Programming Guide lines.
TEXT BOOKS:
Balagurusamy E .,Programming in ANSI C , Sixth Edition, McGraw-Hill, 2012
REFERENCE BOOKS:
1. R.S.Bichkar, Programming with C, University Press, 2012

Course Outcomes (CO) : On completion of the course, students should be able to
Number CO Statement
CO1. Introduction to C – Constants, Variables, Data types
CO2. Managing Input and Output operations.
CO3. Applying arrays, Functions, Structures, Unions and Pointers concepts used to developing the programs.
CO4. File management concepts in C Programs
CO5. Dynamic memory allocation & Programming Guide lines.s
PO - CO MAPPING MATRIX:
CO PO PSO
PO1 PO2 PO3 PO4 PO5 PSO1 PSO2 PSO3
CO1 2 3 3 - 2 3 2 2
CO2 1 2 2 1 1 1 2 1
CO3 2 1 3 1 2 3 1 3
CO4 1 2 2 - 3 1 2 2
CO5 2 2 3 - 3 2 1 -
Hours/Week 3 Credits 2
Semester II

Objective: To Impart Practical Training in C Programming Language

1. Write a Program to convert temperature from degree Centigrade to Fahrenheit.
2. Write a Program to find whether given number is Even or Odd.
3. Write a Program to find greatest of Three numbers.
4. Write a Program to using switch statement to display Monday to Sunday.
5. Write a Program to display first Ten Natural Numbers and their sum.
6. Write a Program to find Multiplication of Two Matrices.
7. Write a Program to find the maximum number in Array using pointer.
8. Write a Program to reverse a number using pointer.
9. Write a Program to solve Quadratic Equation using functions.
10. Write a Program to find factorial of a number using Recursion.
11. Write a Program to show Call by Value and Call by Reference.
12. Write a Program to add two numbers using pointer.
13. Write a Program to create a file containing Student Details.
14. Write a Program to update the details of student’s information using various file modes.


Course Outcomes (CO) : On completion of the course, students should be able to
Number CO Statement
CO1. Write simple programs using C fundamentals and control statements .
CO2. Develop various menu driven programs using concepts of control statements, arrays, functions and pointers.
CO3. Develop a student details using structure and file concepts.
CO4. Develop a Program to show Call by Value and Call by Reference.
CO5. Develop a Program to find factorial of a number using Recursion.
PO - CO MAPPING MATRIX:
CO PO PSO
PO1 PO2 PO3 PO4 PO5 PSO1 PSO2 PSO3
CO1 2 2 2 2 3 3 2 2
CO2 2 2 2 2 3 3 3 3
CO3 1 1 3 1 3 3 1 1
CO4 2 3 1 2 2 3 2 2
CO5 3 2 1 2 2 3 2 2
Hours/Week 6 Credits 6
Semester III

Objective: To impart basic knowledge of Programming Skills in C++ language.

Unit I: Principles of Object- Oriented Programming – Beginning with C++ - Tokens,Expressions and Control Structures – Functions in C++
Unit II: Classes and Objects – Constructors and Destructors – New Operator – Operator Overloading and Type Conversions
Unit III: Inheritance: Extending Classes – Pointers- Virtual Functions and Polymorphism
Unit IV: Managing Console I/O Operations – Working with Files – Templates – Exception Handling
Unit V: Standard Template Library – Manipulating Strings – Object Oriented Systems Development
TEXT BOOKS:
1. Balagursamy E, Object Oriented Programming with C++, Tata McGraw Hill Publications, Sixth Edition, 2013
REFERENCE BOOKS:
1. Ashok Kamthane, Programming in C++, Pearson Education, 2013.

Course Outcomes (CO) : On completion of the course, students should be able to
Number CO Statement
CO1. State OOPS and Relate C and C++
CO2. Categorize OOPS such as encapsulation, abstraction, polymorphism .
CO3. Apply encapsulation concepts in developing the programs with classes and objects.
CO4. Identify different types of inheritance and apply them for reusability of code.
CO5. Managing Console I/O Operations and Object Oriented Systems Development programs
PO - CO MAPPING MATRIX:
CO PO PSO
PO1 PO2 PO3 PO4 PO5 PSO1 PSO2 PSO3
CO1 2 2 3 - 2 3 2 -
CO2 1 2 2 1 2 3 2 -
CO3 2 2 3 1 2 3 2 -
CO4 1 2 2 - 3 2 2 -
CO5 2 2 3 - 3 3 2 -
Hours/Week 3 Credits 2
Semester III

Objective: To Impart Practical Training in C++ Programming Language

1. Classes Write a Program using a class to represent a Bank Account with Data Members – Name of depositor, Account Number, Type of Account and Balance and Member Functions – Deposit Amount – Withdrawal Amount. Show name and balance. Check the program with own data.
2. Constructor & Destructor Write a program to read an integer and find the sum of all the digits until it reduces to a single digit using constructor, destructor and default constructor.
3. Default & Reference Argument Write a program using function overloading to read two matrices of different data types such as integers and floating point numbers. Find out the sum of the above matrices separately and display the total sum of these arrays individually.
4. Operator Overloading a. Addition of Two Complex Numbers.
b. Matrix Multiplication
5. Inheritance Prepare Pay Roll of an employee using Inheritance.
6. Pointers a. Write a Program to find the number of vowels in a given text
b. Write a Program to check for Palindrome
7. Files Prepare Students Mark List in a file with Student Number, Mark in four subjects and Mark Total. Write a program to arrange these records in the ascending order of Mark Total and write them in the same file overwriting the earlier records.
8. Exception Handling Prepare Electricity Bill for customers generating and handling any two Exceptions.

Course Outcomes (CO) : On completion of the course, students should be able to
Number CO Statement
CO1. Implemented virtual functions in C++.
CO2. Data encapsulation, data hiding and private functions implemented in C++.
CO3. Write a program to find the matrix multiplication using operator overloading.
CO4. Classes, Pointers, Inheritance.
CO5. Exception handling, file Handling.
PO - CO MAPPING MATRIX:
CO PO PSO
PO1 PO2 PO3 PO4 PO5 PSO1 PSO2 PSO3
CO1 2 2 1 2 2 3 2 1
CO2 2 1 2 3 2 3 2 2
CO3 2 2 2 1 1 3 2 2
CO4 3 3 1 3 3 3 3 3
CO5 3 2 1 3 1 3 3 3
Hours/Week 6 Credits 5
Semester IV

Objective: To understand the basic concepts of Object Oriented Programming with Java language

Unit I: Object Oriented Programming : Introduction to OOP – Objects and Classes – Characteristics of OOP – Difference between OOP and Procedure Oriented Language – Introduction to java Programming : Introduction – Features of Java – Comparing java and Other Languages – Applications and Applets – Java Development Kit – Complex Programs – Java Source File Structure – Prerequisites for Compiling and Running Java Programs
Unit II: Java Language Fundamentals : The Building Blocks of Java – Data Types – Variable Declarations – Wrapper Classes – Operations and Assignment – Control Structures – Arrays – Strings – StringBuffer Class
Unit III: Java as an OOP Language : Defining Classes – Modifiers – Packages - Interfaces
Unit IV: Exception Handling : Introduction – Basics of Exception Handling – Exception Hierarchy – Constructors and Methods in Throw able Class - Unchecked and Checked Exceptions – Handling Exceptions in Java – Exception and Inheritance – Throwing User-defined Exceptions – Redirecting and Rethrowing Exceptions – Advantages of Exception Handling Mechanism – Multithreading : Introduction – Creating Threads – Thread Life-cycle – Thread Priorities and Thread Scheduling – Thread Synchronization – Daemon Threads – Tread Groups – Communication of Threads
Unit V: Files and I/O Streams : Overview – Java I/O – File Streams – FileInputStream and FileOutputStream – File Streams – RandomAccess File – Serialization - Applets : Introduction – Java Applications versus Java Applets – Applet Life-cycle – Working with Applets – The HTML APPLET Tag – The java.Applet package
TEXT BOOKS:
1. Object Oriented Programming through Java, P.Radha Krishna, University Press,2011
REFERENCE BOOKS:
Java Programming, K.Rajkumar, Pearson India, 2013

Course Outcomes (CO) : On completion of the course, students should be able to
Number CO Statement
CO1. Apply encapsulation concepts in developing the programs with classes and objects.
CO2. Identifying different types of inheritance and apply them for reusability of code.
CO3. Java as an OOP Language, Packages - Interfaces..
CO4. Design program using different methods of thread creation and exception handling.
CO5. Create Internet program using applets.
PO - CO MAPPING MATRIX:
CO PO PSO
PO1 PO2 PO3 PO4 PO5 PSO1 PSO2 PSO3
CO1 2 2 3 2 2 3 1 2
CO2 1 2 2 1 2 3 2 1
CO3 2 2 3 1 2 3 1 2
CO4 1 2 2 - 3 3 2 -
CO5 2 2 3 2 3 3 3 2
Hours/Week 3 Credits 2
Semester IV

Objective: To Impart Practical Training in Java Programming Language

1. Write a program to sort the given numbers using arrays.
2. Write a program to implement the FIND and REPLACE operations in the given multiple text.
3. Write a program to implement a calculator to perform basic arithmetic Operations.
4. Write a program to find the area of a rectangle using constructor
5. Write a program to find the student’s percentage and grade using command line arguments.
6. Write a program to draw circle or triangle or square using polymorphism and inheritance.
7. Implement multiple inheritance concepts in java using interface, you can choose your own example of a company or education institution or a general concept which requires the use of interface to solve a particular problems.
8. Write a program to create threads and assign priorities to them
9. Write a program to develop an applet to play multiple audio clips using multithreading.
10. Write a program to create a window with three check boxes called red, green and blue. The applet should change the colors according to the selection.


Course Outcomes (CO) : On completion of the course, students should be able to
Number CO Statement
CO1. Create a program using utility packages.
CO2. Demonstrated applet programming with five life cycles.
CO3. Difference between string class and string buffer class with examples.
CO4. Constructor, polymorphism and inheritance.
CO5. Using interface, multithreading.
PO - CO MAPPING MATRIX:
CO PO PSO
PO1 PO2 PO3 PO4 PO5 PSO1 PSO2 PSO3
CO1 2 2 2 2 3 3 2 2
CO2 2 2 1 3 3 3 2 2
CO3 2 2 2 2 2 3 2 2
CO4 2 2 2 3 3 3 3 2
CO5 2 2 3 2 2 3 2 2
Hours/Week 5 Credits 5
Semester V

Objective: To understand the concepts of Data Structures and Algorithms.

Unit I: Arrays and sequential representations – ordered lists – Stacks and Queues – Evaluation ofExpressions – Multiple Stacks and Queues – Singly Linked List – Linked Stacks and queues – Polynomial addition.
Unit II: Trees – Binary tree representations – Tree Traversal – Threaded Binary Trees – Binary Tree Representation of Trees – Graphs and Representations – Traversals, Connected Components and Spanning Trees – Shortest Paths and Transitive closure – Activity Networks – Topological Sort and Critical Paths.
Unit III: Algorithms – Priority Queues - Heaps – Heap Sort – Merge Sort – Quick Sort – Binary Search – Finding the Maximum and Minimum.
Unit IV: Greedy Method : The General Method – Optimal Storage on Tapes – Knapsack Problem – Job Sequencing with Deadlines – Optimal Merge Patterns.
Unit V: Back tracking: The General Method – The 8-Queens Problem – Sum of Subsets – Graph Coloring.
TEXT BOOKS:
1. Fundamentals of Data Structure – Ellis Horowiz, SartajSahni, Galgotia Publications, 2008
2. Computer Algorithms – Ellis Horowiz, SartajSahni and Sanguthevar Rajasekaran, University Press, 2008.
REFERENCE BOOKS:
1. Data Structures – Seymour Lipschutz, Tata Mcgraw Hill, Schaum’s Outline Series, 2014

Course Outcomes (CO) : On completion of the course, students should be able to
Number CO Statement
CO1. Explain the linear data structures(stack, queues and linked list)
CO2. Explain the non-linear structures(trees and graphs)
CO3. Describe about the divide and conquer techniques(sorting)
CO4. Illustrate and analyse the greedy method(knapsnack problem)
CO5. Prove that Backtracking method (8-Queens problem, sum of subsets)
PO - CO MAPPING MATRIX:
CO PO PSO
PO1 PO2 PO3 PO4 PO5 PSO1 PSO2 PSO3
CO1 3 3 2 2 2 3 3 2
CO2 2 1 2 1 1 3 2 1
CO3 2 2 2 2 2 3 1 2
CO4 1 1 1 1 1 3 2 1
CO5 2 2 2 2 2 3 1 2
Hours/Week 6 Credits 6
Semester V

Objective: To understand the Design and Organization of Computer Networks

Unit I: Overview and Physical Layer: Introduction: Data Communications - Networks - Network Types, Network Models: TCP/IP Protocol Suite- The OSI Model, Bandwidth utilization : Multiplexing- Spread Spectrum, Transmission Media: Guided Media-Unguided Media, Switching: Circuit Switched Network-Packet Switching-Structure of a switch
Unit II: DataLinkLayer:Error Deduction and Correction : Introduction- Cyclic codes- Forward error correction, Data link Control: Datalink layer protocols- Media Access Control: Random Access- Controlled Access, Wireless Networks: IEEE 802.11- Bluetooth-Cellular Telephone- Satellite network- Connection devices,
Unit III: Network Layer Services : Packet Switching- Nework layer performance- IPV4 Addresses- Internet Protocol-Routing Algorithms - IPV6 Addressing
Unit IV: Transport Layer : Transport Layer Protocols- User Datagram Protocol - TCP:TCP Services TCP features - Windows in TCP - Flow Control - Error Control- TCP Congestion Control - TCP timers
Unit V: Application Layers : Client Server Programming - Word Wide Web & HTTP - FTP - Email - DNS
TEXT BOOKS:
1. Data Communications and Networking, Behrouz A Forouzan, Tata McGraw Hill, Fifth Edison, 2013
REFERENCE BOOKS:
1. Data Communications and Networks, Achyut Godbole and Atul Kahate, McGraw Hill Education, 2011

Course Outcomes (CO) : On completion of the course, students should be able to
Number CO Statement
CO1. Explain the fundamental knowledge in Network.
CO2. Hardware and Software; summarize OSI reference Model.
CO3. Describe about the types of Transmission Media. Relate and illustrate the techniques of Error Detection and Correction.
CO4. Illustrate and analyses the Routing and Congestion Control Algorithms in Network Layer; explain the underlying protocol in Transport Layer.
CO5. Identify the functionality of Application Layer services
PO - CO MAPPING MATRIX:
CO PO PSO
PO1 PO2 PO3 PO4 PO5 PSO1 PSO2 PSO3
CO1 3 2 3 2 2 3 2 2
CO2 2 3 2 2 2 3 3 3
CO3 3 2 2 3 1 3 2 2
CO4 2 2 2 1 2 3 1 1
CO5 3 3 3 3 1 3 3 3
Hours/Week 5 Credits 5
Semester V

Objective: To provide the Fundamental Concepts in an Operating System.

Unit I: Introduction - What Is an Operating System-Operating System Software -A Brief History of Machine Hardware -Types of Operating Systems -Brief History of Operating System Development-Object-Oriented Design
Unit II: Early Systems: Single-User Contiguous Scheme -Fixed Partitions-Dynamic Partitions-Best-Fit versus First-Fit Allocation -Deallocation - Relocatable Dynamic Partitions. Virtual Memory: Paged Memory Allocation-Demand Paging-Page Replacement Policies and Concepts -Segmented Memory Allocation-Segmented/Demand Paged Memory Allocation - Virtual Memory-Cache Memory
Unit III: Overview-About Multi-Core Technologies-Job Scheduling Versus Process Scheduling-Process Scheduler-Process Scheduling Policies-Process Scheduling Algorithms -A Word About Interrupts-Deadlock-Seven Cases of Deadlock -Conditions for Deadlock-Modeling Deadlock-Strategies for Handling Deadlocks –Starvation - Concurrent Processes: What Is Parallel Processing-Evolution of Multiprocessors-Introduction to Multi-Core Processors-Typical Multiprocessing Configurations--Process Synchronization Software
Unit IV: Types of Devices-Sequential Access Storage Media-Direct Access Storage Devices-Magnetic Disk Drive Access Times- Components of the I/O Subsystem- Communication among Devices-Management of I/O Requests
Unit V: The File Manager -Interacting with the File Manager -File Organization - Physical Storage Allocation -Access Methods-Levels in a File Management System - Access Control Verification Module
TEXT BOOKS:
1. Understanding Operating Systems, Ann McIver McHoes and Ida M. Flynn, Course Technology, Cengage Learning, 2011
REFERENCE BOOKS:
1. Operating Systems, Achyut Godbole and Atul Kahate, McGraw Hill Publishing, 2010.

Course Outcomes (CO) : On completion of the course, students should be able to
Number CO Statement
CO1. Understanding and Recognizing the various types of operating system.
CO2. Explaining, Discuss, Compare and Contrast the various scheduling algorithms.
CO3. Describing, Compute and choose the correct scheduling algorithm for the given problem.
CO4. Understanding the Deadlock concepts and Memory Management Techniques.
CO5. Discussing the concepts of file systems and mass storage structure, explain the different allocation methods
PO - CO MAPPING MATRIX:
CO PO PSO
PO1 PO2 PO3 PO4 PO5 PSO1 PSO2 PSO3
CO1 3 2 1 1 1 3 3 3
CO2 2 2 2 2 1 2 2 1
CO3 3 1 1 1 - 2 2 2
CO4 1 2 2 1 2 3 1 1
CO5 2 1 1 2 - 3 2 2
Hours/Week 4 Credits 3
Semester V

Objective: To Impart Practical Training in Computer Graphics and Animation related problems

Photoshop :
1. (i) Handling different file formats and interchanging them, changing the resolution, color, grayscales and size of the images
(ii) Using brushes and creating multicolor real life images
2. Cropping, rotating, overlapping, superimposing, pasting photos on a page
3. Creation of a single image from selected portions of many
4. Developing a commercial brochure with background tints
5. Creating an image with multi-layers of images and texts.
6. Applying masks and filtering on images

Flash :
Develop an image(s) and do the following.
1. Basic Drawing and Painting
2. Working with Strokes and Fills
3. Creating Custom Colors, Gradients, and Line Styles Transforming and Grouping Objects
4. Creating and Managing Multiple Layers
5. Converting Text into Shapes
6. Animate using motion, shape, Tweening, and actions


Course Outcomes (CO) : On completion of the course, students should be able to
Number CO Statement
CO1. Basic drawing and editing knowledge.
CO2. Identification of basic 2D drawing.
CO3. Creation of Animation in different type.
CO4. Commercial brochure with background tints, Managing Multiple Layers.
CO5. Masks and filtering, motion, shape, Tweening, and actions.
PO - CO MAPPING MATRIX:
CO PO PSO
PO1 PO2 PO3 PO4 PO5 PSO1 PSO2 PSO3
CO1 1 1 2 1 2 3 2 1
CO2 2 2 2 2 3 3 1 2
CO3 2 1 2 2 2 3 2 3
CO4 3 2 1 1 3 3 3 2
CO5 3 2 1 2 1 3 3 1
Hours/Week 5 Credits 5
Semester V

Objective: To provide knowledge of the various phases of Software Engineering Process

Unit I: Introduction : Introduction to Software Engineering - Software Process - Software Process Models - Software Model - Requirements Engineering Principles : Requirements Engineering - Importance of Requirements - Types of Requirements - Steps involved in Requirements Engineering
Unit II: Requirements Analysis Modeling : Analysis Modeling Approaches - Structured Analysis - Object Oriented Analysis - Design and Architectural Engineering : Design Process and Concepts - Basic Issues in Software Design - Characteristics of Good Design - Software Design and Software Engineering - Function Oriented System vs Object Oriented System - Modularity, Cohesion, Coupling, Layering - Real Time Software Design - Design Models - Design Documentation
Unit III: Object Oriented Concepts : Fundamental Parts of Object Oriented Approach - Data Hiding and Class Hierarchy Creation - Relationships - Role of UML in OO Design - Design Patterns - Frameworks - Object Oriented Analysis - Object Oriented Design - User Interface Design : Concepts of User Interface - Elements of User Interface - Designing the User Interface - User Interface Evaluation - Golden Rules of User Interface Design - User Interface Models - Usability
Unit IV: Software Coding - Introduction to Software Measurement and Metrics - Software Configuration - Project Management Introduction - Introduction to Software Testing - Software Maintenance
Unit V: Web Engineering : Introduction to Web - General Web Characteristics - Web Application Categories - Working of Web Application - Advantages and Drawbacks of Web Applications - Web Engineering - Emerging Trends in Software Engineering - Web 2.0 - Rapid Delivery - Open Source Software Development - Security Engineering - Service Oriented Software Engineering - Web Service - Software as a Service - Service Oriented Architecture - Cloud Computing - Aspect Oriented Software Development - Test Driven Development - Social Computing
TEXT BOOKS:
1. Software Engineering, Chandramouli Subramanian, Saikat Dutt, Chandramouli Seetharaman, B.G. Geetha, Pearson Publications, 2015
REFERENCE BOOKS:
1. Software Engineering, Jibitesh Mishra, Pearson Education, 2011

Course Outcomes (CO) : On completion of the course, students should be able to
Number CO Statement
CO1. Learn the phases of software development.
CO2. Develop process models and process system models
CO3. Gather, understand, analyze and specify requirements
CO4. Develop architectural diagram, and implement by following coding principles
CO5. Apply testing strategies and handle software product maintenance issues
PO - CO MAPPING MATRIX:
CO PO PSO
PO1 PO2 PO3 PO4 PO5 PSO1 PSO2 PSO3
CO1 3 3 3 3 3 3 3 1
CO2 2 2 2 2 1 3 2 2
CO3 2 2 1 1 2 3 2 2
CO4 3 3 1 2 1 3 3 2
CO5 3 3 2 2 2 3 3 3
Hours/Week 6 Credits 6
Semester VI

Objective: To understand the Architectures, Sychronization Process and Operating Systems in Mobile Computing

Unit I: Mobile Communications - An Overview : Mobile Computing - Mobile Computing Architecture - Mobile Devices - Mobile System Networks - Data Dissemination - Mobility Management - Security
Unit II: Mobile Devices and Systems : Mobile Phones - Digital Music Players - Handheld Pocket Computers - Handheld Devices with Operating Systems - Smart Systems - Limitations of Mobile Devices - Automotive Systems
Unit III: GSM and Similar Architectures : GSM Services and System Architecture - Radio Interfaces - Protocols - Localization - Calling - Handover - Security - New Data Devices - General Packet Radio Service - High Speed Circuit Switched Data
Unit IV: Data Synchronization in Mobile Computing Systems : Synchronization - Synchronization Software for Mobile Devices - Synchronization Protocols - Mobile Devices Server and Management : Mobile Agent - Application Server - Gateways - Portals - Service Discovery - Device Management - Mobile File Systems - Security
Unit V: Mobile Operating Systems : Operating System - Palm OS - Windows CE - Symbian OS - Linux for Mobile Devices
TEXT BOOKS:
1. Mobile Computing, Rajkamal, Oxford University Press, 2011.
REFERENCE BOOKS:
1. Mobile Computing, KumkumGarg, Pearson Education, 2010

Course Outcomes (CO) : On completion of the course, students should be able to
Number CO Statement
CO1. Understand fundamentals of wireless communication
CO2. Analyze security, energy efficiency, mobility, scalability and their unique characteristics in wireless networks.
CO3. Demonstrate basic skills for cellular networks design.
CO4. Apply knowledge of TCP/IP extension for mobile and wireless networks.
CO5. Explain about GPS and GPRS.
PO - CO MAPPING MATRIX:
CO PO PSO
PO1 PO2 PO3 PO4 PO5 PSO1 PSO2 PSO3
CO1 3 2 3 2 - 3 2 2
CO2 2 2 2 2 - 3 3 3
CO3 3 2 2 2 - 3 2 2
CO4 2 2 2 2 - 3 2 2
CO5 3 3 3 3 1 3 3 3
Hours/Week 5 Credits 5
Semester VI

Objective:To provide the basic concepts of the Database Systems including Data Models, Storage Structure, Normalization and SQL

Unit I: Introduction: Database-System Applications- Purpose of Database Systems - View of Data --Database Languages - Relational Databases - Database Design -Object-Based and Semi structured Databases - Data Storage and Querying Transaction Management -Data Mining and Analysis - Database Architecture - Database Users and Administrators - History of Database Systems.
Unit II: Relational Model: Structure of Relational Databases - Fundamental Relational-Algebra Operations Additional Relational-Algebra Operations- Extended Relational-Algebra Operations - Null Values - Modification of the Database.
Unit III: SQL: Data Definition - Basic Structure of SQL Queries - Set Operations-Aggregate Functions - Null Values- Nested Subqueries - Complex Queries - Views -Modification of the Database - Joined Relations - SQL Data Types and Schemas - Integrity Constraints -Authorization - Embedded SQL d Data
Unit IV: Relational Languages: The Tuple Relational Calculus - The Domain Relational Calculus - Query-by- Example. Database Design and the E-R Model: Overview of the Design Process - The Entity-Relationship Model - 3 Constraints - Entity-Relationship Diagrams - Entity-Relationship Design Issues - Weak Entity Sets - Database Design for Banking Enterprise
Unit V: Relational Database Design: Features of Good Relational Designs - Atomic Domains and First Normal Form - Decomposition Using Functional Dependencies - Functional-Dependency Theory - Decomposition Using Functional Dependencies - Decomposition Using Multivalued Dependencies-More Normal Forms - Database-Design Process
TEXT BOOKS:
1. Database System Concepts, Sixth edition, Abraham Silberschatz , Henry F. Korth, S. Sudarshan, McGraw-Hill-2010.
REFERENCE BOOKS:
1. Database Systems: Models, Languages, Design and Application, Ramez Elmasri, Pearson Education, 2014.

Course Outcomes (CO) : On completion of the course, students should be able to
Number CO Statement
CO1. Principles of DBMS - (DML,DDl,TCL)
CO2. Understanding normalization namely first normal form, second normal form, third normal form, BCNF.
CO3. To identify the different types of Keys(foreign key,super key)
CO4. Explain the functional dependencies and multi-valued dependencies
CO5. Identify the ER- Diagram, Relationship concepts and fundamentals of relational algebra and calculus.
PO - CO MAPPING MATRIX:
CO PO PSO
PO1 PO2 PO3 PO4 PO5 PSO1 PSO2 PSO3
CO1 2 3 3 1 3 3 1 2
CO2 2 3 2 2 2 3 2 3
CO3 1 2 1 1 1 3 1 2
CO4 2 1 2 2 1 3 2 3
CO5 2 2 2 1 2 3 2 1
Hours/Week 3 Credits 2
Semester VI

Objective: To Impart Practical Training in MySQL

1. Create a table and perform the following basic mysql operations
a) Set the primary key
b) Alter the structure of the table
c) Insert values
d) Delete values based on constraints
e) Display values using various forms of select clause
f) Drop the table

2. Develop mysql queries to implement the following set operations
a) Union
b) Union all
c) Intersect
d) Intersect all

3. Develop mysql queries to implement the following aggregate functions
a) Sum
b) Count
c) Average
d) Maximum
e) Minimum
f) Group by clause & having clause

4.Develop mysql queries to implement following join operations
a) Natural join
b) Inner join
c) Outer join-left outer, right outer, full outer
d) Using join conditions

5. Develop mysql queries to implement nested subqueries
a) Set membership (int, not int)
b) Set comparison (some, all)
c) Empty relation (exists, not exists)
d) Check for existence of Duplicate tuples(unique, not unique)

6. Develop mysql queries to create a views and expand it.

7. Develop mysql queries to implement
a) String operations using %
b) String operations using ‗_‘
c) Sort the element using asc,desc
[*create necessary reletions with requires attribute]

8. Consider the following database for a banking enterprise
BRANCH(branch-name:string, branch-city:string, assets:real)
ACCOUNT(accno:int, branch-name:string, balance:real)
DEPOSITOR(customer-name:string, accno:int)
CUSTOMER(customer-name:string, customer-street:string, customercity:string)
LOAN(loan-number:int, branch-name:string, amount:real)
BORROWER(customer-name:string, loan-number:int)
i. Create the above tables by properly specifying the primary keys and the foreign keys
ii. Enter at least five tuples for each relation
iii. Find all the customers who have at least two accounts at the Main branch.
iv. Find all the customers who have an account at all the branches located in a specific city.
v. Demonstrate how you delete all account tuples at every branch located in a specific city.
vi. Generate suitable reports.
vii. Create suitable front end for querying and displaying the results

Course Outcomes (CO) : On completion of the course, students should be able to
Number CO Statement
CO1. Create, alter and drop structure of a database using different constraints.
CO2. Insert, modifying and deleting of a particular or group records.
CO3. Select statement using aggregate functions, join operations, sorting, nested Sub queries.
CO4. Join Operations, Nested Sub queries.
CO5. Views.
PO - CO MAPPING MATRIX:
CO PO PSO
PO1 PO2 PO3 PO4 PO5 PSO1 PSO2 PSO3
CO1 2 1 2 2 3 3 2 2
CO2 2 1 2 2 3 3 2 2
CO3 2 1 2 2 3 3 2 2
CO4 2 1 2 2 2 3 3 2
CO5 2 1 2 2 2 3 3 3
Hours/Week 6 Credits 6
Semester VI

Objective: To understand the Concepts of PHP and Ajax.

Unit I: Essentials of PHP - Operators and Flow Control - Strings and Arrays.
Unit II: Relational Model: Structure of Relational Databases - Fundamental Relational-Algebra Operations Additional Relational-Algebra Operations- Extended Relational-Algebra Operations - Null Values - Modification of the Database.
Unit III: Object-Oriented Programming –Advanced Object-Oriented Programming.
Unit IV: File Handling –Working with Databases – Sessions, Cookies, and FTP.
Unit V: Ajax – Advanced Ajax – Drawing Images on the Server.
TEXT BOOKS:
1. The PHP Complete Reference, Steven Holzner, McGraw Hill Education, 2007
REFERENCE BOOKS:
1. PHP: A Beginner's Guide, Vikram Vaswani, McGraw Hill Education, 2008

Course Outcomes (CO) : On completion of the course, students should be able to
Number CO Statement
CO1. Basic Program creation idea with logic.
CO2. Logical and looping statement knowledge.
CO3. Update the knowledge of basic concept of oops and Advanced oops concepts.
CO4. Gather knowledge for creating web forms and read the data from the web forms also storewith database.
CO5. Basic idea and concept for drawing through coding and fundamental knowledge of AJAX.
PO - CO MAPPING MATRIX:
CO PO PSO
PO1 PO2 PO3 PO4 PO5 PSO1 PSO2 PSO3
CO1 3 2 2 2 3 3 3 3
CO2 2 3 2 2 2 3 2 2
CO3 3 2 2 3 3 3 2 1
CO4 3 3 3 3 3 3 1 3
CO5 2 2 1 2 2 3 2 1
Hours/Week 6 Credits 6
Semester VI

Students are asked to do a project work in a group of maximum of 4 members. They can take any commercial application as their project and will collect the data from the concerned firm or organization. At the end of the project they will submit a report about the project. Internal Guides will be allocated for the students to undergo and clarify the doubts about the project. Viva voce exam will conducted at the end of the semester by the external and internal examiners.

Course Outcomes (CO) : On completion of the course, students should be able to
Number CO Statement
CO1. Develop a functional application based on the software design
CO2. Apply coding, debugging and testing tools to enhance the quality of the software
CO3. Construct new software system based on the theory and practice gained through this exercise
CO4. Prepare the proper documentation of software projects following the standard guidelines
CO5. Learn technical report and oral presentation skills
PO - CO MAPPING MATRIX:
CO PO PSO
PO1 PO2 PO3 PO4 PO5 PSO1 PSO2 PSO3
CO1 3 3 3 3 3 3 3 2
CO2 2 2 2 3 2 3 3 2
CO3 2 3 3 2 2 3 3 3
CO4 3 2 3 2 3 3 3 3
CO5 2 3 3 2 3 3 3 2