academic regulations syllabus - charusat · pdf fileacademic regulations & syllabus...

ACADEMIC

REGULATIONS &

SYLLABUS

Faculty of Computer Science & Applications

Master of Computer Applications Programme

CHAROTAR UNIVERSITY OF SCIENCE & TECHNOLOGY

Education Campus – Changa, (ECC), hitherto a conglomerate of institutes of professional

education in Engineering, Pharmacy, Computer Applications, Management, Applied Sciences,

Physiotherapy and Nursing, is one of the choicest destinations by students. It has been

transformed into Charotar University of Science and Technology (CHARUSAT) through an

Act by Government of Gujarat. CHARUSAT is permitted to grant degrees under Section-22 of

UGC- Govt. of India.

The journey of CHARUSAT started in the year 2000, with only 240 Students, 4 Programmes,

one Institute and an investment of about Rs.3 Crores (INR 30 million). At present there are

seven different institutes falling under ambit of six different faculties. The programmes offered

by these faculties range from undergraduate (UG) to Ph.D. degrees. These faculties, in all offer

64 different programmes. A quick glimpse in as under:

Faculty Institute Programmes Offered

Faculty of Technology & Engineering

Charotar Institute of Technology

B. Tech M. Tech MTM Ph. D

Faculty of Pharmacy Ramanbhai Patel College of Pharmacy

B. Pharm M. Pharm MPM PGDCT/ PGDPT Ph. D

Faculty of Management Studies Indukaka Ipcowala Institute of Management

M.B.A PGDM Dual Degree BBA+MBA Ph.D


Smt. Chandaben Mohanbhai Patel Institute of Computer Applications

MCA/MCAL M.Sc. (IT) Dual Degree BCA+MCA Ph. D.

Faculty of Applied Sciences P.D.Patel Institute of Applied Sciences

M.Sc Dual Degree B.Sc+M.Sc Ph.D

Faculty of Medical Sciences

Ashok and Rita Institute of Physiotherapy Manikaka Topawala Institute of Nursing Charotar Institute of Paramedical Sciences

B.PT M.PT Ph.D B.Sc (Nursing) M.Sc PGDHA PGDMLT GNM Ph.D

The development and growth of the institutes have already led to an investment of over Rs.125

Crores (INR 1250 Million). The future outlay is planned with an estimate of Rs.250 Crores (INR

2500 Million).

The University is characterized by state-of-the-art infrastructural facilities, innovative teaching

methods and highly learned faculty members. The University Campus sprawls over 105 acres of

land and is Wi-Fi enabled. It is also recognized as the Greenest Campus of Gujarat.

CHARUSAT is privileged to have 360 core faculty members, educated and trained in IITs, IIMs

and leading Indian Universities, and with long exposure to industry. It is also proud of its past

students who are employed in prestigious national and multinational corporations.

From one college to the level of a forward-looking University, CHARUSAT has the vision of

entering the club of premier Universities initially in the country and then globally. High Moral

Values like Honesty, Integrity and Transparency which has been the foundation of ECC

continues to anchor the functioning of CHARUSAT. Banking on the world class infrastructure

and highly qualified and competent faculty, the University is expected to be catapulted into top

20 Universities in the coming five years. In order to align with the global requirements, the

University has collaborated with internationally reputed organizations like Pennsylvania State

University – USA, University at Alabama at Birmingham – USA, Northwick Park Institute –UK,

ISRO, BARC, etc.

CHARUSAT has designed curricula for all its programmes in line with the current international

practices and emerging requirements. Industrial Visits, Study Tours, Expert Lectures and

Interactive IT enabled Teaching Practice form an integral part of the unique CHARUSAT

pedagogy.

The programmes are credit-based and have continuous evaluation as an important feature. The

pedagogy is student-centred, augurs well for self-learning and motivation for enquiry and

research, and contains innumerable unique features like:

• Participatory and interactive discussion-based classes.

• Sessions by visiting faculty members drawn from leading academic institutions and

industry.

• Regular weekly seminars.

• Distinguished lecture series.

• Practical, field-based projects and assignments.

• Summer training in leading organizations under faculty supervision in relevant

programmes.

• Industrial tours and visits.

• Extensive use of technology for learning.

• Final Placement through campus interviews.

Exploration in the field of knowledge through research and development and comprehensive

industrial linkages will be a hallmark of the University, which will mould the students for global

assignments through technology-based knowledge and critical skills.

The evaluation of the student is based on grading system. A student has to pursue his/her

programme with diligence for scoring a good Cumulative Grade Point Average (CGPA) and for

succeeding in the chosen profession and life.

CHARUSAT welcomes you for a Bright Future

CHAROTAR UNIVERSITY OF SCIENCE & TECHNOLOGY


ACADEMIC REGULATIONS Master of Computer Applications (MCA) Programme

Charotar University of Science and Technology (CHARUSAT) CHARUSAT Campus, At Post: Changa – 388421, Taluka: Petlad, District: Anand

Phone: 02697-247500, Fax: 02697-247100, Email: [email protected] www.charusat.ac.in

Year – 2013-2014

CHARUSAT

FACULTY OF COMPUTER SCIENCE AND APPLICATIONS ACADEMIC RULES

Master of Computer Applications (MCA) Programme

To ensure uniform system of education, duration of post graduate programmes, eligibility criteria for and mode of admission, credit load requirement and its distribution between course and system of examination and other related aspects, following academic rules and regulations are recommended.

1. System of Education The Semester system of education should be followed across the Charotar University of Science and Technology (CHARUSAT) at Master’s levels. Each semester will be at least 90 working days duration. Every enrolled student will be required to take a specified load of course work in the chosen subject of specialization and also complete a project/dissertation if any. 2. Duration of Programme

(i) Postgraduate programme Master of Computer Applications (M.C.A.)

Minimum 6 semesters (3 academic years) Maximum 10 semesters (5 academic years)

3. Eligibility & Mode of admissions Eligibility of a candidate and mode of admission to the programme will be according to

the regulations for admission committee decided by Government of Gujarat from time to time.

4. Programme structure and Credits A student admitted to a program should study the course and earn credits specified in the course structure.

5. Attendance 5.1 All activities prescribed under these regulations and listed by the course faculty

members in their respective course outlines are compulsory for all students pursuing the courses. No exemption will be given to any student from attendance except on account of serious personal illness or accident or family calamity that may genuinely prevent a student from attending a particular session or a few sessions. However, such unexpected absence from classes and other activities will be required to be condoned by the Dean/Principal.

5.2 Student attendance in a course should be 80%. 6 Course Evaluation 6.1 The performance of every student in each course will be evaluated as follows:

6.1.1 Internal evaluation by the course faculty member(s) based on continuous assessment, for 30% of the marks for the course; and

6.1.2 Final examination by the University through written paper or practical test or oral test or presentation by the student or a combination of any two or more of these, for 70% of the marks for the course.

6.2 University Examination

6.2.1 The final examination by the University for 70% of the evaluation for the course will be through written paper or practical test or oral test or presentation by the student or a combination of any two or more of these.

6.2.2 In order to earn the credit in a course a student has to obtain grade other than FF.

6.3 Performance at Internal & University Examination 6.3.1 Minimum performance with respect to internal marks as well as university

examination will be an important consideration for passing a course. Details of minimum percentage of marks to be obtained in the examinations (internal/external) are as follows

Minimum marks in University Exam per subject (Theory and Practical )

Minimum marks Overall per subject

40% 50%

6.3.2 If a candidate obtains minimum required marks per subject but fails to obtain minimum required overall marks, he/she has to repeat the university examination till the minimum required overall marks are obtained.(As per the clause 8.2(vii)

7 Grading

7.1 The total of the internal evaluation marks and final University examination marks in each course will be converted to a letter grade on a ten-point scale as per the following scheme:

Grading Scheme (PG)

Range of Marks (%) ≥80 ≥75 <80

≥70 <75

≥65 <70

≥60 <65

≥55 <60

≥50 <55

<50

Letter Grade AA AB BB BC CC CD DD FF Grade Point 10 9 8 7 6 5 4 0

7.2 The student’s performance in any semester will be assessed by the Semester Grade

Point Average (SGPA). Similarly, his performance at the end of two or more consecutive semesters will be denoted by the Cumulative Grade Point Average (CGPA). The SGPA and CGPA are defined as follows:

(i) SGPA = ∑ Ci Gi / ∑ Ci where Ci is the number of credits of course i

Gi is the Grade Point for the course i and i = 1 to n, n = number of courses in the

semester

(ii) CGPA = ∑ Ci Gi / ∑ Ci where Ci is the number of credits of course i Gi is the Grade Point for the course i

and i = 1 to n, n = number of courses of all semesters up to which CGPA is computed.

(iii) No student will be allowed to move further if CGPA is less than 3 at the end of every academic year.

(iv) A student will not be allowed to move to third year if he/she has not cleared all the courses of first year.

(v) In addition to above, the student has to complete the required formalities as per the regulatory bodies.

8 Awards of Degree 8.1 Every student of the programme who fulfils the following criteria will be eligible for the

award of the degree: 8.1.1 He should have earned at least minimum required credits as prescribed in course

structure; and 8.1.2 He should have cleared all evaluation components in every course; and

8.1.3 He should have secured a minimum CGPA of 5.0 at the end of the programme;

8.2 The student who fails to satisfy minimum requirement of CGPA will be allowed to improve the grades so as to secure a minimum CGPA for the award of degree. Only latest grade will be considered.

9 Award of Class:

The class awarded to a student in the programme is decided by the final CGPA as per the following scheme: Distinction: CGPA ≥ 7.5 First class: CGPA≥ 6.0 Second Class: CGPA≥ 5.0

10 Transcript: The transcript issued to the student at the time of leaving the University will contain a consolidated record of all the courses taken, credits earned, grades obtained, SGPA,CGPA, class obtained, etc.

TEACHING SCHEME

FOR

MCA PROGRAMME (1ST, 2ND & 3RD YEAR)

EFFECTIVE FROM ACADEMIC YEAR 2013‐14

Teaching and Examination Schememe for (MCA Programme) Effective from Academic Year 2013‐14

MCA Semester I Course Code

Course Title Teaching Scheme Examination Scheme Contact Hours Credit Theory Practical Total

Theory Pract Total Internal Exter nal

Internal Exter nal Case

Study Tests Term

work Tests

CA709 Introduction to Computers 4 3 7 7 10 20 70 15 15 70 200 CA710 Fundamental Concepts

in Programming Language

4 3 7 7 10 20 70 15 15 70 200

CA711 Database Technologies 4 3 7 7 10 20 70 15 15 70 200 CS702 Business Communication

Skills 4 ‐ 4 4 10 20 70 ‐ ‐ ‐ 100

FI702 Fundamental of Commerce and Business Statistics

4 ‐ 4 4 10 20 70 ‐ ‐ ‐ 100

Seminar ‐ 1 1 1 ‐ ‐ ‐ ‐ ‐ ‐ ‐ 20 10 30 30 500 300 800

Effective from Academic Year 2013‐14 MCA Semester II

Course Code

Course Title Teaching Scheme Examination Scheme Contact Hours Credit Theory Practical Tot

al Theory Pract Total

Internal Exter nal


Study Tests Term

work Tests

CA712 Introduction to Internet and Web Designing

4 3 7 7 10 20 70 15 15 70 200

CA713 Object Oriented Concepts and Programming

4 3 7 7 10 20 70 15 15 70 200

CA714 Management Information Systems

4 ‐ 4 4 10 20 70 ‐ ‐ ‐ 100

CA715 Operating System Concepts and Network Technology

4 ‐ 4 4 10 20 70 ‐ ‐ ‐ 100

CS703 Technical writing and content management

4 ‐ 4 4 10 20 70 ‐ ‐ ‐ 100

Seminar ‐ 2 2 2 ‐ - ‐ - ‐ - ‐

Remedial Session / Quizzes / Case Study Preparation **

‐ 2 2 2 ‐ - ‐ - ‐ - ‐

20 10 30 30 500 200 700

Effective from Effective from Academic Year 2013‐14

MCA Semester III

Course Code


al Theory

Pract Total

Internal Exter nal


Study Tests Term

work Tests

CA814 Object Oriented Software Engineering

4 ‐ 4 4 10 20 70 ‐ ‐ ‐ 100

CA815 Enterprise Computing 4 3 7 7 10 20 70 15 15 70 200 CA816 Visual Programming 4 3 7 7 10 20 70 15 15 70 200 CA817 Web Designing concepts 4 3 7 7 10 20 70 15 15 70 200 CA818 Advanced Database

Technologies 4 3 7 7 10 20 70 15 15 70 200

20 12 32 32 500 400 900


MCA Semester IV

Course Code



Internal Exter nal


Study Tests Term

work Tests

CA819 Open Source Technology

4 3 7 7 10 20 70 15 15 70 200

CA820 Mobile Application Technology

4 3 7 7 10 20 70 15 15 70 200

CA821 Software Quality Assurance

4 3 7 7 10 20 70 15 15 70 200

CA822 CA825

Elective 1 4 3 7 7 10 20 70 15 15 70 200

16 12 28 28 400 400 800

Electives Set 1

1. CA822‐Windows Communication Foundation Framework 2. CA823‐Frameworks and Applications 3. CA824‐Procurement, Implementation and Management of IT systems. 4. CA825‐Advanced Network Management and Security

MCA Semester V Effective from Effective from Academic Year 2013‐14

Course Code



Internal Exter nal


Study Tests Term

work Tests

CA910 Open Source Frameworks 4 3 7 7 10 20 70 15 15 70 200 CA911 Data Mining and Analytics 4 3 7 7 10 20 70 15 15 70 200 CA912 Mini Project ‐ 6 6 6 ‐ ‐ ‐ 30 70 100 CA913‐CA916

Elective 2 4 3 7 7 10 20 70 15 15 70 200

Seminar ‐ 2 2 2 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Remedial Session / Quizzes /

Case Study Preparation ** ‐ 1 1 1 ‐ ‐ ‐ ‐ ‐ ‐ ‐

12 18 30 30 300 400 700

Elective Set 2

1. CA913‐ Collaboration Technologies (ONLY for students who have completed Windows Communication Foundation Framework offered in Elective Set 1)

2. CA914‐Web Technologies (ONLY for students who have completed Frameworks and Applications offered in Elective Set 1)

3. CA915‐Advance MIS 4. CA916‐Intrusion Detection and Computer Forensics

MCA Semester VI Effective from Effective from Academic Year 2013‐14

Course Code Course Name

Teaching Scheme Internal End Semester Examination Total Contact Hours Credit Continuous

Evaluation Report Presentation & Viva

CA917 Project Work

Inst. Industry Total

2

28

30 30 200 200

400 800

OBJECTIVES, TEACHING SCHEME & DETAILED SYLLABUS

FOR

MCA PROGRAMME (1ST SEMESTER)


Effective from Academic Year 2013‐14 Course Code

Course Title Teaching Scheme Examination Scheme Contact Hours Credit Theory Practical Total

Theory Pract Total Internal Exter nal


Study Tests Term

work Tests

CA709 Introduction to Computers 4 3 7 7 10 20 70 15 15 70 200 CA710 Fundamental Concepts

in Programming Language

4 3 7 7 10 20 70 15 15 70 200

CA711 Database Technologies 4 3 7 7 10 20 70 15 15 70 200 CS702 Business Communication

Skills 4 ‐ 4 4 10 20 70 ‐ ‐ ‐ 100

FI702 Fundamental of Commerce and Business Statistics

4 ‐ 4 4 10 20 70 ‐ ‐ ‐ 100

Seminar ‐ 1 1 1 ‐ ‐ ‐ ‐ ‐ ‐ ‐ 20 10 30 30 500 300 800

CA709:Introduction to Computer (Marks 200)

Credit Hours: 07 Objective: The objective of this course is to develop the understanding of the elements of Computer Organization and Architecture, build the Mathematical foundations for understanding the hardware operations of digital computers, to provide working knowledge of operating systems which is crucial in effective operation and use of one’s computer system. Understand network communications from the viewpoint of the 7 standard layers, to make them acquainted with Office automation software on Windows platform and to develop ability to design static and simple dynamic web pages. Pre‐ requisite: No additional pre‐requisite required. Methodology & Pedagogy: During theory lectures the emphasis will be given on the Mathematical foundations required to understand the basic operations of the Computers. Students will be introduced to the basic operating system concepts. The ISO/OSI 7‐layered model for understanding network communications will be discussed. The HTML and ASP semantics will be explained to develop the web pages and basic knowledge of web browsers and Internet concepts will be covered. During Practical sessions students will be made familiar with the working of various software packages for communication and analysis of data and web pages development using HTML. Outline of the Course:

Unit No.

Title of the Unit Minimum Numbers of hours Theory Practical

1 Representation of Information or Data Coding System

08

36

2 Boolean Algebra and Logic Gates or Basic Logic Design

10

3 ALU,CPU & Digital Components 10 4 Overview of OS & Networking 08 5 Introduction to Work Sheet 05 6 Introduction to HTML & ASP 07

Total Hours (Theory): 48

Total Hours (Lab): 36

Total: 84

Detailed Syllabus:

Unit – I: Representation of Information Hours: 08

Computer Organization: basic components of the computers and their organization. Binary Operations: Addition, Subtraction, Multiplication, Division. r’s & (r‐1)’s Complements, Use of complements to represent Negative Number, Binary Number Complements, Complements in other Number Systems. Binary codes: Weighted and Non‐weighted codes, BCD Code, Excess Three (XS – 3) Code, Gray Code, Binary to Gray & Gray to Binary. Error detecting and correcting codes ‐Parity and Hamming code. Unit – II: Boolean Algebra and Logic Gates Hours: 10 Basic Laws of Boolean Algebra, Logical Multiplication, Evaluation of Logical Expressions, Simplification of Expressions, Basic duality of Boolean Algebra, Derivation of a Boolean Expression, Sum of Products and Product of Sums, Derivation of Product‐of‐Sums expressions, Derivation of Three input variable expressions, Proof by Perfect induction, De Morgan’s Theorems, Map Method for Simplifying Expressions, K‐map ( Four Variables) , Cubes & covering, Don’t Cares. Logical Gates: Basic Gates & its Truth Tables, Interconnecting gates, NAND & NOR gates, Combination Circuit Design Using NAND, NOR, NAND to AND & NOR to OR gate Networks. Universal gates Functionality Unit – III: ALU, CPU & Digital Components Hours: 10 The Arithmetic‐Logic Unit: Flip‐Flops , Transfer Circuit , Clocks , Flip‐Flop Designs , Gated Flip‐Flop , Master Slave Flip‐Flop , Shift Register , Binary Counter , BCD Counter, Binary Half‐Adder, Full‐Adder Central Processing Unit: Stack Organization (Intro.), Instruction Formats, Addressing modes. Digital Components: Integrated Circuits, Decoders, NAND gate Decoder, Encoders, Multiplexers, Memory Units, Random‐Access Memory, Read Only Memory, and Types of ROMs. Input‐Output Organization: Peripheral Devices, Asynchronous Data Transfer, Handshaking, Modes of Transfer, Programmed I/O, Interrupt‐initiated I/O, Direct Memory Access (DMA), Memory Access (DMA). Unit – IV: Introduction to OS & Networking Hours: 08 Operating System Overview: OS objectives and functions (OS as User/Computer interface, OS as Resource Manager) Evolution of OS (Serial Processing, Simple Batch Systems, Multiprogrammed Batch Systems, Time Sharing Systems) Networking: Introduction (Business Applications, Home Applications, Mobile Users), Network Hardware (LAN, WAN, MAN, Wireless Networks, Home Networks, Internetworks), Software

(Protocol Hierarchy, Connection‐Oriented and Connectionless Services), Reference Model ( The OSI Model , The TCP/IP mode Unit – V: Introduction to Work Sheet Hours: 05 Worksheet Basics: Creating worksheet, entering data into worksheet, heading information, data text, and alphanumeric values, saving & quitting worksheet. Opening and moving around in an existing worksheet. Toolbars and Menus, Keyboard Shortcuts. Working with single and multiple workbooks: Copying, renaming, moving, adding and deleting, copying entries and moving between workbooks. Working with formulae & cell referencing. Performing Auto sum, copying formulae. Absolute & Relative Addressing. Editing & Formatting: Creating, editing and selecting ranges. Formatting of worksheet –Auto format, changing alignment, character styles, column width, date format, borders & colors, currency sign. Entering and erasing data, resizing rows and columns, conditional formatting, adding comments. Graphs and charts: Using wizards, various charts type, formatting grid lines & legends, previewing & printing charts. Database: Creation, sorting, query & filtering a database. Functions: Database, Date, and Time, Maths & Trigonometry, Statistical, Text and Logical Function. Advanced Features: Creating and Using Macros. Pivot Tables and Pivot Charts, using Pivot Table Wizard. Creating one‐variable and two‐variable data tables. What‐if analysis using Goal seek and Scenario. Working with Add‐ins, protecting and unprotect a worksheet and a workbook. Unit – VI: Introduction to HTML & ASP Hours: 07 Introduction to HTML and HTML5: Creating HTML pages, forms using various controls‐ text boxes, radio buttons, creating tables, creating frames, formatting page with background color, fonts, images, Brief overview of HTML5 Introduction to ASP: Creating Dynamic Web Forms using Request Object, Response Object, server object and overview of application and session object. Core books: 1. Thomas C. Bartee: Digital Computer Fundamentals, 6th Edition, Tata McGraw Hill, 1985 2. M. Morris Mano: Computer System Architecture, PHI / Pearson Education, 3rd Edition, PHI / Pearson Education,,1993 3. William Stallings: Operating Systems Internals and Design Principles, 5th Edition, PHI, 2005. 4. A.S. Tanenbaum: Computer Networks, Fourth Edition, Pearson Education , 2003.

Reference Books: 1. A. Anand Kumar: Fundamentals of Digital Circuits, PHI / Pearson Education,2nd Edition 2. Silberschatz: Operating System Concepts, 5th Edition, John Wiley & Sons (ASIA) Pte Ltd.,

1998. 3. Microsoft office 2003 bible by Edward c. willett, wiley‐dreantech India pvt. Ltd., wiley‐

india publications. 4. Internet: the complete reference, millennium edition by Margaret Levine yioung, Doug

muder, tata McGraw hill publishing company, New Delhi. 5. Mastering frontpage‐2000, Daniel a. tauber, Brenda kienal & molly e. holzsclag, BPB

publications. 6. Mastering Active Server Pages 3, A .Russell Jones,BPB Publications.

Web References: 1. http://www.whatwg.org/ 2. http://www.w3schools.com

CA710:Fundamental Concepts in Programming Language (Marks 200)

Credits Hours : 07

Objective: • Understand the significance of an implementation of a programming language in a

compiler or interpreter. • Increase the capacity to express programming concepts and choose among alternative

ways to express things. • How to define problem and solution outline. Logic developments tools, Testing of Logic,

C Programming Language concepts. • How to Compile, Run and Document the program. • To make students understand the simple programming paradigms and to develop in the

students the ability to design an appropriate logic to solve a specific problem requiring these paradigms and to implement such logic using “C” computer language as a tool.

Pre‐requisite: None. Methodology & Pedagogy: During theory lectures illustrations of certain real world problems, which are to be solved using computers, will be discussed. Logic development tools will be introduced for solving such problems and “C” computer language will be introduced as a tool. During Practical sessions, students will be required to Develop Computer programs in “C” in order to solve moderate size real world problems. Outline of the Course:

Unit No.

Title of the Unit Minimum Numbers of hours

Theory Practical 1 Introduction to Programming and Overview of ‘C’ 7

36

2 Basic Concepts 7 3 Conditional Branching, Iterative Execution and

Function 9

4 Array, Handling of Character string, Structure, Union, User defined data types, Enumerations and Bit fields

10

5 Pointer 6 6 Implementation of General Data Structures. 9



Total: 84

Detailed Syllabus :

Unit – I: Introduction to Programming and Overview of ‘C’ Hours :07

• Programming, PL Generations, Compiler, Interpreter, Linker & Loader. • Classification of Programming Language, Structured Programming concepts. • Algorithmic Presentation of Problem, Development of Algorithm. • Introduction to Programming language “C”, Structure of “C” Program, Simple C Program

Unit – II: Basic Concepts Hours: 07

• Understanding of Identifier, token, Keywords. • Basic data type in C. • Declaration and use of variable and constant. • Storage Class and lifetime of variable. • Basic Screen and keyboard I/O in C, Formatted and non‐formatted I/O function. • Operators: Arithmetical, Assignment, Equality, Relational, Logical and Bit‐wise.

Unit – III: Conditional Branching, Iterative Execution and Function Hours:09

• Introduction of branching, iteration and jumping. • Test condition and test expression. • Conditional execution and selection. • Iteration and repetitive execution. • Special control statements. • Function – concepts, scope and storage classes. • Function and its categories. • Recursion

Unit – IV: Array, Handling of Character string, Structure, Union, User defined data types, Enumerations and Bitfields. Hours: 10

• Array: One dimensional, two dimensional and multi dimensional. • One dimensional character array and character string. • String manipulation functions. • User defined data types using structure and union. • Enumeration types. • Bitfields.

Unit – V: Pointer. Hours: 06

• Understanding of memory address and address operator (&). • Void pointer, null pointer. • Use of pointer:

o Array and pointer. o Pointer and String. o Pointer Arithmetic. o Pointer to Pointer. o Pointer to function. o Pointer to Array and String.

• Concepts of Dynamic memory allocation.

Unit – VI: Implementation of General Data Structures. Hours: 09

• Sorting and Searching Array: Selection and Insertion sort, Linear and Binary Search. • Stack:

o Definition and Examples. o Representing Stack using static implementation. o Stack operations. o Representation of Infix, Prefix and postfix Expressions using stack. o Converting from one form to another, Expression Evaluation, Matching

parentheses. • Queues:

o Definition and examples. o Representing Queues using static implementation. o Circular queues. o Priority queues. o Double‐ended queues.

Core Books: 1. Pradip Dey and Manas Gosh: Programming in “C”, 1st Edition, Oxford, 2007. 2. Brian Kernighan and Dennis Ritchie: C Programming Language, 2nd Edition, Pentice‐hall publication. 3. R.G.Dromey: How to Solve it By Computer, Pentice‐hall publication. 4. Behrouz A. Foruuzan & Richard F.: A Structured programming Approach Using “C”, 3rdEdition, Course Technology.

Reference Books:

1. Jean‐paul Trembly and Paul Sorenson: An Introduction to data structure with applications, 2nd Edition, 1984.

2. Yashwant Kanitkar: Let us C, 8th Edition, BPB Publication. 3. Herbert Schildt: C‐ The Complete Reference, Tata McGraw Hill 4. E.Balagurusamy: Programming in ANSI C, 4th Edition, Tata McGraw Hill, 2007.

Web References:

1. http://ocw.mit.edu/courses/electrical‐engineering‐and‐computer‐science/6‐087‐practical‐programming‐in‐c‐january‐iap‐2010/index.htm

2. http://net.pku.edu.cn/~course/cs101/2008/resource/The_C_Programming_Language.pdf

CA711:Database Technologies (Marks 200)

Credits Hours : 07 Objectives: The Objectives of this course are: This course is intended to emphasis the importance of the role of data, file management and database systems in information systems. To make students understand the database development activities, such as, data modeling, creation of databases and posing complex SQL queries during the system development cycle. Also, introduce the students to using and implementing Database systems for certain commercial applications Prerequisites: Basic Knowledge of working with Computer. Methodology & Pedagogy: During theory lectures, concepts that are used in real world database applications will be discussed with necessary examples. During the laboratory hours students will implement the concepts that are discussed during lecture by using RDBMS system or high level language. Learning Outcomes: At the end of the course, the students will be able to understand the basic topics in database development and management. Upon successful completion of the course, the students will also be able to handle multiple transactions effectively. Students shall be able to learn and apply the basic database concepts in real world applications. Outline of the Course:

Unit No.


1 Introduction to database management system

09

36

2 Database Processes and parallel architecture

06

3 Relation Query Processor 08 4 Join Algorithms 06 5 Transaction, Concurrency control 07 6 Transaction Recovery 09



Total: 84

Detailed Syllabus:

Unit – I: Introduction to database management system. Hours: 09 Overview of database system, Different models of database systems, Schema Design, Relational Algebra Unit – II: Database Processes and parallel architecture. Hours: 06 Uniprocessor and lightweight threads , DBMS Threads, Admission Control, Shared memory, Shared Nothing, Shared Disk, NUMA, DBMS threads and multi processors Unit – III: Relation Query Processor. Hours: 08 Query parsing and authorization, Query rewrite, Query Optimizer, Query executer, Access methods, Indexing and Access. Unit – IV: Join Algorithms. Hours: 06 Introduction to joins, Different join algorithms , Comparison of join algorithms, partitioning, Memory management strategies Unit – V: Transaction, Concurrency control Hours: 07 Introduction to transactions, Concurrency control, Serializability, Transaction schedules. Unit – VI: Transaction Recovery. Hours: 07 Introduction to ARIES,The Log, Other recovery related structures, The write ahead log protocol. Core Books: 1. Raghu Ramakrishnan, Johannes Gehrke; Database Management Systems, McGraw Hill

Publication. 2. Ramez Elmasri, Shamkant B. Navathe; Fundamentals of Database Systems 5th Ed., Pearson

Publication. Reference Books: 1. Abraham Silberschatz, Henry F. Korth, S. Sudarshan; Database System Concepts 6th Ed. ,

Mc Graw Hill

Papers:

1. Stonebraker, Michael, and Joseph Hellerstein. "What Goes Around Comes Around." In

Readings in Database Systems 2. Codd, E. F. "A Relational Model of Data for Large Shared Data Banks." Communications of

the ACM 13, no. 6 (1970): 377‐387 3. Hellerstein, Joseph, Michael Stonebraker, and James Hamilton. "Architecture of a Database

System." Foundations and Trends in Databases 1, no. 2 (2007): 141‐259 4. Shapiro, L. D. "Join Processing in Database Systems with Large Main Memories. 5. Franklin, Michael. "Concurrency Control and Recovery." The Computer Science and

Engineering Handbook, 1997 6. Mohan, C., et al. "ARIES: A Transaction Recovery Method Supporting Fine‐Granularity

Locking and Partial Rollbacks Using Write‐Ahead Logging." ACM Transactions on Database Systems 17, no. 1 (1992): 94‐162.

Web References:

1. http://www.university.youth4work.com/AMSSOI_Andhra‐Mahila‐Sabha‐School‐of‐Informatics/study/

2. https://sites.google.com/site/mahinidb/lecture‐notes

CS702:Business Communication Skills (Marks 100)

Credits Hours : 04

Objectives: 1. To enable the students to know the functional aspects of English language so that they can use it in their day to day life i.e, introductions, descriptions, offers and requests, routines etc. 2. To hone basic Communication Skills (Listening, Speaking, Reading, Writing) of the students by exposing them to the key communication techniques Pre‐requisite: No additional Pre‐requisite required Methodology & Pedagogy: Lectures will be taken in class room with the use of multi‐media presentations / black board work and mix of both. Some assignments and Presentation Tasks will be given. Students will also be engaged in interpersonal communication activities such as group discussion, role plays, simulations, just a minute sessions, etc. Outline of the Course: Unit No. Title of the Unit Minimum Numbers of hours

Theory Practical 1 Communication Skills – An Introduction 08

‐

2 Business and Report Writing 083 Presentation Skills 084 Listening and Reading Skills 085 Functional English 086 Group Dynamics: Leadership, Negotiation and

Decision Making 08


Total: 48

Detailed Syllabus :

Unit – I: Communication Skills – An Introduction. Hours: 08 Basics of communication, One‐way and two‐way communication, Ethos, Pathos, Logos and Kairos in communication, Achieving results through communication, Types of communication, Roadblocks that undermine ability to communicate effectively, Avoiding misunderstanding in communication, Using simple, concise and direct language ‐ Principles of communication, Verbal and Nonverbal communication , Kinesics and Proximics Unit – II: Business and Report Writing. Hours: 08 Writing to the audience’s needs, Writing persuasive, clear and concise messages, Letter Writing, Application Writing, Report Writing, Technical Description, Paragraph Development – Coherence: Topic Sentence, Supporting Sentence, Authentication and Examples Unit – III: Presentation Skills. Hours: 08 Sharpening public speaking skills: preparing, rehearsing and integrating, organizing key points into a coherent story, Dealing with nervousness and anxiety, Delivering dynamic, effective presentations that are concise and clear, Strong openings and closings: Some Techniques, Speaking publicly in a convincing, confident and concise style, Building rapport with the audience: eye contact, vocal delivery and body language, Some useful techniques: interactive questions, animations, visuals and multimedia etc Unit – IV: Listening and Reading Skills Hours: 08 Listening – Hearing, Overhearing, Listening for multiple points of view and purposes, Building trusting relationships and rapport through listening, Types of Listening, Barriers to effective listening, Overcoming the barriers Reading Skills: Comprehension, Types, Techniques: Skimming and Scanning, Reading for various purposes, Barriers to effective reading, Overcoming the barriers Unit – V: Functional English. Hours: 08 Introductions, Describing actions and processes, Ordering, offering, request, Getting /giving information, Routines / timetables, Making comparisons, Sharing interests and experiences Unit – VI: Group Dynamics: Leadership, Negotiation and Decision Making. Hours: 08 Group Communication and Dynamics, Leadership – an art, Qualities of a good leader, Styles and Types of Leadership, Discussions and Negotiations, Preparing for negotiation and finding solutions, Fallback situations and behavior in negotiation, Group decision making and group dynamics, Decision making techniques and strategies

Core Books: 1. Jones, Leo: Functions of English, Cambridge 1979. 2. Andrea J Rutherford: Basic Communication Skills for Technology, Pearson Education. 3. T M Farhathullah: Communication Skills for Technical Students, Orient Longman Reference books: 1. Abbs Brian & Ingrid Freebairn: Building Strategies, Longman 1979. 2. Jones, Leo: Notions of English, Cambridge 1982. 3. Robert O' Neill: "Kernel One" and "Kernel Two", Longman 1978 and 1982. 4. Peter Viney's & Hartley: "Streamline Departures" and "Streamline Connections" and "Streamline Destinations", Oxford 1978, 1979 and 1982. 5. Brian Abbs & Ingrid Freebairn: "Developing Strategies", "Studying Strategies" and "Opening Strategies, Longman 1980, 1981 & 1982 6. Michael Swann & Catherine Walter: "The Cambridge English Courses 1 & 2, Cambridge 1984

& 1985. 7. John & Liz Soars: "Headway Intermediate" & "Headway Upper Intermediate", Oxford 1984

And 1986 8. Robert O'Neill (and Patricia Mugglestone's): "Fourth Dimension" & "Third Dimension",

Longman 1986 & 1989 9. Allan Pease: Body Language, Sheldon Press, London) 10. Geoffrey Leech & Jan Swartvik: A Communicative Grammar of English, Longman. 11. K. R. Lakshminarayan: English for Technical Communication, Scitech Publications, Chennai. Web References: 1. http://www.bim.bilkent.edu.tr/~inanc/63223/lecturenotesmain.htm 2. http://templeok.webs.com/BussCommA_FullText.pdf 3. http://www.clrp.cornell.edu/workshops/pdf/communication_skills‐web.pdf

FI702: Fundamental of Commerce and Business Statistics (Marks 100)

Credits Hours : 04

Objectives: Make students familiar with the basic terminology of components of Commerce and business statistics useful in real applications. Pre‐requisite: No additional Pre‐requisite required. Methodology & Pedagogy: During theory sessions, the basic terminology along with concrete Illustrations will be discussed. Case study related to commerce and business statistics will be given to students based on some real application. Outline of the Course:

Unit No.


1 Basics of Accounts 09

‐

2 Cost Accounting 07

3 Business Organizations 08

4 Basic Statistics 05

5 Probability 08

6 Operations Research 11


Total: 48

Detailed Syllabus : Unit – I: Basics of Accounts Hours: 09 Double Entry Book‐keeping System: Recording Financial Transaction,Ledger posting, Preparation of Trial Balance, Preparation of Statutory Financial Statements, Analysis of Financial Statement Unit – II: Cost Accounting: Hours: 07 Meaning of Cost, Costing and Cost Accounting, Concept of Cost Centre and Cost Unit, Cost components and preparation of Cost sheet, Methods of Costing, Marginal Costing, Break‐even Analysis, Make or buy decision Unit – III: Business Organization Hours: 08 Forms of business organization, sole proprietorship firm, Partnership firm, Joint stock Company,Private Company, Public Company, Co‐operative Society, Public Trust, Association of Persons (Joint Venture) Unit – IV: Basic Statistics Hours: 05 Basic vocabulary of Statistics, Presenting Data in Tables and Charts, Difference between group and ungroup data. Measures of Central Tendency: Mean, Median, Mode for Group and Ungroup data. Measure of Dispersion: Range, Mean Absolute Deviation, Variance, and Standard Deviation for group data Unit – V: Probability Hours: 08 Basic concepts of Probability: Events, Sample spaces, Contingency Tables and Venn diagram, Simple Probability, Joint Probability, marginal Probability, Conditional probability Concept of Probability Distribution: Standard Probability Distributions: Binomial, Poisson, Exponential, and Normal Unit – VI: Operations Research Hours: 11 Overview of Operations Research: Features and Advantages of Operation Research. Linear Programming: Structure and mathematical model of linear programming Problem, Linear Programming Model Formulation: Graphical Method, Simplex method, Big‐M method, Duality in Linear Programming. Transportation Problem: Mathematical model of Transportation Model, Method for finding initial solution: NWCM method, LCM method, Vogel’s Approximate method and Modi method.

Assignment Problem: Mathematical model of assignment problem, Solution method of assignment problem‐ Hungarian method. Core Books: 1. Dr. S.N. Maheshwari: Financial Accounting, Sultan Chand publication. 2. Dr. S.N. Maheshwari: Advanced Accounting, Sultan Chand publication 3. M.N. Arora: Advanced Cost Accounting, Himalaya Publishing House 4. Levine, Krehbiel, Berenson, Viswanathan: Bussiness Statistics 5th Edition: Pearson 5. J.K.Sharma Operation Research: Theory and Applications:Macmillan Publishers.

Web References:

1. http://ocw.mit.edu/courses/sloan‐school‐of‐management/15‐511‐financial‐accounting‐ summer‐2004/lecture‐notes/

2. http://thestudentcpa.com/lecture‐notes‐college‐accounting‐study‐guides/ 3. http://cga.nic.in/pdf/management_accounting.pdf 4. http://ocw.mit.edu/courses/sloan‐school‐of‐management/15‐053‐optimization‐methods‐

in‐management‐science‐spring‐2007/lecture‐notes/


FOR

MCA PROGRAMME (2nd SEMESTER)


Effective from Academic Year 2013‐14 Course Code



Internal Exter nal


Study Tests Term

work Tests

CA712 Introduction to Internet and Web Designing

4 3 7 7 10 20 70 15 15 70 200

CA713 Object Oriented Concepts and Programming

4 3 7 7 10 20 70 15 15 70 200

CA714 Management Information Systems

4 ‐ 4 4 10 20 70 ‐ ‐ ‐ 100

CA715 Operating System Concepts and Network Technology

4 ‐ 4 4 10 20 70 ‐ ‐ ‐ 100

CS703 Technical writing and content management

4 ‐ 4 4 10 20 70 ‐ ‐ ‐ 100

Seminar ‐ 2 2 2 ‐ - ‐ - ‐ - ‐

Remedial Session / Quizzes / Case Study Preparation **

‐ 2 2 2 ‐ - ‐ - ‐ - ‐

20 10 30 30 500 200 700

CA712:Introduction to Internet and Web Designing (Marks 200)

Credit Hours : 07 Objectives: The objective of the course is to

• Understand basic concepts of Internet and Web • design and develop the professional web pages with client side scripting • how to specifically design web page to rank high in search engine

Prerequisites: N/A Methodology & Pedagogy: During theory sessions, topics related to web designing technologies will be covered with suitable examples. During Practical sessions, students will be required to design and develop entire web sites using several web designing technologies and editors. Learning Outcome: Upon successful completion of the course, students will understand basic concepts of internet and web page architecture and will be able to develop and host web site by using markup languages and advanced technologies, including HTML, JavaScript, DHTML and CSS. On completion, student will be able to design and create an advanced website and will be equipped to undertake complex internet projects. Outline of the Course: Unit No.

Unit Title Minimum number of hours

Theory Practical

1 Introduction to Internet Programming 07

36 Hours

2 Web Design using Hypertext Markup Language

09

3 Cascading Style Sheets 08 4 Java Script Programming ‐ I 09 5 Java Script Programming ‐ II 08 6 Introduction to Content Management System

& Search Engine Optimization 07



Total: 84

Detailed Syllabus: Unit – I : Introduction to Internet Programming Hours: 07 Overview of Internet and WWW, Basic elements of the Internet, Internet services, Internet Browsers and Servers, Hardware and Software requirements to connect to the internet, Internet Service Provider (ISP), Internet Addressing : standard Internet Address, Domain Name Server (DNS), Pseudo Internet Address, Introduction to Internet Protocols : TCP/IP, UDP, FTP, SMTP, POP3, MIME, SOAP, IPv4 and IPv6 Unit – II: Web Design using Hypertext Markup Language Hours: 09 Introduction to HTML, the structure and history of an HTML program, Role of editors to design web page, titles and footers, text formatting, text styles, other text effects, Lists, graphics, tables, linking documents, frames, forms, Semantic/Structural Elements, Media Elements, HTML Canvas Reference, Inline SVG, Image Maps Unit – III: Cascading Style Sheets Hours: 08 Introduction to Cascading Style Sheet (CSS), CSS essentials, CSS selectors, CSS Box Model, Backgrounds and Borders, Text Effects, Fonts, 2D/3D Transformations, Transitions, Animations, Multiple Column Layout, User Interface Unit – IV: Java Script Programming ‐ I Hours: 09 Introduction to Scripting Language and Client side Scripting, Basics of Java Script, Java Script Statements, Comments, Data Types, Objects, Operators and Expressions, Constructs, Conditional checking, Loops, Functions, Dialog boxes. Unit – V: Java Script Programming – II Hours: 08 The Java Document Object Model (DOM): Introduction, JSSS DOM, Objects in HTML, Object hierarchy, Event handling, Forms: Form object, built in objects, User defined objects, Cookies, Java Script Window DHTML: Introduction to DHTML, DHTML CSS, DHTML Java Script, DHTML HTML DOM, DHTML Events Unit – VI: Introduction to Content Management System & Search Engine Optimization Hours: 07 Introduction to Content Management System (CMS), CMS Types, CMS Working and CMS Applicability Web Promotion Search Engine Optimization: Using Good Keywords for Keyword Search, Creating the Title Tag and Meta Tags for Website, Optimizing Website for Search Engine ‐

Keyword Density and Content, Submitting Site to the Search Engines, Increase Rankings by Building Link Popularity Core Books:

1. The Internet Complete Reference, Second Edition – Harley Hahn, Tata MaGRAW‐HILL Edition.

2. HTML5: The Missing Manual ‐ Matthew MacDonald, O'Reilly Media, August 2011 3. The Book of CSS3: A Developer's Guide to the Future of Web Design ‐ Peter Gasston,

No Starch Press, April 2011 4. Beginning CSS: Cascading Style sheets for Web Design ‐ Richard York, Wrox Press

(Wiley Publishing), 2005. 5. A Complete Guide to Search Engine Optimization ‐ Deepak Bansal, B.R. Publishing

Corporation Reference Books :

1. Web Enabled Commercial Application Development using HTML, JavaScript, DHTML and PHP, fourth revised edition – Ivan Bayross, BPB Publication

2. The Internet and its Protocol – A comparative approach – Adrian Farrel, Morgan Kaufmann Publishers

3. David Mc Farland: CSS: The Missing Manual, O’Reilly, 2006.

Web References: 1. http://www.w3schools.com 2. http://www.whatwg.org/specs/web‐apps/current‐work/multipage/#auto‐toc‐4 3. http://people.cs.pitt.edu/~mehmud/cs134‐2084/lectures.html

CA713:Object Oriented Concepts and Programming (Marks 200)

Credit Hours : 07

Objectives: The objective of the course is

• To be able to understand the concepts of Object Oriented Programming and easily one of the language ‐ Java.

• To get a good understanding of developing multi‐threaded applications using the Java Programming Language.

• To be able to develop Applets for embedding in a web page. • To develop proficiency in creating console based and GUI based applications using the

Java Programming Language.

Prerequisites: Knowledge of any programming language Methodology & Pedagogy: During theory lectures illustrations emphasizing the need for Object Oriented Programming concepts will be discussed. Emphasize will be given on Core Java concepts, various Java packages, Multithreading, The collection framework, and GUI using AWT and Applets. During Practical sessions, students will be required to develop Simple Java programs, Develop simple to intermediate level applications on Java platform and create simple Java Applets for use in Web pages. Learning Outcomes: Upon successful completion of the syllabus, students will get basics of object oriented programming and will be able to develop programs using concepts of object oriented programming. Concretely, students shall be able to create appropriate classes using the Java Programming Language to solve problems using Object Oriented Approach. They shall be able to write console based and GUI based applications, develop multi‐threaded applications and create Applets using the Java Programming Language. Outline of the Course: Unit No.


1 Introduction to JAVA and Concepts of OOP 06

36

2 Basic JAVA syntax, class and method concepts 09 3 Extending classes and inheritance, Package concept &

common classes from the java.lang package 09

4 String Handling, Exception handling and Multithreading 08 5 The Collection framework, common classes from

java.util, java.io packages 09

6 GUI using AWT and Applet 07 Total Hours (Theory): 48


Total: 84

Detailed Syllabus : Unit – I: Introduction to JAVA and Concepts of OOP Hours: 06 Paradigms of Programming Languages, Evolution of OO Methodology, Basic Concepts of OO Approach, Comparison of Object Oriented and Procedure Oriented Approaches, Concepts of OOP: Classes and Objects, Abstraction and Encapsulation, Inheritance, Polymorphism, Features of the Java Language, Java Environment, Object Oriented Programming in Java, Java Program Structure, Java and Unicode Unit – II: Basic JAVA syntax, class and method concepts Hours: 09 Data Types, Variables and Arrays: Data Types in Java, Literals, Characters, Variable Declaration, Symbolic Constants, Type Casting Operations in Java: Arithmetic Operators, Basic Assignment Operators, Relational Operators, Boolean Logical Operators, Ternary Operator, Operator Precedence Control Statements: Java's Selection Statements, Switch, Nested Switch, Iteration Constructs, Continue, Return Arrays – Declaring, Initializing and Traversing, One dimensional, Two dimensional and Multi‐dimensional arrays Defining Classes and Methods: Introduction to Class and Methods, Methods Overloading, Constructor Overloading, Objects as Parameters, Returning objects, Recursion, Understanding Static, Final, Nested and Inner Classes, Command Line Arguments Unit – III: Extending classes and inheritance, Package concept & common classes from the java.lang package Hours: 09 Inheritance Concepts – Defining Sub Classes, Method Overriding, Using super keyword, Variable shadowing, Method and Variable Binding, using final keyword, Abstract Classes and Interfaces, Object Class Packages: Creating Package, CLASSPATH environment variable, access specifiers, Access Control / Visibility Exploring java.lang package: Wrapper Classes and Simple Type Wrappers, Void, Runtime Class, System Class, Using Clone() and Clonable() Interface, Math Class. Unit – IV: String Handling, Exception Handling and Multi‐threading Hours: 08 Handling Strings: String Class and Operations, StringBuffer Class and Operations, StringBuilder Class and Operations, StringTokenizer and Operations Exception Handling: Types of Exceptions, Throwable Class, Keywords ‐ try, catch, throw, throws and finally, Nested try Statements, Java Built in Exceptions, User Defined Exceptions.

Multi‐threaded Programming: The Java Thread Model, Priorities, Messaging, Thread, Runnable Interface, Creation of Threads, Creating Multiple Threads, Synchronization and Deadlock. Unit – V: The Collection Framework, common classes from java.util, java.io packages Hours: 09 Collection Framework – Collections, List, Set, Enumeration, Iterator, ArrayList, LinkedList, HashSet, TreeSet, HashMap, Hashtable, Vector The Utility Classes: Date, Calendar and SimpleDateFormat java.io‐ File class, Creating Directory, Input/Output Basics, Streams (Byte and Character), Reading From and writing to Console, Reading and Writing Files, PrintWriter Class, the transient modifier, RandomAccessFile Unit – VI: GUI using AWT and Applet Hours: 07 Introduction to AWT and Swing Fundamentals Of Applets, Applet Class, Applet Life Cycle, A Simple Banner Applet, getDocumentBase(), getCodeBase(), showDocument(), AppletContext and AppletStub interface. Working with Frames, windows, graphics, color, fonts AWT controls ‐ Buttons, Checkbox, Choice, List and TextField Layout Managers ‐ Flow Layout, Grid Layout and Border Layout User Interface Events ‐ Event Classes and Event Listener Interfaces, Adapter Classes

Core Books:

1. Herbert Schildt: The Complete Reference Java J2SE 5th Edition, TMH Publishing Company Ltd, NewDelhi.

2. Cay Horstmann and Gary Cornell: Core Java Volume 1‐ 8th ed. or later, Pearson Education, 2008.

Reference Books: 1. Pravin Jain, The class of JAVA, Pearson 2. Ivor Horton's “Beginning Java 2” JDK 5 Edition, Wiley Computer Publishing, (2007) 3. Ken Arnold, James Gosling and David Holmes: The Java Programming Language, 4th ed.,

Addison Wesley. Web References: 1. http://www.cs.bilgi.edu.tr/~mgencer/Ders%20Malzemeleri/IThingTaggedFile/OOP‐ LectureNotes.pdf 2. http://ocw.mit.edu/courses/electrical‐engineering‐and‐computer‐science/6‐092‐

introduction‐to‐programming‐in‐java‐january‐iap‐2010/index.htm

CA714:Management Information Systems (Marks 100)

Credits Hours : 04 Objectives: The objective of this course is to provide significance of information systems in management of organizations and various business processes effectively and efficiently. Prerequisite: No additional pre‐requisite required. Methodology & Pedagogy: During the Theory sessions, illustrations of working real time information system will be demonstrated. Industrial visits will be arranged in order to demonstrate actual functioning of such systems. Students will be required to carry out a case study of such system. Learning Outcomes: Student will learn to analyze and facilitate strategic and operational activities in the organization. The student shall study how individuals, groups, and organizations evaluate, design, implement, manage, and utilize systems to generate information to improve efficiency and effectiveness of decision making, including systems termed decision support systems, expert systems, and executive information systems. Outline of Course:

Unit No.

Title of unit Minimum number of hours Theory Practical

1 Introduction to Information System 07

‐

2 Role of Information System in organization

09

3 Enterprise System 08 4 Knowledge Management (KM) 08 5 Decision Support System (DSS) and

Executive Support Systems (ESS) 09

6 Business Information System (BIS) 07


Total: 48

Detailed Syllabus : Unit – I: Introduction to Information System. Hours: 07 Introduction of Information System, Role of Information System in Business, Strategic business objective of Information System., Dimension of Information System, Contemporary Approaches to Information System. Unit – II: Role of Information System in organization Hours: 07 Major Types of Information Systems in organization, System from a Functional Perspective, Introduction to organization, Features of organization, organizational and behavioral impact. Unit – III: Enterprise System Hours: 08 Introduction to enterprise system, supply chain management systems, customer relationship management system, Enterprise Applications Unit – IV: Knowledge Management (KM) Hours: 08 Important Dimensions of knowledge, Organizational learning and Knowledge Management, The Knowledge Management value change, Types of Knowledge Management Systems, Knowledge Work System (KWS), Intelligent Techniques. Unit – V : Decision Support System (DSS) and Executive Support Systems (ESS) Hours: 09 DSS:‐ Business value of Improved Decision making, Types of Decision, Decision making Process, The difference between MIS and DSS, Components of DSS, System for Decision Support. ESS:‐ The Role of ESS in the Firm, Business value of ESS. Unit – VI: Business Information System (BIS) Hours: 09 System Development and Organizational Change, Business Process Re‐engineering (BPR), Overview of System Development. Core Books : 1. K. C. Laudon & J. P. Laudon: Management Information Systems, 11th Ed., Pearson Education,

2010. 2. K. C. Laudon & J. P. Laudon: Management Information Systems, 9th Ed., Pearson Education,

2006.

Reference Books : 1. W.S. Jawadekar: Management Information Systems .

2. Jerome Kanter: Management Information Systems . 3. Gordon B. Davis: Management Information Systems . 4. P.T. Josep: E‐Commerce A managerial Perspective‐PHI Publication 5. Jeffery: Introduction to E‐Commerce, TMH.

Web References: 1. http://freevideolectures.com/Course/2687/Management‐Information‐System 2. web2.aabu.edu.jo/tool/.../904230_MIS_CH1%20and%20CH2.ppt

CA715:Operating Systems concepts and Network Technology (Marks 100)

Credits Hours : 04 Objectives: The objective of this course is to provide an understanding for functionalities of Operating Systems and some vital concepts of Networking Technologies. Prerequisite: Introduction to Computers Methodology & Pedagogy: The course will start with a brief introduction of operating system and introduction to Networking technologies, and then cover the major components of most operating systems and networking technologies. During theory lectures, major OS subsystems: process management (processes, threads, CPU scheduling, synchronization, and deadlock), memory management (segmentation, paging, swapping), file systems will be discussed in detail and in networking technologies the ISO/OSI 7‐layered model for understanding network communications , addressing techniques and security issues will be discussed in depth. Learning Outcomes: Upon successful completion of the syllabus students shall be able to understand the concepts and functionalities of Operating Systems like process management, concurrency management, memory management and File and I/O management. Students also will aware with concepts of Networking Technologies like OSI Layers, Network Security, Addressing Techniques and Routing Outline of Course:

Unit No.

Title of unit Minimum number of hours Theory

1 Process Management and Concurrency control

09

2 Memory Management and Scheduling 08 3 I/O Management and File system 07 4 OSI Model 07 5 Addressing Techniques And Routing 08 6 Network Security 09


Total: 48

Detailed Syllabus : Unit – I: Process Management and Concurrency control Hours: 09 Process description and Control: Process concept, Process states (seven state model), Process control structure (PCB), Concept of thread, Multi‐threading models, Synchronization: Principles of Concurrency, Mutual Exclusion, Classical problems of synchronization. Deadlock: Principles of Deadlock, deadlock prevention, deadlock avoidance, deadlock detection and recovery from deadlock. Unit – II: Memory Management and Scheduling Hours: 08 Memory management: Memory management requirements, Memory Partitioning, Paging, Segmentation Virtual memory management: Hard and Control Structures, Operating System policies Uniprocessor Scheduling: Types of scheduling, scheduling algorithms Unit – III: I/O Management and File System Hours: 07 I/O management : I/O devices, Organization of the I/O function, OS design issues, Disk Scheduling and RAID. File Management : File Organization and Access, Record Blocking and Secondary Storage Management. Unit – IV: OSI Model Hours: 07 Introduction, The Physical Layer ,The Data Link Layer ,The Network Layer ,The Transport Layer ,The Session Layer,The Presentation Layer,The Application Layer, Summary. Unit – V: Addressing Techniques And Routing Hours: 08 Addressing : Internet address, Classful address, Subnetting Routing : Techniques, Static vs. Dynamic routing, Routing table for classful address, Routing algorithms: shortest path algorithm, flooding, distance vector routing, link state routing; Unit – VI: Network Security Hours: 09 Network security , Cryptography,Digital Signature,Management of Public keys, Communication Security,Web Security,Social Issues

Core Books :

1. William Stallings :Operating Systems Internals and Design Principles: 6th Edition : PHI : 2009

2. A.S. Tanenbaum: Computer Networks, Fourth Edition, Pearson Education , 2003 Reference Books :

1. Silberschatz, A., Peter B. Galvin and Greg Gagne : Operating System Principles: 8th Ed.: Wiley – Indian Edition: 2009

2. Andrew S. Tanenbaum,”Modern Operating Systems”,Prentice Hall of India Pvt. Ltd, 2003 3. Fred Halsall: Data Communications, Computer Networks and Open Systems, 4th Edn,

Pearson Education, 2003. 4. B. Forouzan: Introduction to Data Communication and Networking, 3rd Edn, TMH, 2004.

Web References:

1. http://www.cs.kent.edu/~farrell/osf03/oldnotes/index.html 2. http://ocw.mit.edu/courses/electrical‐engineering‐and‐computer‐science/6‐828‐

operating‐system‐engineering‐fall‐2006/index.htm 3. http://ocw.mit.edu/courses/electrical‐engineering‐and‐computer‐science/6‐263j‐data‐

communication‐networks‐fall‐2002/lecture‐notes 4. http://ewubd.edu/~asif/course%20materials.html

CS703:Technical Writing and Content Management & Soft skill

(Marks 100)

Credits Hours : 04

Objectives:

• To Develop Technical Writing Skills of the students (Technical Documents, Manuals, WEB page, BLOGs, Letters / e‐mails)

• To improve presentation skills of students. • To develop behavior skills of the students. • To enable them effectively utilize the latest content management approaches and

systems for better organization.

Prerequisite: No specific prerequisites Methodology & Pedagogy:

• Classroom Teaching will be facilitated by Reading Materials, Explanations on the Blackboard and PowerPoint Presentations.

• Interpersonal Activities such as group discussions, role plays, simulations, just a minute sessions and presentations will be incorporated in the classroom to acquaint themselves with the practical issues regarding soft skills. They will be facilitated by an extensive use of multi‐media presentations and listening exercises.

• A case study will be given to the students which will carry 10% weight age. Two evaluations (through written tests) ‐ Internal (at Department / Institute Level) and External (at University Level) will have 20% and 70% of the Theory Marks weight age

respectively. Learning Outcomes:

• The students will get the ability to communicate effectively with co‐workers, employers, clients and customers, friends and family members.

• The students will be able learn how to manage self in the work place needed for career development. In addition to this, they will be able to communicate and manage relationships at different levels.

• They will gain the ability to recognize symptoms of stress and learn management strategies to cope up with it.

• They will derive leadership skills to improve team results.

Outline of the Course: Unit No. Title of the Unit Minimum Numbers of

hours Theory

1 Business Communication and Etiquettes 08 2 Technical Writing 08 3 Information and Content Management and Web

Publishing 08

4 Soft Skills and GD, PI 08 5 Johari Window and Personal Grooming 08 6 Communication Quotient and Emotional Intelligence 08


Total: 48

Detailed Syllabus: Unit – I: Business Communication Hours : 08 Etiquettes: workplace etiquettes, telephone etiquettes, e‐mail etiquettes Business Correspondence: principles of effective writing, words often misused, request letters and memos, positive and negative responses to requests, organizing meetings, preparation of agenda and minutes Unit – II: Technical Writing Hours : 08 Writing Process: Planning and drafting the technical documents, reviewing and revising, proofreading the final manuscripts Professional Document Design: fonts, margins, line spacing, alignment, headings, highlighting, notices, tables, graphs and charts, illustrations and equations Unit – III: Information and Content Management and Web Publishing Hours: 08 Finding Information: Researching inside and outside the library, research process, information cycle, types of information resources, evaluating the content, saving information found Documentation Styles: Various styles of documentation, MLA or APA Style of Documentation Content Management and Web Publishing: Fundamentals of web publishing, Major CMSs on web, Identifying the reader, Creating, Editing and Publishing the content

Unit – IV: Soft Skills and GD, PI Hours : 08 Social and People Skills: SOFTEN, Essentials and Principles of People Skills Attitude, Motivation and Confidence: Attitude and Aptitude, Building positive attitude, Rules and Theories of motivation, Self‐confidence, Communicating with confidence, Characteristic of confident people. Stress and Conflict Management: An introduction to stress and conflict management, Self‐esteem and Egoism, Yielding, Avoidance and Antagonism, Models and Techniques of stress and conflict management Group Discussion and Personal Interview: Recruitment process, GD: Introduction, Skills and Aspects tested in GD, Roles and functions performed in GD, PI: Preparing for a PI, Types of PIs, Types of questions and approaches Unit – V: Johari Window and Personal Grooming Hours : 08 Personal Grooming, Personality Development and Johari Window, Adaptability and Organizational Change, Behavioural change and persuasions Unit – VI: Communication Quotient and Emotional Intelligence Hours : 08 An introduction to CQ and EI, Four Qs – Intelligence, Emotional, Vision and Adversity, Five domains of EQ Reference Books:

1. Andy Green, Effective Personal Communication Skills for Public Relations 2. Penrose, Raberry and Myers, Advanced Business Communication, 4th Edition 3. Booher Dianna, E‐Writing, 21st Century Tools for Effective Communication 4. Ron Ludlow and Fergus Panton, The Essence of Effective Communication 5. Mary Munter, Guide to Managerial Communication, Effective Business Writing and

Speaking, 7th Edition 6. Ed. Neil Thomas, Adair on Team Building and Motivation 7. Meenakshi Raman and Prakash Singh, Business Communication

Web References: 1. sites.google.com/site/bassamhaddadsite/technical‐writing

2. http://www.abahe.co.uk/Free‐En‐Resources/English‐for‐Managers‐Business‐ Correspondance.pdf


FOR

MCA PROGRAMME (3rd SEMESTER)


Detail Syllabus of Semester‐III Objectives

• Develop understanding of concepts of Visual programming and Enterprise computing for development of any real world three tier applications.

• Develop understanding of common technologies and techniques used in the designing of web‐based applications

• Provide understanding of basics of software engineering life cycle and what the object‐oriented (OO) approach to software development is, through OO principles and design patterns.

Outcomes • Students will able to understand and use .NET framework for development of three tire

real world application. • Students will able to understand and use advanced features of Java to build and deploy

real three tire application. • Students will able to apply methods and concepts of software engineering and software

project management and they will able to model the systems using Unified Modeling Language.

• Students will be able to understand concepts of human computer interfaces and design and develop full fledge websites with graphics and other techniques.

• Student will get concepts of security and concurrency control in database. Design stored procedures and utilization of triggers to control and retrieve data efficiently. Student will also understand concepts of data structures.

Effective from Effective from Academic Year 2013‐14 Course Code


al Theory

Pract Total

Internal Exter nal


Study Tests Term

work Tests

CA814 Object Oriented Software Engineering

4 ‐ 4 4 10 20 70 ‐ ‐ ‐ 100

CA815 Enterprise Computing 4 3 7 7 10 20 70 15 15 70 200 CA816 Visual Programming 4 3 7 7 10 20 70 15 15 70 200 CA817 Web Designing concepts 4 3 7 7 10 20 70 15 15 70 200 CA818 Advanced Database

Technologies 4 3 7 7 10 20 70 15 15 70 200

20 12 32 32 500 400 900

CA814:Object Oriented Software engineering (100 Marks)

Credit Hours: 04

Objective: Understand various phases and activities of software development and to model them using a unified process. Prerequisite: None. Learning Outcomes: Student shall understand the concepts of software engineering and shall be able to analyze and design different views of any system using UML concepts. Instructional Methods & Pedagogy: During theory lectures, concepts of object oriented analysis and design will be discussed using industry standard Unified Modeling Language. Students will be guided for software development according to industry standards. Through case study based approach students will be asked to design different views of real world systems using UML tools. Outline of the Course:

Unit No.


1 Software and software engineering 06

‐

2 Basing software development on reusable technology 10

3 Modeling with classes and using design patterns 10

4 Modeling interactions and behavior 07 5 Architecting and designing software 08 6 Testing and inspecting to ensure high quality 07


Total: 48

Detailed Syllabus:

Unit – I: Software and software engineering Hours: 07

The nature of software ,What is software engineering, Software engineering as a branch of the engineering profession , Stakeholders in software engineering, Software quality, Software engineering projects , Activities common to software projects. Review of object orientation

Unit‐ II: Basing software development on reusable technology Hours: 10

Incorporating reusability and reuse into software engineering, Frameworks: reusable subsystems, The client/server architecture, Technology needed to build client/server systems, The Object Client/Server Framework (OCSF),Basic description of OCSF /client side, Basic description of OCSF/server side ,Difficulties and risks when considering reusable technology and client/server systems ,Developing requirements, Domain analysis, Defining the problem and the scope, Types of requirements, Use cases: describing how the user will use the system, Some techniques for gathering requirements, Types of requirements document, Reviewing requirements, Difficulties and risks in domain and requirements analysis.

Unit – III: Modeling with classes and using design patterns Hours: 10

Basics of UML, Essentials of UML class diagrams, Associations and multiplicity, Generalization, Object diagrams, The basics of Object Constraint Language (OCL) ,The process of developing class diagrams, Difficulties and risks when creating class diagrams Introduction to patterns, The Abstraction/Occurrence pattern , The General Hierarchy pattern , The Player/Role pattern, The Singleton pattern, The Delegation pattern, The Adapter pattern, The Factory pattern. Unit – IV: Modeling interactions and behavior Hours: 07

Interaction diagrams, State diagrams, Activity diagrams, implementing classes based on interaction and state diagrams, Difficulties and risks in modeling interactions and behavior.

Unit – V: Architecting and designing software Hours: 08

The process of design, Principles leading to good design, Design Principles , Techniques for making good design decisions, Model Driven Development, Software architecture, Architectural patterns ,Writing a good design document ,Difficulties and risks in design.

Unit – VI: Testing and inspecting to ensure high quality Hours: 07

Effective and efficient testing, Defects in ordinary algorithms, Documentation defects,Writing formal test cases and test plans , Strategies for testing large systems, Inspections , Quality assurance in general, Difficulties and risks in quality assurance

Core Books:

1. Timothy C. Lethbridge and Robert Laganière: Object‐Oriented Software Engineering: Practical Software Development using UML and Java : Second Edition : McGraw‐Hill Education: 2005

2. Bernd Bruegge : Object oriented software engineering :Second Edition, Pearson Education.

3. Roger Pressman : Software Engineering : Sixth edition :Tata McGraw Hill.

Reference Books:

1. Grady Booch, James Rambaugh, Ivar Jacobson: The Unified Modeling Language User Guide, Addison Wesley.

2. Jacobson, Booch, Rumbaugh :The Unified Software Development Process : Pearson Education : 1999.

3. Stephan R. Schach : Object oriented software engineering :Tata McGraw Hill..

Web References:

1. http://pl.cs.jhu.edu/oose/lectures

2. http://www.site.uottawa.ca/school/research/lloseng/supportMaterial/videos/

3. http://www.cs.uic.edu/~jbell/CourseNotes/OO_SoftwareEngineering

4. http://www.abssw.com/papers/UML_Overview.pdf

CA815:Enterprise Computing (200 Marks)

Credit Hours: 07 Objectives of the course: The objective of the course is to develop understanding of concepts of Enterprise computing for development of any real world three tier applications along with concepts of internationalization and networking

Prerequisite: Object oriented concepts and Programming in Java

Learning Outcomes: Upon successful completion of the syllabus students shall be able to understand and use advanced features of Java Programming Language and will be able to develop and deploy real world three tier applications..

Instructional Methods & Pedagogy: During theory lectures illustrations emphasizing the need for advanced features of Java Programming Language will be given. During Practical sessions, students will be required to develop Web Applications using JSP Technology, Servlet Technology & its advanced features. Student shall also develop applications dealing with data storage, documents sharing among applications and networking concepts.

Outline of the Course:

Unit No.


Theory Practical 1 Database Programming 09

36

2 Java Web Application Components‐I 08

3 Java Web Application Components‐II 08 4 Advanced Servlet Features & Security: 08 5 XML, JavaBeans Components & Internationalization 07 6 Java Networking & Distributed Objects 08



Total: 84

Detailed Syllabus:

Unit ‐ I: Database Programming Hours: 09

The Design of JDBC, The Structured Query Language, JDBC Configuration, Executing SQL Statements, Query Execution, Scrollable and Updatable Result Sets, Row Sets, Metadata, Transactions

Unit ‐ II: Java Web Application Components‐I Hours: 08

Understanding Web Applications: Understanding Web Components, Servlets (Overview), JSP Pages, Introducing the MVC Design Pattern, Understanding Containers, Packaging Web Applications, Web Application Structure, JAR Files, WAR Files, HTTP, GET Request Method, POST Request Method, GET & POST in HTML Form Processing, Other Request Methods, The HTTP Response, Using Deployment Descriptors

Working with Servlets: Introducing Servlet, Introducing javax.servlet Package, Introducing the Servlet Interface, Introducing the GenericServlet Class, Introducing HTTP & Servlets, ServletContext and ServletConfig, HTTP STATUS Codes.

Unit ‐ III: Java Web Application Components‐II Hours: 08

Introduction to JSP Technology: Need for JSP, Benefits of JSP, Basic Syntax

JSP Scripting Elements: JSP Expressions, JSP Scriptlets, JSP Declarations

JSP Comments, JSP Implicit Objects

Introduction to JSTL, Core Tag Library.

Unit ‐ IV: Advanced Servlet Features & Security Hours: 08

Session Tracking: Need for Session Tracking ‐ Cookies, URL Rewriting, Hidden Form Fields

Session Tracking Basics: Accessing Session Object associated with Request, Looking up information associated with Session, Associating Information with Session, Discarding Session Data

Filters: Lifecycle of Filter, Filter Views, Filter Chain, Using Filters & RequestDispatcher

Unit‐ V: XML, JavaBeans Components & Internationalization Hours: 07

XML: Introducing XML, Parsing an XML Document using DOM and SAX Parser, Validating an XML Document, Using Namespaces, Generating XML Documents with DOM Parser

JavaBeans Components: Why Beans? , The Bean‐Writing Process, Using Beans to Build an Application.

Internationalization: Locales, Number Formats, Date & Time, Message Formatting, Resource Bundles.

Unit‐ VI: Java Networking & Distributed Objects Hours: 08

Java Networking: Connecting to a server, Implementing Servers, Interruptible Sockets, and Making URL Connections.

Distributed Objects: The Roles of Client and Server, Remote Method Calls, RMI Programming Model, Parameter Passing in Remote Methods.

Core books:

3. Hall Brown: Core Servlets and Java Server Pages, Volume 1: Core Technologies, Second Edition, Pearson

4. Cay Horstmann and Gary Cornell: Core Java Volume II‐ 8th ed. or later, Pearson Education 5. Sue Spielman and Meeraj Kunnumpurath, Pro J2EE 1.4, Wiley Computer Publishing

Reference books:

1. Alexander V Konstantinou, William Wright, Chad Darby and others: Beginning Java Networking, Shroff Publishers and Distributors, 2001.

2. Jim Farley, William Crawford, Justin Gehtland, Prakash Malani and John G Norman: Java Enterprise In A Nutshell, Third Edition, Shroff Publishers and Distributors, 2006.

3. Joseph O'Neil: JavaBeans Programming – from the Ground Up, Fourth Reprint, Tata McGraw‐Hill Publishing Company Limited, 2000.

4. Marty Hall, Larry Brown: Core Servlets and JavaServer Pages, Volume 1 : Core Technologies, Second Edition, Pearson Education , 2003.

5. Marty Hall, Larry Brown: Core Servlets and JavaServer Pages, Volume 2 : Advanced Technologies, Second Edition, Pearson Education, 2008.

6. Steve Holzner: Ant The Definitive Guide, Second Edition, Shroff Publishers and Distributors, 2006.

7. Jim Farley, William Crawford, Justin Gehtland, Prakash Malani and John G Norman: Java Enterprise In A Nutshell, Third Edition, Shroff Publishers and Distributors, 2006.

8. Bryan Basham, Kathy Sierra and Bert Bates, Head First Servlet and JSP, O’Reilly Publication, First Edition.

Web References:

1. http://courses.coreservlets.com/Course‐Materials/csajsp2.html 2. http://www1.ceit.es/asignaturas/InteInfo/Recursos/Servlets/JavaServlets.pdf 3. http://www.msuniv.ac.in/AdvancedJavaProgrammingwithDatabaseApplication.pdf 4. www.doc.ic.ac.uk/~rcheung/teaching/2720/ppt/lecture12.ppt 5. http://www.cs.bgu.ac.il/~spl021/lectures/

CA816:Visual Programming (200 Marks)

Credit Hours: 07 Objectives of the Course: The objectives of the course are to

• Introduction to web programming and .NET framework. • Use webforms and controls to create a user interface. • Access and manipulate data in a Microsoft SQL Server database by using Microsoft

ADO.NET. • Create a simple ASP .NET Web Forms application that uses an XML Web Service through

SOAP. • Use reporting tool to generate dynamic reports. • Using MVC architecture to develop dynamic web application.

Prerequisite: • Familiarity with basic concepts of object oriented programming.

• Familiarity with Extensible Markup Language (XML) concepts.

Learning Outcomes: Upon successful completion of the syllabus students shall be able to understand .Net Framework. Students will also be able to develop, test and deploy dynamic web applications independently using different architectures.

Instructional Methods & Pedagogy: During theory lectures illustrations emphasizing the need for advanced features of .Net framework and ASP.Net will be given. During Practical sessions, students will be required to develop Web Applications using concepts discussed during class.

Outline of the Course: Unit No.


1 Introduction to .NET framework and ASP.NET 06

36

2 Working with ASP.NET Applications 143 Database Connectivity through ADO.NET 084 Overview of SOA 065 Reporting 076 Advance ASP.NET 07



Total: 84

Detailed Syllabus:

Unit ‐ I: Introduction to .NET framework and ASP.NET Hours:06

• Introducing .NET Framework o Enterprise vision of .NET o .NET Framework Component o .NET Framework Version Compatibility o Core of .NET Framework: Application Services, Base Class Library and CLR

• Introducing Web Programming. o Understanding Web server (IIS) and Web Client. o Basic of Http Request and Http Response. o Understand form Tag and Comparision between Get and Post Methods

• Introducing ASP and ASP.NET o Programming in ASP using visual studio o Programming in ASP.NET using visual studio

• Deploying ASP.NET Appliction o Compilation and execution of .NET Application o Dynamic Compilation

Unit ‐ II: Working with ASP.NET Applications Hours:14

• ASP.NET Page Life Cycle • Structure of an ASP.NET Page: ASPX Page, Code behind File, WebConfig and machine

config • Develop Web Form

o Create User Interface using Standard Controls, Rich Web Control, Navigation Controls and Login Control.

o Working with properties and events of controls o Validate User Input using Validation Controls. o Concept of custom control.

• Concept of MasterPage and Nested MasterPage • State Management Techniques

o Client side: ViewState, Hidden Field, Cookie o Server Side: ApplicationState, Session, Output cache

• Application Tracing, Error Handling and Responding to Errors o Try Catch Final o Custom Error Page

Unit ‐ III: Database connectivity throuugh ADO.NET Hours:08

• Introduction and Evolution of ADO.NET. • Binding data to web controls and data controls. • ADO.NET Architecture:

o ConnectionOriented: Understanding of Connection, Command, DataReader object.

o ConnectionLess: Understanding of DataAdapter, DataSet, DataTable and Dataview object.

• Working with XML – Overview of XML Classes and using XML with datasets.

Unit ‐ IV: Overview of SOA Hours:06

• Overview of Service Oriented Architecture o Service Provider o Service Consumer o Service o Service Description o SOAP o UDDI

• Building Web Service in ASP.NET o Deploying, Publishing and Consuming Web service.

Unit ‐ V: Reporting Hours:07

Introduction to Crystal Report, Crystal Reports Architecture, ReportViewer Control, Object Model, Understanding Reporting Control

Unit ‐ VI: Advance ASP.NET Hours:07

• Introduction to ASP.NET AJAX. • ASP.NET AJAX Control Toolkit Extender and controls.

Adjusting the Web Content, Validating Controls, Working with Menu, list and pop‐ups.

Introduction to MVC Architecture in ASP.NET,Developing web application in MVC Architecture

Core books:

1. Stephon Walther: ASP.Net Unleashed, BPB publication. 2. Kogent Solutions Inc.: ASP.Net 3.5 Black book, Dreamtech press, 2009. 3. Mridila Parihar, Essam Ahmed : ASP .Net Bible, Wiley, 2004.

Reference books:

1. Bill Evjen, Scott Hanselman, Devin Rader: Professional ASP.Net 3.5 (sp1) In C# and VB, Wiley India Edition.

2. Mesbah Ahmed, Chris Garrett, Jeremy Faircloth, Chris Payne: ASP.Net Programming. Developer’s Guide, Dreamtech, First Edition 2002.

3. A. Russell Jones, Mike Gunderloy: .Net Programming 10‐Minute Solutions, BPB Publications.

4. Greg Buczek: ASP.Net Developer’s Guide, Tata McGraw Hill Edition Forrth Edition, 2005. 5. Greg Buczek: ASP.Net Tips & Techniques, Tata McGraw Hill Edition ‐ 2002.

Web References:

1. http://msdn.microsoft.com/en‐us/aa336522.aspx 2. http://www.asp.net/ 3. http://www.aspfree.com/ 4. http://www.devx.com/dotnet 5. myweb.sabanciuniv.edu/gulsend/files/2010/03/intro.ppt 6. www.cs.odu.edu/~mukka/cs795sum08/Lecturenotes/Day3/ado.ppt 7. grail.cba.csuohio.edu/.../notes/.../Using%20Crystal%20Report%20‐%...

CA817‐Web Designing Concepts (200 Marks)

Credit Hours: 07

Objectives: The objective of the course is to • Understand advanced concepts of Web designing • Design professional web page templates with graphics. • Integrate several technologies into designing effective and attractive Web sites. • Produce and embed multimedia to accompany sites

Prerequisites: None Learning Outcomes: Upon successful completion of the course, the students shall be able to design and develop fully fledged websites with graphics and animation. Instructional Methods & Pedagogy: During theory sessions, topics related to advanced web designing technologies will be covered with suitable examples. During practical sessions, students will be required to integrate graphics and animation in web site using several web designing technologies and editors.


Unit No.

Unit Title Minimum number of hours

Theory Practical

1 Web Design Basics 07

36

2 Graphics Design 09 3 Introduction to Multimedia and Managing Text

and Images in Multimedia 08

4 Incorporating Sound and Video in Multimedia 09 5 Web Animation 10 6 Introduction to Web site Hosting 05



Total: 84

Detailed Syllabus:

Unit – I Web Design Basics Hours : 07 Introduction to Web Design and Development, Website and Web Application, W3C (World Wide Web Consortium), Evolution of Web, Web Design Strategies

Starting with a Plan :Understanding the different phases of a web project, Determining the Site’s Purpose, Building a site image, Determine Site content, Diagnosing the Site’s Dynamic Requirements, Defining ways to attract visitors. Defining the Audience: Defining the target audience, Defining the Ideal site visitor, Determining benefits to site visitors. Gathering Content: Defining site content requirements, Building wireframes, Gathering text and Graphics, Organizing site content, Building a site map. Choosing the Right Tools: Working with web editors Unit – II Introduction to Multimedia and Managing Text and Images in Multimedia Hours : 09 Introduction, Usage of Multimedia, Stages of a Multimedia Project, the Multimedia Team Text Multimedia: Power of Meaning, Fonts and Faces, Using Text in Multimedia, Computers and Text, Font Editing, Hypermedia, Hypertext Image in Multimedia: Organizing Tools, Bitmap Images, Vector Drawings, 3‐D Drawing and Rendering, Color models, Image File Formats Unit ‐ III Graphics Design Hours : 08 Getting started with Graphics Design Concept, Working with tools, Working with web safe colors, Introduction to layers, Layer Styles, Adding and manipulating text, Working with 2D & 3D images, Slicing the page, Saving and printing images, Color swatches, Correcting colors and lighting, Applying Effects and Filters Unit – IV Incorporating Sound and Video in Multimedia Hours : 09 Sound Multimedia: Power of Sound, Digital Audio, Preparing Digital Audio Files and MIDI Files, Function of editing Digital Audio Files, Audio File Formats, MIDI versus Digital Audio, Adding Sound to Your Multimedia Project Video Multimedia: Using Video, Analog Display Standards, Digital Display Standards, Digital Video, Video Recording, Shooting and Editing Video, Optimizing Video Files Unit – V Web Animation Hours : 10 Introduction to Animation ‐ Power of Motion, Principles of Animation, Animation by Computer, Making Animations Development of Animation ‐ Toolbars and Panels, Symbols and Instances, Timelines, Organizing layers, Layer Masking, Frame Animations, Shape and Motion Tweening, Deco brush, Testing and Publishing animated file, Templates, Incorporating sound and video Introduction to Action Script 3.0, Array and Loops, Controlling Actions with Events, Organizing Objects with the Display List, Controlling the Timeline and Animation, Components for Interactivity, Choosing Using and Animating Text, Controlling Sound With ActionScript, Using ActionScript and Component to Control Video Unit – VI Introduction to Web Architecture & Hosting Hours : 05

Introduction to Information Architecture, Visualizing Information Architecture, Information Architecture Components, Optimization of Web Introduction to Website hosting, Domain Name, Web Server, Website Parking, Publishing Website through FTP Core Books:

1. Tay Vaughan, Multimedia, Making it Work ‐ 7th Edition, Tata McGraw Hill Publication. 2. Lesa Snider, Photoshop CS5 ‐ The missing manual, O’reilly Media, First Edition, May

2010. 3. Lisa DaNae Dayley and Brad Dayley, Photoshop CS5 ‐ Adobe Photoshop CS5 Bible,

Wiley India Pvt. Ltd., June 2010. 4. Chris Grover, Flash CS5, Action Script 3.0 ‐ The Missing Manual, First Edition, O’Reilly

Publication. 5. Peter Morville & Louis Rosenfeld, Information Architecture for WWW – 3rd Edition,

O’Reilly Publication. Reference Books:

1. Katherine Ulrich, Flash Professional CS5, Peachpit Press 2. Michael Toot, Sherry Kinkoph, Master Adobe Photoshop, Illustrator, Premiere and

after Effects Visually, First Edition 2002 3. Douglas K. Van Duyne, James A. Landay, Jason I. Hong, The Design of sites – Patterns for

creating Winning web sites , Prentice Hall , Second Edition 4. Adobe Creative Team, Action Script 3.0 ‐ Adobe Flash Professional CS5 Classroom in a

Book

Web References: 1. http://www.techdocs.ku.edu/docs/web‐authoring_design‐basics.pdf 2. http://www.virtualdub.org/ 3. http://audacity.sourceforge.net/ 4. http://www.kompozer.net/ 5. http://sourceforge.net/

CA818:Advanced Database Technologies (200 Marks)

Credit Hours: 07

Objectives of the Course: This course is intended to give students advanced concepts of Relational Database Management System, security aspects of databases and introduction to other databases. Also concepts and practical aspects of data manipulation using stored procedures and triggers will be given. Prerequisite: Database Technologies – I Learning Outcomes: Upon successful completion of the syllabus students shall be able to handle advanced database transaction using complex database objects. In turn students will also get themselves familiar with emerging database technologies. Instructional Methods & Pedagogy: During theory sessions detailed understanding of query and Transaction process mechanism, Database backup, recovery and security mechanism will be given. Students will also be taught how to write stored Procedures and how to trigger these procedures using specific procedural language. During Practical sessions, students will implement the concepts which are discussed in lecture.


Unit No.

Title of unit Minimum number of hours

Theory Practical 1 Introduction to PL/SQL 09

36

2 Advanced Transaction Recovery 08 3 Distributed Transactions 08 4 Parallel Databases 07 5 Object relational database 07 6 Emerging database technologies 07



Total: 84

Detailed Syllabus:

Unit – I: Introduction to PL/SQL Hours : 09 Introduction to PL/SQL, cursor, stored procedure and user defined functions.

Unit – II: Advanced Transaction Recovery Hours : 08 Check pointing, Recovery from system crash, Media recovery, Other approaches and interaction with concurrency control. Unit – III: Distributed Transactions Hours : 08 Introduction to R* distributed database management system, The two‐phase commit protocols, 2 PC pitfalls, Hierarchical 2 PC, Presumed Abort Protocol, Presumed Commit Protocol, Dead lock management in R*. Unit – IV: Parallel Databases Hours : 07 Introduction, Architecture for parallel databases, query evaluation, parallelizing individual operations, query optimization. Unit – V: Object relational database Hours : 07 Active database concepts. Temporal database concepts.; Spatial databases, Concepts and architecture; Deductive databases and Query processing; Mobile databases, Geographic information systems. Unit – VI: Emerging database technologies Hours : 07 Internet databases, Digital library, Multimedia database, Mobile database, Spatial database. Core Books: 1. Raghu Ramakrishnan, Johannes Gehrke; Database Management Systems, McGraw Hill

Publication.

2. Ramez Elmasri, Shamkant B. Navathe; Fundamentals of Database Systems 5th Ed., Pearson Publication.

3. Database Systems, Concepts, Design and Applications, First Edition, S.K.Singh, Pearson Education.

Reference Books: 1. Abraham Silberschatz, Henry F. Korth, S. Sudarshan; Database System Concepts 6th Ed. ,

Mc Graw Hill

Papers:

1. Kung, H. T., and John T. Robinson. "On Optimistic Methods for Concurrency Control." ACM Transactions on Database Systems 6, no. 2 (1981): 213‐226

2. Franklin, Michael. "Concurrency Control and Recovery." The Computer Science and Engineering Handbook. 1997 (Sec. 3.2.1)

3. Mohan, C., et al. "ARIES: A Transaction Recovery Method Supporting Fine‐Granularity Locking and Partial Rollbacks Using Write‐Ahead Logging." ACM Transactions on Database Systems 17, no. 1 (1992): 94‐162

4. Dewitt, David, and Jim Gray. "Parallel Database Systems: The Future of High Performance

Database Processing." Communications of the ACM 35, no. 6 (1992): 85‐98 5. Thierry Cruanes, Benoit Dageville, Bhasker Ghosh, parallel SQL execution in Oracle 10g,

SIGMOD ’04 Proceedings of 2004 ACM SIGMOD internation conference on management of data Pages: 850‐854.

6. Mohan, C., B. Lindsay, and R. Obermarck. "Transaction Management in the R* Distributed Database Management Systems." ACM Transactions on Database Systems 11, no. 4 (1986): 378‐396

Web References:

1. http://people.cs.aau.dk/~torp/Oracle/introduction_to_plsql.pdf 2. http://www.cs.nyu.edu/courses/fall07/G22.2434‐001/index.html 3. http://ocw.mit.edu/courses/electrical‐engineering‐and‐computer‐science/6‐830‐

database‐systems‐fall‐2010/lecture‐notes/ 4. http://infolab.usc.edu/csci585/Spring2010/den_ar/ordb.pdf 5. http://www.dagstuhl.de/Reports/99/99351.pdf


FOR

MCA PROGRAMME (4th SEMESTER)



Course Code



Internal Exter nal


Study Tests Term

work Tests

CA819 Open Source Technology

4 3 7 7 10 20 70 15 15 70 200

CA820 Mobile Application Technology

4 3 7 7 10 20 70 15 15 70 200

CA821 Software Quality Assurance

4 3 7 7 10 20 70 15 15 70 200

CA822 CA825

Elective 1 4 3 7 7 10 20 70 15 15 70 200

16 12 28 28 400 400 800

Electives Set 1

1. CA822‐Windows Communication Foundation Framework 2. CA823‐Frameworks and Applications 3. CA824‐Procurement, Implementation and Management of IT systems.

4. CA825‐Advanced Network Management and Security

CA819:Open Source Software Solutions (200 Marks)

Credit Hours: 07

Objective: The objective of this course is to provide an understanding for open source movement worldwide , learning popular open source platforms like “Linux” OS and software development using LAMP.

Prerequisite: CA703 and CA704 (Working knowledge of Linux and Html ) Learning Outcomes: Upon successful completion of the syllabus students shall be able to understand and use open source software, able to develop applications using LAMP. Instructional Methods & Pedagogy: In order to achieve the course objectives, students will be introduced to the open source concepts, various products like linux, apache, mysql and php.



1 Introduction to open source softwares and their Configuration

06

36

2 Overview of PHP structure and syntax 06 3 Accessing Mysql and MongoDB with PHP 10 4 Working with user data and error handling 10 5 Object Oriented Programming using PHP 08 6 Application Development and MVC

architecture using PHP 08



Total: 84 Detailed Syllabus: Unit ‐ I : Introduction to open source soft wares and their Configuration Hours : 06 Overview of Open Source Soft wares , Widely used open source products , Development philosophy ,Open source vs. closed source ,Open source software vs. free software , Open source vs. source‐available , Pros and cons , Development tools, The distribution terms of open source software, open source technology importance, Free and Open Source Software (FOSS), Configuring apache, Configuring Mysql, Configuring PHP Unit ‐ II : Overview of PHP structure and syntax Hours : 08 Background information of php, Using variables, operators and expressions

Conditional statements and iterations in PHP: Conditional Statements: if statement, switch statement. Looping : for loop, while loop, do..while statement, for each statement. Functions and Arrays in PHP: php functions, creating array. PHP image manipulation. Unit ‐ III : Accessing Mysql and MongoDB with PHP Hours : 10 Mysql structure, Connectivity, Querying the database, Using PHP with MongoDB, connecting MongoDB with PHP, Performing query oprations with MongoDB Unit ‐ IV : Working with user data and error handling Hours : 10 Handling HTML forms with PHP,Sessions,Cookies,Handling and avoiding errors,Exception Handling, Using AJAX with PHP. Unit ‐ V : Object Oriented Programming using PHP Hours : 08 Creating classes and objects in PHP,Working with methods, Inheritance,Constructors,Destructors,Self and parent keyword,Object cloning,Object Oriented Programming using MySQL DB Unit ‐ VI : Application development and MVC architecture using PHP Hours : 06 Introduction to MVC architecture, Intoduction to frameworks like magento,wordpress joomla etc. Core Books:

1. Sharnam Shah,Vaishali Shah: LAMP programming for professionals,Shroff Publishers,December 2009

2. Matt Doyle:Beginning PHP 5.3,Wrox Publication,2010 Edition 3. Steve Francia: MongoDB and PHP, O’Reilly Media Publication

Reference Books :

1. Jason Garner,Morgan Owens, Elizabeth Naramore,Matt Warden,Jeremy Stolz: Professional LAMP: Linux,Apache,MySQL and PHP Web Development(Paperback) Wrox,2005.

2. Elizabeth Naramore,Jason Gerner,Yann Le Scouarnec,Jeremy Stolz,Michael K. Glass: Beginning PHP6.Apache and MySQL Web Development,Wrox,2005

3. Rubayeet Islam: PHP and MongoDB Web Development Beginner’s Guide , PacktLib Publication

Web References :

1. http://www.cecs.csulb.edu/~mopkins/cecs470/PHPNotes.pdf

2. www.university.youth4work.com › Study Material

3. http://freevideolectures.com/Course/2331/Building‐Dynamic‐Websites/2

CA820:Mobile Application Technology (200 Marks)

Credit Hours: 07 Objectives of the course: The objective of the course is to develop understanding of concepts of Mobile Application Development for development of any real world applications along with advanced concepts like Google Maps, Web Services and XML parsing.

Prerequisite: Object oriented concepts and Programming in Java

Learning Outcomes: Upon successful completion of the syllabus students shall be able to understand and use advanced features of Java Programming Language and will be able to develop and deploy real world three tier applications..

Instructional Methods & Pedagogy: During theory lectures illustrations emphasizing the need for advanced features of Java Programming Language will be given. During Practical sessions, students will be required to develop Web Applications using JSP Technology, Servlet Technology & its advanced features. Student shall also develop applications dealing with data storage, documents sharing among applications and networking concepts.

Unit No.


Theory Practical 1 Introduction and Basics of Android 07

36

2 Understanding User Interface in Android 08

3 Working with Adapters, Widgets, Alerts and Menus 08 4 Intents, Activities, Preferences, Styles and Themes 08 5 Working with SQLite Database, Content Providers,

Broadcast Receivers and Services 09

6 Advanced Android Features 08 Total Hours (Theory): 48


Total: 84

Detailed Syllabus:

Unit ‐ I : Introduction and Basics of Android Hours : 07 What is Android? Setting up development environment, Dalvik Virtual Machine & .apk file extension

Fundamentals: a) Basic Building blocks – Activities, Services, Broadcast Receivers & Content providers b) UI Components‐ Views & notifications c) Components for communication ‐Intents & Intent Filters Android API levels (versions & version names) Application Structure: AndroidManifest.xml, Resources & R.java, Assets, uses‐permission & uses‐sdk, Activity/services/receiver declarations, Values – strings.xml, Layouts & Drawable Resources, Activities and Activity lifecycle, First sample Application, Emulator‐Android Virtual Device, Launching emulator, Editing emulator settings, Emulator shortcuts, Deploying sample application on a real device. Logcat usage, Introduction to DDMS, File explorer. Unit ‐ II : Understanding User Interface in Android Hours : 07 What is XML‐Based Layout? Working with containers: LinerLayout, RelativeLayout, TableLayout, Scrollwork, FrameLayout. Basic Views: TextView, EditText, Button, ImageButton, CheckBox, ToggleButton, RadioButton, RadioGroup , ProgressBar, AutoComplete TextView, Picker Views: TimePicker and DatePicker views Additional Views: AnalogClock and DigitalClock views Unit ‐ III : Working with Adapters, Widgets, Alerts and Menus Hours : 06 Adapters: ArrayAdapter, BaseAdapter ListView and ListActivity, Custom ListView, GridView using adapters, Gallery using adapters AlertDialogs & Toast Menus: Option menu, Context menu, Sub menu, menu from xml, menu via code Unit ‐ IV : Intents, Activities, Preferences, Styles and Themes Hours : 07 Intents: Explicit Intents, Implicit Intents, Switching between activities and passing data between activities using Intents. Tabs and TabActivity Preferences: SharedPreferences, Preferences from xml Styles & Themes: styles.xml, colors.xml‐ declaring colors and drawables, style attribute in layout file, Applying themes via code and manifest file, creating custom themes and applying it to the activity. Unit ‐ V : Working with SQLite Database, Content Providers, Broadcast Receivers and Services Hours : 07 SQLite Programming, SQLiteOpenHelper, SQLiteDatabse , Cursor

Content Providers: Defining and using content providers, Sharing database among two different applications using content providers, Reading and updating Contacts, Reading bookmarks Broadcast Receivers: Understanding and implementing Broadcast Receiver Services: Difference between Activity and Service, understanding and implementing Service Unit ‐ VI : Advanced Android Features Hours : 07 XML parsing, JSON parsing, Working with Web Service in Android. Maps via intent and MapActivity Using sdcards – Reading and writing Accessing Phone services(Call,SMS)

Core Books:

1. Reto Meier: Professional Android 2 Application Development, Wrox publication 2. Mark L. Murphy: The Busy Coder’s Guide to Android Development

Reference Books: 1. Jonathan Simon: Head First Android Development, O’REILLY publication. 2. Mark L. Murphy: Beginning Android 2.APRESS publication.

Web references: 1. http://www.andrew.cmu.edu/course/95‐702/slides/03_Android.pdf 2. www.eli.sdsu.edu/courses/fall09/cs696/notes/index.html ‐ United States

CA821-Software Quality Assurance (200 Marks)

Credit Hours: 07 Objectives of the Course: To build up understanding of concepts of software development cycle and software quality assurance practices and various software testing techniques.

Prerequisite: Object Oriented Software Engineering

Learning Outcomes: Student will be able to understand concepts of quality assurance and quality enhancement of entire software application with the aid of testing strategies and tools.

Instructional Methods & Pedagogy: The theory sessions will be focused with a solid understanding of practices that support the production of quality software, Software testing techniques, Understanding the requirements, defects, test cases, and test results, Process models for units, integration, system, and acceptance testing, Quality Models and Software Quality Assurance.


Unit No.


1 Software Quality & Significance of Testing 07

36

2 Control Flow and Data Flow Testing 08 3 System Integration Testing & Functional

Testing 09

4 System Test Design, Planning & Automation

09

5 System Test Execution & Acceptance Testing

08

6 Software Quality Assurance 07 Total Hours (Theory): 48


Total: 84

Detailed Syllabus:

Unit ‐ I : Software Quality & Significance of Testing Hours : 07 Software Quality, Role of testing, verification and validation, objectives and issues of testing, Testing activities and levels, Sources of Information for Test Case Selection, White‐Box and

Black‐Box Testing , Test Planning and Design, Monitoring and Measuring Test Execution, Test Tools and Automation, Test Team Organization and Management . Concept of Unit Testing , Static Unit Testing , Defect Prevention , Dynamic Unit Testing , Mutation Testing , Debugging , Unit Testing in eXtreme Programming. Unit ‐ II : Control Flow and Data Flow Testing Hours : 08 Outline of Control Flow Testing, Control Flow Graph, Paths in a Control Flow Graph, Path Selection Criteria, All‐Path Coverage Criterion , Statement Coverage Criterion, Branch Coverage Criterion, Predicate Coverage Criterion, Generating Test Input, Examples of Test Data Selection. Data Flow Anomaly, Overview of Dynamic Data Flow Testing, Data Flow Graph, Data Flow Terms, Data Flow Testing Criteria, Comparison of Data Flow Test Selection Criteria, Feasible Paths and Test Selection Criteria, Comparison of Testing Techniques. Unit ‐ III : System Integration Testing & Functional Testing Hours : 09 Concept of Integration Testing, Different Types of Interfaces and Interface Errors, Granularity of System Integration Testing, System Integration Techniques, Software and Hardware Integration, Test Plan for System Integration, Off‐the‐Shelf Component Integration, Off‐the‐Shelf Component Testing, Built‐in Testing Basic Tests, Functionality Tests, Robustness Tests, Interoperability Tests, Performance Tests, Scalability Tests, Stress Tests, Load and Stability Tests, Reliability Tests, Regression Tests, Documentation Tests. Equivalence Class Partitioning, Boundary Value Analysis, Decision Tables, Random Testing, Error Guessing, Category Partition. Unit ‐ IV : System Test Design, Planning & Automation Hours : 09 Test Design Factors, Requirement Identification, Characteristics of Testable Requirements, Test Design Preparedness Metrics, Test Case Design Effectiveness Structure of a System Test Plan, Introduction and Feature Description, Assumptions, Test Approach, Test Suite Structure, Test Environment, Test Execution Strategy, Test Effort Estimation, Scheduling and Test Milestones, System Test Automation, Evaluation and Selection of Test Automation Tools, Test Selection Guidelines for Automation, Characteristics of Automated Test Cases, Structure of an Automated Test Case, Test Automation Infrastructure Unit ‐ V : System Test Execution & Acceptance Testing Hours : 08 Preparedness to Start System Testing, Metrics for Tracking System Test, Metrics for Monitoring Test Execution, Beta Testing, First Customer Shipment, System Test Report, Product Sustaining, Measuring Test Effectiveness.

Types of Acceptance Testing, Acceptance Criteria, Selection of Acceptance Criteria, Acceptance Test Plan, Acceptance Test Execution, Acceptance Test Report, Acceptance Testing in eXtreme Programming. Unit ‐ VI : Software Quality Assurance Hours : 07 Five Views of Software Quality, McCall.s Quality Factors and Criteria, Quality Factors Quality Criteria, Relationship between Quality Factors and Criteria, Quality Metrics, ISO 9126 Quality Characteristics, ISO 9000:2000 Software Quality Standard ISO 9000:2000 Fundamentals, ISO 9001:2000 Requirements. Elements of Software Quality Assurance, SQA Task, Goals and Metrics, Formal approaches to SQA. Statistical Software Quality Assurance, Software Reliability, SQA Plan Core Books:

1. Sagar Naik, Piyu Tripathy: Software Testing and Quality Assurance: Theory and Practice: Wiley : 2008.

2. Roger S Pressman: Software Engineering – A Practitioner’s Approach: 7th Edition: McGRAW HILL International Edition: 2010.

Reference Books: 1. Boris Beizer: Software Testing Techniques: 2nd Edition, Van Nostrand Reinhold: 1990. 2. Daniel Galin: Software Quality Assurance: Pearson Education. 3. Ron Patton: Software Testing: Pearson Education: 2001 Web References: 1. http://patricklam.ca/stqam/notes/pdf/L1.pdf 2. http://users.encs.concordia.ca/~bentahar/INSE6260/Week1‐2009.pdf 3. http://www.inf.ed.ac.uk/teaching/courses/seoc/2006_2007/notes/LectureNote17_Softwar

eTesting.pdf 4. http://www.ida.liu.se/~TDDC01/lectureMaterial/PUM‐2007april‐LC‐1.pdf 5. http://web.itu.edu.tr/gokmen/SE‐lecture‐7.pdf

CA822:Windows Communications Foundation Framework (200 Marks)

Credit Hours: 07

Objectives: The Objectives of this course are: • To provide a deep understanding of the broad technology of WCF • To provide demonstrations of major WCF capabilities. • To provide platform to perform most of WCF options. • To understand concepts of distributed computing.

Prerequisites:

• Good knowledge and experience in one .NET language. • Some knowledge of web service programming.

Learning Outcomes: Upon successful completion of the syllabus

• Students will get a deep understanding of the broad technology of WCF. • Students will have seen demonstrations of major WCF capabilities. • Students will be able to perform most of WCF options, mentioned in the syllabus.


Unit No.


1 Introduction to WCF 08

36

2 Understanding WCF 09 3 Programming WCF 09 4 WCF transactions 08

5 Security in WCF 08 6 Deploying WCF 06



Total: 84

Detailed Syllabus:

Unit ‐ I : Introduction to Windows Communication Foundation Hours : 08 Evolution of WCF, What is WCF, Where does WCF Services fit in, WCF architecture, The makeup of WCF, WCF features, WCF Concepts, Messages, Channels, Services, Behaviors, WCF programming model, Installing WCF, Creating your first WCF service. Unit ‐ II : Understanding Windows Communication Foundation Hours : 09 Addresses, Understanding and programming WCF addresses, Understanding and programming WCF bindings, Understanding and programming WCF contracts, Unit ‐ III : Programming Windows Communication Foundation Hours : 09 Clients, client communication patterns, creating client code, Services, Service’s types, contracts and end points, Services behavior, Handling WCF Exceptions/Faults Unit ‐ IV : WCF transactions Hours : 08 Transactions overview, Transactions attribute in system and service model, Transaction component in Windows, Reliable sessions, Message exchange, security messages, Queues, Message Queuing component in Windows Unit ‐ V : Security in WCF Hours : 8 Security overview, Security behaviors and bindings, Security clients and services, Implementing WCF Security with Authentication and Authorization Unit ‐ VI : Deploying Windows Communication Foundation Hours : 06 Installing WCF services, Upgrading services, Managing WCF, Tracing, message logging, Service Configuration Editor, Hosting WCF services, Consuming WCF service in other platform. Core Books: 1. Scott Klein :Professional WCF Programming, WROX Publication April 2007. 2. Craig McMurty, Marc Mercuri, Nigel Watling, Matt Winkler :Windows Communication Foundation Unleashed, SAMS Publication March 2007. Reference Books:

1. Michele Leroux Bustamante:Learning WCF: A Hands‐on Guide, 1st edition, O'Reilly Media.

2. Steve Resnick , Richard Crane , Chris Bowen: Essential Windows Communication Foundation (WCF): For .NET Framework 3.5, 1 edition, Addison‐Wesley Professional.

3. Pro WCF Practical Microsoft SOA Implementation A Press Publication. Web References :

1. www.mssoapinterop.org/ilab 2. http://weblogs.java.net/blogharoldcarr/archive/2006/02/an_overview_of_1.html 3. http://java.sun.com/webservices/interop/index.jsp 4. http://ws.apache.org/axis2

CA823:Frameworks & Applications (200 Marks)

Credit Hours: 07

Objectives of the Course: The objective of the course is

• To be able to understand the role and importance of different frameworks in general and java frameworks in particular.

• To study two of the frameworks in details (like Spring and Hibernate Framework) • To be able to develop real world applications using frameworks.

Prerequisites: Object Oriented Concepts and Programming , Enterprise Computing Learning Outcomes: Upon successful completion of the syllabus students shall be able to acquire in depth knowledge of frameworks and develop applications using the same. Students shall be having understanding of major concepts like DI, AOP, Web MVC, Spring ‐ Hibernate Integration and HQL and will be able to identify its usage and apply them as per the need while developing applications. Instructional Methods & Pedagogy: During theory sessions the students shall be introduced to various frameworks. Details of Spring and Hibernate frameworks will be discussed and their integration to develop real world applications will be demonstrated. During practical sessions students will be trained to develop various standalone and web applications using the studied frameworks.



1 Introduction to Spring 06

36

2 Beans and Containers 083 The Application Context, Data

Validation and Conversion 09

4 Aspect‐Oriented Programming 065 Spring and Persistence 096 Spring Web MVC 10



Total: 84

Detailed Syllabus:

Unit I : Introduction to Spring Hours : 06 Introduction, Characteristics of framework, Types of framework(Existing frameworks),What is Spring?, The Spring Architecture, Overview of the Spring Modules, Spring Configurations, Wiring Bean, A Simple Example, Java Application Vs Spring Application Unit II : Beans and Containers Hours : 08 Spring Containers, Spring Configuration File, Spring Beans, Using the Container, The BeanFactory Interface, Singleton vs. Prototype, Bean Naming, Dependency Injection, Setter Injection, Constructor Injection Unit III : The Application Context, Data Validation and Conversion Hours : 10 The ApplicationContext Interface, Accessing Application Components, Accessing Resources, Internationalization with MessageSource, Application Events, The Validator Interface, The ValidationUtils Class, Validator Example, Testing the Validator, Property Editors, Custom Property Editors Unit IV : Aspect‐Oriented Programming Hours : 06 AOP Concepts, Join Points, Point Cuts, Advice, AOP Proxies, Configuration of Aspects ‐ Types of Advice, AOP Example Unit 5: Spring and Persistence Hours : 09 Working with the HSQLDB Database, Integration with JDBC, Use of JdbcTemplate Class, Exception Translation, Updating with the JdbcTemplate Queries using the JdbcTemplate, Mapping Results to Java Objects, Introduction to Object Relational Mapping, What is Hibernate?, The HibernateTemplate class, Hibernate Configuration Files, Mapping Classes and Fields for Hibernate, Creating and Saving a New Entity, Locating an Existing Entity, Updating an Existing Entity, Hibernate Sessions, Hibernate Query Language, Executing Queries Unit 6: Spring Web MVC Hours : 09 What is Spring Web MVC?, Setting Dispatchers, Loading Configuration Files, Writing a Controller, Types of Controller, Configuring the Controller, Setting of Handler Mapping, Handler Mapping Options, Adding a View Resolver, Defining Views, Spring Tag Library, Adding a Message Bundle, Adding Business Classes, Handling a Form

Integrating Hibernate with Spring MVC – Accessing Database, Storing Form Values and Retrieving Data from Database. Core Books:

1. Craig Walls, Ryan Breidnbach: Spring in Action, 3rd Edition. 2. Rod Johnson, Juergen Hoeller, Alef Arendsen, Thomas Risberg, Colin Sampaleanu:

Professional Java Development with the Spring Framework. Reference Books:

1. Rod Johnson: J2EE Design and Development, ISBN: 9780764543852 2. Rod Johnson: J2EE Applications Without EJB, Wiley Publication. 3. API Documentation (http://www.springsource.org/spring‐framework#documentation)

Web References:

1. http://static.springsource.org/spring/docs/3.0.x/spring‐framework‐ 2. reference/html/overview.html 3. http://www2.parc.com/csl/groups/sda/publications/papers/Kiczales‐ECOOP97/for‐

web.pdf 4. http://netbeans.org/kb/docs/web/quickstart‐webapps‐spring.html

CA824:Procurement, Implementation and Management of IT systems (200 Marks)

Credit Hours: 07

Objectives of the Course:

• Understand Information System Procurement Process. • Implementation of Project management planning process • Enable students to learn various aspects of IT system Implementation, training and

maintenance • Enable students to deal with risk management in IT systems

Prerequisite: No additional prerequisite required. Learning Outcomes: During sessions, concepts of IT system procurement, estimation, maintenance and risk management is covered. During practical sessions, the entire project and activity planning process in implemented through various project management software Instructional Methods & Pedagogy: Upon successful completion of the course, the students will be able to understand concepts of IT system procurement, implementation and management of IT systems. It also implements the whole project planning process with help of automated tool.



1 Procurement Process of IT Systems 08

36

2 Estimation of IT Systems 083 Activity Planning of IT Systems 084 Risk Management and Controlling of IT Systems 085 Implementation, Training and Education of IT

Systems 08

6 Maintenance and Reengineering of IT Systems 08



Total: 84

Detailed Syllabus:

Unit ‐ I : Procurement Process of IT Systems Hours : 08 Identify User requirements, System Requirements‐ Functional and Non Functional, Requirement Engineering Process‐ Feasibility Study, Requirement Elicitation and Analysis, Requirement Validation, Requirement Management and Requirements documentation, Risks of IT Systems‐ People issues, Process Risks, Operation and Maintenance issues, Make or Buy Decision. Unit ‐ II : Estimation of IT Systems Hours : 08 The basis for IT Systems estimating, IT System effort estimation techniques, Decomposition Techniques, Empirical estimation models of IT Systems Unit ‐ III : Activity Planning of IT Systems Hours : 08 Objectives of activity planning, IT Systems and activities, Sequencing and Scheduling activities, Networking Planning Models, Formulating a Network Model, Critical Path Network Unit ‐ IV : Risk Management and Controlling of IT Systems Hours : 08 Nature of Risks, Types of Risks, Managing Risks, Hazard Identification and analysis, Risk Planning and control, Evaluating Risks to the schedule, IT System control cycle, Visualizing Progress‐ Gantt Chart, Time Line , Ball Chart, Cost Monitoring using Earned Value Analysis Unit‐ V : Implementation, Training and Education of IT Systems Hours : 08 Objectives of IT System implementation, Methodologies for Implementing IT Systems, Different phases of IT Systems implementation, People involved in IT System Implementation, Overview of Training, Need and Importance of Training, Training Phases, Training Strategies Unit ‐ VI : Maintenance and Reengineering of IT Systems Hours : 08 IT Systems maintenance, Supportability, Reengineering, Business Process Reengineering, IT System Reengineering, Reverse Engineering, Restructuring, Forward Engineering, Economics of Reengineering Core Books:

1. Roger S. Pressman, Software engineering – A Practitioner’s Approach , seventh edition, ISBN: 978‐007‐126782‐3, McGraw‐Hill Publication,2010.

2. Bob Hughes & Mike Cotterell, Software Project Management,fourth edition, McGraw‐Hill Publication.

3. Alexis Leon, ERP Demystified, second edition, McGraw‐Hill Publication. 4. Teresa Stover, MS Office Project 2007 Inside Out, PHI.

Reference Books:

1. Ian Sommerville ,Software engineering, eighth edition, ISBN: 978‐81‐317‐2461‐3, Pearson Education.

2. Richard Fairley, Software engineering concepts, McGraw‐Hill Publication. 3. Pankaj Jalote, Software Project Management,Pearson Education.

Web References:

1. http://www.ittoday.info/Articles/Managing_IT_Procurement_Process.htm 2. http://www.spc.ca/resources/metrics/software_estimation.pdf 3. http://luxor.acadiau.ca/library/ASAC/v27/content/authors/m/misra,%20subhas/DIFFER

ENT%20TECHNIQUES.pdf 4. http://aiken.isy.vcu.edu/professional/publications/papers/synergy.p

CA825:Advanced Network Management and Security (200 Marks)

Credit Hours: 07

Objectives of the Course: The objective of this course is to provide an understanding for advanced network management and some concepts of Networking Security. Prerequisite: Operating Systems concepts and Network Technology. Learning Outcomes: Upon successful completion of the syllabus students shall be able to understand the concepts and functionalities of Advanced Network Management like overview of network design, theory and algorithms for network design and network management methods and protocols. Students also will aware with concepts of Network Security like classical encryption techniques, public key cryptography, authentication and hash function. Instructional Methods & Pedagogy: The course will start with a brief introduction of Advanced network management and security, and then cover the major components of Advanced network management and security. During theory lectures, in advanced network management: overview of network design, theory and algorithms for network design and network management methods and protocols will be discussed in depth and in network security: classical encryption techniques, public key cryptography, authentication and hash function will be discussed in detail.



1 Introduction to Network Design & Management

04

36

2 Network Design 083 Network Management & it’s Protocols 124 Introduction to Advanced Cryptography 085 Public Key Cryptography 086 Authentication and Hash Function 08



Total: 84

Detailed Syllabus:

Unit ‐ I : Introduction to Network Design & Management Hours : 04 Overview of Network Design: Major networking trends in industry, Centralized network design, Distributed network design, WAN vs. LAN, voice vs. data network design and planning, examples of Network Design. Unit ‐ II : Network Design Hours : 08 It contains Basic Theories and Algorithms, Review of queuing theory, Representation of networks using graph theory, Drop algorithm, Common network topologies, circuits, connections, hardware and the transmission types along with the fundamental of bridging, switching and routing. Unit ‐ III : Network Management & it’s Protocols Hours : 12 Configuration and accounting management, Fault Management, Algorithms for spanning trees, max-flow, shortest path problems for routing in network and routing for mobile hosts. Congestion and Traffic Control : Congestion Prevention Policy, Congestion control in virtual circuit subnets, congestion control in datagram subnets, Load shedding, Jitter control.Network Management Protocols : Introduction, Network Management model, Introduction to SNMP Architecture, Network Management Goals and SNMP Unit ‐ IV : Introduction to Advanced Cryptography Hours : 08 OSI Security Architecture, Classical Encryption techniques, Cipher Principles, Data Encryption Standard, Block Cipher Design Principles and Modes of Operation, Evaluation criteria for AES, AES Cipher, Triple DES, Placement of Encryption Function, Traffic Confidentiality. Unit ‐ V : Public Key Cryptography Hours : 08 Key Management, Diffie‐Hellman key Exchange, Elliptic Curve Architecture and Cryptography, Introduction to Number Theory, Confidentiality using Symmetric Encryption, Public Key Cryptography and RSA. Unit ‐ VI : Authentication and Hash Function Hours : 08 Authentication requirements, Authentication functions, Message Authentication Codes, Hash Functions, Security of Hash Functions and MACs, MD5 message Digest algorithm, Secure Hash Algorithm, RIPEMD, HMAC Digital Signatures, Authentication Protocols, Digital Signature Standard. Core Books :

1. William Stallings, "Cryptography And Network Security ‐ Principles and Practices", Prentice Hall of India, Third Edition, 2003.

2. Darren Spohn ,Data Network Design, 3rd Edition , TMH. 3. Robert S. Cahn, Wide area network design: concepts and tools for optimization, Morgan

Kaufmann Publisher. 4. Andrew S Tanenbaum ,Computer Networks, 4th edition., Pearson Edition. 5. Michael J Martin, Understanding the Networks : A Practical Guide to Internetworking,

1st ,TechMedia.

Reference Books :

1. Atul Kahate, "Cryptography and Network Security", Tata McGraw‐Hill, 2003. 2. Bruce Schneier, "Applied Cryptography", John Wiley & Sons Inc, 2001. 3. B.A.Forouzan ,Data Communication & Networking, 4th edition, , McGrew Hill.

Web References:

1. http://www.ccse.kfupm.edu.sa/~sqalli/042/coe444/lectureNotes/COE‐444‐042‐LectureNotes‐Chap6.pdf

2. http://math.scu.edu/~eschaefe/crylec.pdf 3. https://engineering.purdue.edu/kak/compsec/NewLectures/Lecture12.pdf 4. http://cseweb.ucsd.edu/~mihir/papers/gb.pdf 5. http://cseweb.ucsd.edu/~mihir/papers/kmd5.pdf


FOR

MCA PROGRAMME (5TH SEMESTER)


Effective from Effective from Academic Year 2013‐14 Course Code



Internal Exter nal


Study Tests Term

work Tests

CA910 Open Source Frameworks 4 3 7 7 10 20 70 15 15 70 200 CA911 Data Mining and Analytics 4 3 7 7 10 20 70 15 15 70 200 CA912 Mini Project ‐ 6 6 6 ‐ ‐ ‐ 30 70 100 CA913‐CA916

Elective 2 4 3 7 7 10 20 70 15 15 70 200

Seminar ‐ 2 2 2 ‐ ‐ ‐ ‐ ‐ ‐ ‐ Remedial Session / Quizzes /

Case Study Preparation ** ‐ 1 1 1 ‐ ‐ ‐ ‐ ‐ ‐ ‐

12 18 30 30 300 400 700

Elective Set 2

1. CA913:Collaboration Technologies (ONLY for students who have completed Windows Communication Foundation Framework offered in Elective Set 1)

2. CA914:Web Technologies (ONLY for students who have completed Frameworks and Applications offered in Elective Set 1)

3. CA915:Advance MIS 4. CA916:Intrusion Detection and Computer Forensics

CA910:Open Source Frameworks (200 Marks)

Credit Hours: 07

Objective: The objective of this course is to develop an understanding of the elements of Open source framework based on PHP and MySQL. WordPress is a free and open source blogging tool and content‐management system (CMS), which runs on a web hosting service and Includes plug‐in architecture and template system. Prerequisite: CA819: Open Source Technology. Learning Outcomes: upon successful completion of the syllabus students shall be able to develop Blog and CMS web application using WordPress. Instructional Methods & Pedagogy: During theory lectures the emphasis will be given on the Development of WordPress based web application; students will be introduced to framework standards like theme and plug‐in development. During Practical sessions, students will implement the concepts which are discussed in lecture.


Sr.No.

Title of the Unit

Minimum No of Hours

Theory Practical

1. Introduction to WordPress 07

36

2. Content management & Creating Widget in wordPress

08

3. Basic Theming in WordPress 09

4. Advance Theme in WordPress 08

5. Plugin Creation in WordPress 08

6. Users and Roles & Performance and Security 08



Total: 84

Detailed Syllabus

Unit – I: Introduction to WordPress Hours: 07

Introduction to framework, Why wordpress and its benefits, Sites built with wordpress , Installing and upgrading wordpress, installing themes, installing plugins, working with Dashboard and Settings.

Unit‐ II: Content management & Creating Widget in WordPress Hours: 08

Working with content, Post, Pages, Media Files, links and feeds, importing blogs and HTML files, after importing fixing what’s broken. Creating Widget: Basic Widget, Dashboard Widget

Unit – III: Basic Theming in WordPress Hours: 09

Creating a Basic Theme: Using Widgets, Using Menus, Using Header and Background images, Turning HTML into a Theme, Template Tags, Theme Files, Theme File hierarchy, Listing Comments, Including Additional Files, Styling Content, Changing Appearance Based on Context, Creating Navigation Menus, Theme Functions, Child Themes.

Unit – IV: Advance Theme in WordPress Hours: 08

Modifying the Loop, Multiple Loops, Accessing Post Information outside the loop search, Engine Optimization, Adding Scripts and Style sheets, Database Errors and Maintenance Messages, Theme Options, Theme Frameworks, Distributing Themes.

Unit – V: Plugin Creation in WordPress Hours: 08

Creating a Template Tag, Adding an Options Page, Settings API, Wrapping Up, Plugin Possibilities, and Hooks: Filters and Actions, Variations on Option Pages, Publishing a Plugin.

Unit – VI: Users and Roles & Performance and Security Hours: 08

Users and Roles: Users, Extending User Profiles, Roles, And Roles in Action: Notifications, Moderation and workflow, Changing, Creating and Removing Roles.

Performance and Security : Caching, Permalinks and Performance, Tracking Down Performance Problems, Security Logins, Removing The Meta Generator Tag, File Permissions, Changing File Locations, Database Security

Core Books:

1. Stephanie Leary: Beginning WordPress 3, Apress Publication.

2. Ric Shreves and Jean‐Beptiste Jung: WordPress 3 CookBook, PACKT publishing

Reference Books:

1. Jeff Siarto : Head First Wordpress, O’Reilly Publication.

2. Rachel McCollin, Tessa Blakeley Silver: WordPress Theme Development, 3rd Edition, PACKT publishing

3. Brian Bondari, Everett Griffiths : WordPress 3 Plugin Development Essentials, PACKT publishing

4. Kent Mauresmo and Anastasiya Petrova : SEO for WordPress: How To Get Your Website on Page #1 of Google...Fast! (Volume 1), Vallon Investments, Inc Publication.

Web References:

1. http://codex.wordpress.org/WordPress_Lessons [For Basic and Advance concept of Wordpress]

2. http://www.siteground.com/tutorials/wordpress/ [Basic and Advance concept with video lectures]

3. http://videos.wpbeginner.com/ [wordpress video tutorial]

CA911: Data Mining and Analytics (200 Marks)

Credit Hours: 07 Objectives of the course: To understand how to turn data into information and turn information into knowledge. How to provide a consolidated, flexible and meaningful data repository to end user for reporting and analysis through Data Warehousing analytics Concepts. How to generate meaningful patterns in large quantity of data automatically or semi automatically through concepts of data mining. To be able to apply these concepts to develop meaningful applications and to know the recent trends of data mining.

Prerequisite: CA711: Database Technologies, CA818: Advanced Database Technologies

Learning Outcomes: Upon successful completion of the syllabus students shall be able to learn how to develop data warehouse of any organization and how to retrieve hidden and useful data from large data set using techniques of data mining.

Instructional Methods & Pedagogy: During theory lectures concepts of data mining with related technologies will be discussed. In practical sessions data mining tools will be introduced and will be used to design meaningful applications. Through case study based approach how data mining concepts are to be implemented in real application will be discussed.


Unit No.

Title of the Unit Minimum Number of Hours

Theory Practical

1. Introduction to Data Warehousing & Mining 10

36

2. Data Warehouse and OLAP Technology for Data mining

06

3. Data Pre‐processing and Data Mining Primitives

06

4. Mining Association rule in large Databases 09

5. Classification and cluster analysis 09

6. Applications and Trends in Data Mining Applications

08



Total: 84

Detailed Syllabus:

Unit I: Introduction to Data Warehousing & Mining Hours: 10

An overview and definition along with clear understanding of the four key‐words appearing in the definition. Differences between Operational Database Systems and Data Warehouses; Difference between OLTP & OLAP. Overview of Multi‐dimensional Data Model, and the basic differentiation between “Fact” and “Dimension”; Multi‐dimensional Cube. Concept Hierarchies of “Dimensions” Parameters: Examples and the advantages. Star, Snowflakes, and Fact Constellations Schemas for Multi‐dimensional Databases. Measures: Their Categorization and Computation.

An Overview: What is Data Mining, Data Mining – on What Kind of Data, Data Mining Functionalities – What Kind of Patterns Can be Mined, Concept/Class. Description: Characterization & Discrimination; Mining Frequent Patterns, Associations, and Correlations, Classification & Prediction; Cluster Analysis, Outlier Analysis.

Classification of Data Mining Systems, Data Mining Task Primitives, Integration of a Data Mining System with a Database or Data Warehouse System, Major Issues in Data Mining.

Unit II: Data Warehouse and OLAP Technology for Data mining Hours: 06

The Design of a Data Warehouse: A Business Analysis Framework; The Process of Data Warehouse Design, A 3‐Tier Data Warehouse Architecture; Enterprise Warehouse, Data mart, Virtual Warehouse.

Discovery‐Driven Exploration of Data Cubes; Complex Aggregation at Multiple Granularity: Multi‐feature Cubes, Constrained Gradient Analysis of Data Cubes.

Unit III: Data Pre‐processing and Data Mining Primitives Hours: 06

The need for Pre‐processing, Descriptive Data Summarization, Data Cleaning: Missing Values, Noisy Data, Inconsistent Data, Data Integration & Transformation.

Data Cube Aggregation; Attribute Subset Selection, Dimensionality Reduction: Basic Concepts with example. Reduction Methods: Regression & Log‐linear Models, Histograms, Clustering, Sampling.

Data Discretization & Concept Hierarchy Generation, Binning, Histogram Analysis, Entropy‐based Discretization.

Unit IV: Mining Association rule in large Databases & Correlation Hours: 09

Basic Concepts: Market Basket Analysis; Frequent Itemsets, Closed Itemsets, and Association Rules.

Frequent Pattern Mining: A Roadmap

Apriori Algorithm: Finding Frequent Item sets Using Candidate Generation; Generating Association Rules from Frequent Item sets; Improving the Efficiency of Apriori.

From Association Mining to Correlation Analysis; Strong Rules Are Not Necessarily.

Interesting: An Example; From Association Analysis to Correlation Analysis.

Unit V: Classification and cluster analysis Hours: 09

An Overview, Basics of Supervised & Unsupervised Learning, Difference between Classification & Prediction, Criteria for Comparing Classification.

Methods, Classification by Decision Tree Induction, Tree Pruning, Extracting Classification Rules from Decision Trees.

Bayesian Classification: Bayes Theorem, Naïve Bayesian Classification, Bayesian Belief Networks, An Overview of Other Classification Methods.

Prediction: Linear & Multiple Regression, Non‐linear Regression, Other Regression Models.

Classifier Accuracy: Estimating the Accuracy, Increasing the Accuracy, Accuracy Parameters – Sensitivity, Specificity, Precision.

Unit VI: Applications and Trends in Data Mining Applications Hours: 08

Data mining research potential. Selection of data mining tool and technique.

Example of commercial data mining applications.

Application of data mining in real word problems like banking sector, telecommunication, mobile application.

Another aspect of data mining: Text Mining, Web Mining, Education Data Mining and Opinion Mining.

Core books:

1. Jiawei Han & Micheline Kamber: Data Mining: Concepts & Techniques, 2nd Edition, Morgan Kaufmann Publishers.

Reference books:

1. Paulraj Ponniah: Data Warehousing Fundamentals: A Comprehensive Guide for IT Professionals, Wiley‐India.

2. Daniel T. Larose: Data Mining Methods & Models, Wiley‐India. 3. Vikram Pudi & P. Radhakrishnan: Data Mining, Oxford University Press. 4. Alex Berson & Stephen J. Smith: Data Warehousing, Data Mining & OLAP, Tata McGraw‐Hill. 5. Michael J. A. Berry & Gordon S. Linoff: Data Mining Techniques, Wiley‐India. 6. Pang‐Ning Tan, Michael Steinbach, Vipin Kumar: Introduction to Data Mining, Pearson

Education. 7. A B M Shawkat Ali, Saleh A. Wasimi: Data Mining : Methods and Techniques, Cengage

Learning. 8. Rajan Chattamvelli: Data Mining Methods, Narosa Publishing House 9. Sam Anahory, Dennis Murray: Data Warehousing in the real World, Pearson Education. 10. Pieter Adriaans, Dolf Zantinge: Data Mining, Pearson Education. Web References:

1. http://technet.microsoft.com/en‐us/library/dd334421%28v=sql.100%29.aspx

[For Data Mining Analysis Services] 2. http://infogoal.com/datawarehousing/business_intelligence.htm [For architecture of Data

Mining Applications] 3. http://www.toadworld.com/platforms/sql‐server/w/wiki/9478.introducing‐data‐

mining‐tutorial.aspx [For Business Intelligence Tutorials and Videos] 3. http://www.oracle.com/technetwork/database/bi‐datawarehousing/dbbi‐tech‐info‐ Lib‐

094662.html [For Video tutorials of data mining]

CA912: Mini Project (100 Marks)

Credit Hours: 06

OBJECTIVE: The project work constitutes a major component in most of the professional programmes and it is to be carried out with due care and should be executed with seriousness by the students. The objective of the project is to motivate them to work in emerging / latest technologies, help the student to develop ability to apply theoretical and practical tools/techniques to solve real life problems related to industry, academic institutions and research laboratories, this project will helps the student make ease and provides enough experience to carry our the larger project in the sixth semester. STEPS INVOLVED IN THE PROJECT WORK: The complete project work should be done by the student only. The role of guide should be about guidance wherever any problem encounters during project. The following are the major steps involved in the project, which may help you to determine the milestones and regulate the scheduling of the project: • Select a suitable topic of your interest. • Prepare the project proposal in consultation with the project guide. • Performa for Approval of Project duly filled and signed by both the student and

Project Guide with date. • Prepare project report according to the specific format. EVALUATION OF PROJECT/DISSERTATION WORK: The project report shall normally be written in English in the specified format and shall be characterized by significant contribution to knowledge in the field. Normally two copies of the report are to be submitted for evaluation. The Project report prepared according to approved guidelines and duly signed by the supervisor(s) and the Head of the Department shall be submitted to the Head of the Institution. The evaluation scheme of Project is as under:

Course Course Title

Teaching Scheme Internal End Semester Examination

Total Contact Hours Credit Continuous Evaluation

Viva Inst. Industr

y Total

CA912 Mini Project

4 ‐ 4 2 30 70 100

The internal evaluation of project is done based on progress reports and internal presentations.

The final evaluation of the project will be based on the project report submitted and a Viva‐Voce Examination by a Board of Examiners. If a candidate fails to submit the project report on or before the specified deadline, he/she is deemed to have failed in the Project Work and shall re‐enroll for the same in a subsequent semester. If a candidate fails in the viva‐voce examinations of Project work he/she shall resubmit the project report within specified duration decided by university. The resubmitted project will be evaluated during the subsequent academic session. A copy of the approved project report after the successful completion of viva examinations shall be kept in the library of the college / institution. Web References: 1. http://www.shipoff.com/software‐development‐resources/ [Software development

Resources] 2. http://www.techrepublic.com/topic/software‐development/[Software development tips

and tutorials]

CA913: Collaboration Technologies (200 Marks)

Credit Hours: 07 Objectives of the Course: This syllabus is designed to familiarize students with role and requirements of collaboration technologies in business organization. It also introduces them with creation and management personalized information on intranet and internet.

Prerequisite: Basic programming knowledge of ASP.NET and basic knowledge of networking.

Learning Outcomes: Upon successful completion of the syllabus students shall have working understanding of collaborative technologies available in industry. Students will also be able to develop, test and deploy intranet applications independently using collaborative technologies.

Instructional Methods & Pedagogy: During theory lectures illustrations emphasizing the need for various features of collaboration technologies will be given. During practical sessions, students will be required to develop intranet applications using concepts discussed during class. Students will be required to submit a report on result of group task assigned to them at beginning of course.


Unit No.


Theory Practical

1. Introduction to collaboration technologies 08

36

2. Working with List, Libraries and Documents 08

3. Working with media 08

4. Data manipulation and business processes 08

5. Personalization using SharePoint 08

6. Security with SharePoint 08



Total: 84

Detailed Syllabus:

Unit I: Introduction to collaboration technologies Hours:08

Introduction to collaboration technologies, Comparison between different collaboration technologies, Overview of SharePoint Architecture, Objectives, features and components of SharePoint, Role of SharePoint Server in intranet, SharePoint Installation and Administration, Developing sites using SharePoint: Site Settings, Permissions and Creating Sites, Navigation, Content Pages and Content, Branding with Web Parts, Themes and Master Pages.

Unit II: Working with List, Libraries and Documents Hours:08

Overview of List: Creating, Adding and Editing List Items, Document Library: Creating, Editing and Uploading documents, Versioning of Data, Checking documents in and out from document library, working with Document Template and document Workspace.

Unit III: Working with Media Hours:08

Introduction to media sharing and asset library, Organizing with keywords and metadata, Tagging and uploading media files, adding media to SharePoint page.

Unit IV: Data Manipulation and Business Processes Hours:08

Configuring data source, Manipulating data with ASP.NET data controls, Overview of XSLT list view and data view, working with data view and data form web parts, Overview with custom workflow and custom list actions.

Unit V: Personalization using SharePoint Hours:08

Creating and managing blogs: Managing blog posts, managing blog comments, Creating and managing personal sites: Editing user profiles, Uploading content, Using note board, Introduction to searching information.

Unit VI: Security with SharePoint Hours:08

Introduction to security in SharePoint, Managing SharePoint groups, Creating and granting permissions to groups, Granting access to Lists, Libraries and individual items, Introduction to claim based authentication.

Core books:

1. Kathy Hughe: SharePoint Designers 2010, Unleashed, SAMs publication. 2. Olga M. Londer, Penelope Coventry: Microsoft SharePoint 2013 Step by Step, Microsoft

Press. 3. Jonathan Lightfoot and Chris Beckett: Microsoft SharePoint 2010: Plain & Simple, Microsoft

Press. Reference books:

1. Ted Pattison, Andrew Connell, Scot Hillier: Inside Microsoft SharePoint 2010, Microsoft Press.

2. Paolo Pialorsi: Microsoft SharePoint 2010: Developer’s reference, Microsoft Press.

Web References:

1. http://sharepoint‐tutorial.net [For introduction to collaborative technologies and installation of Microsoft Sharepoint]

2. www.fastsharepoint.com [For introduction to data controls and web part controls used with Microsoft Sharepoint]

3. http://www.codeproject.com/Questions/377837/Sharepoint‐tutorial‐for‐beginners [For tutorials and sample code snippets related to Microsoft Sharepoint]

CA914: Web Technologies (200 Marks)

Credit Hours: 07

Objectives: The objective of the course is to make the students familiar with web technology frameworks and to make them able to develop real world applications using them. Prerequisites: Object Oriented Concepts and Programming (CA709) and Enterprise Computing (CA815) Learning Outcomes: Upon successful completion of the syllabus students shall be able to understand the concepts of web technologies and apply web technologies concepts to develop web applications. Instructional Methods & Pedagogy: During theory sessions the students shall be introduced to common techniques and technologies for developing web based application and they shall explore Struts framework, AJAX and Web Services. During practical sessions students will be trained to develop various web applications using the studied frameworks.

Unit No.

Title of the Unit Minimum Number of hours

Theory Practical

1. Ajax Framework 06

36

2. The Struts Framework : Basics 08

3. The Struts Framework: Views, Results and Interceptors

10

4. The Struts Framework: Validation & Advanced Topics

10

5. Web Services Fundamentals 06

6. Java Web Services 08



Total: 84

Detailed Syllabus:

Unit I: AJAX Framework Hours:06

Ajax introduction, working, technologies, Working with Ajax XmlHttpRequest – XHR Create Object, XHR Request, XHR Response

Unit II: The Struts Framework: Basics Hours:08

Introduction ‐ Brief History of the Web, Framework, Creation of the Struts Framework, Struts1 and Struts2 Architecture, Configuration Files, Filter Dispatcher, Actions, Interceptors, Results and Result Types, Working with Actions

Unit III: The Struts Framework: Views, Results and Interceptors Hours:10

Building the views – Struts Tags, Data Tags, Control Tags, Other JSTL Tags

Results – Dispatching requests and responses, commonly used result types Using Interceptors – Built‐in interceptors, pre‐configured stacks, mapping interceptors, customized interceptors

Unit IV: The Struts Framework: Validation & Advanced Topics Hours:10

Validator framework – architecture, workflow, wiring actions, custom validator, Resource Bundles

Advanced topics – Annotations, Alternative method invocation, Dynamic Method invocation, Displaying wait pages automatically, CRUD operations, Tiles plugin

Unit V: Web Service Fundamentals Hours:06

Overview of traditional distributed computing and its drawbacks, Web Service overview and its advantages over distributed computing

Service Oriented Architecture (SOA) with its benefits, SOAP and Service Description overview. Interpretability: Web Service protocol support, WSE.

Unit VI: Java Web Services Hours:08

Types of Web Services: SOAP based services and RESTful services and difference between them, JAVA’s SOAP API, All about WSDL, SOAP handing, Implementing SOAP based Web Service

RESTful services: What is Rest? From @WebService to @WebServiceProvider, Implementing RESTful Web service as HTTPServlets.

Core books:

1. Sharanam Shah, Vaishali Shah: Struts 2 for Beginners, Shroff Publishers & Distributors, 2nd Edition.

2. Donald Brown, Chad Michael Davis, Scott Stanlick : Struts 2 in Action,Dreamtech press publication.

3. Martin Kalin : Java Web Services Up and Running by, O’Reilly Publication.

Reference books:

1. Chuck Cavaness :Programming Jakarta Struts, O’Reilly Publication. 2. Ethan Cerami : Web Services Essentials, O’Reilly Publication.

Web References:

1. http://www.tutorialspoint.com/struts_2/index.htm [For struts examples] 2. http://www.w3schools.com/ajax/default.asp [For ajax examples] 3. http://javapapers.com/category/web‐service/ [For web service examples] 4. http://www.ws‐i.org/ [For web service examples]

CA915: Advance Management Information Systems (200 Marks)

Credit Hours: 07

Objectives of the Course: The objective of this course is to provide significance of MIS in business processes and deeper understanding of design, implementation, usage and maintenance of information systems (such as Enterprise Resource Planning (ERP), Customer Relationship Management (CRM), Supply Chain Management (SCM) and Business Intelligence (BI) ).

Prerequisite: CA714: Management Information Systems

Learning Outcomes: Student will be able to understand enterprise resource planning as a management approach and how information systems can help promote ERP, understanding of the components of ERP systems and the differences between them. Also they will learn about business value of integrating supply chain management, customer relationship management, and enterprise resource planning systems together, how an organization can measure ERP success, choose ERP software, and use ERP in markets.

Instructional Methods & Pedagogy: During the Theory sessions, basic concepts of ERP will be covered with integaration of CRM and SCM. Emphasis will be given on how Business Intelligence can have impact on organisation sucessess. Industrial visits will be arranged in order to demonstrate actual functioning of such systems. Students will be required to carry out a case study of such system.

Unit No.


Theory Practical

1. Introduction to ERP 07

36

2. ERP Business Modules and ERP Market 08

3. ERP Implementation 09

4. ERP Present and Future 07

5. Customer Relationship Management and Supply Chain Management 08

6. Business Analytics 09



Total: 84

Detailed Syllabus:

Unit I: Introduction to ERP Hours:07

Introduction to ERP, Basic ERP Concepts, Justifying ERP Investments, Risks of ERP, Benefits of ERP. Unit II: ERP Business Modules and ERP Market Hours:08

Introduction to Business Modules of an ERP Package, ERP Marketplace and Dynamics, SAP AG, Oracle Corporation, PeopleSoft.

Unit III : ERP Implementation Hours:09

Implementation challenges, ERP Implementation Strategies, ERP Implementation Life Cycle, Pre Implementation Tasks, Requirements Definition, Implementation Methodologies. Unit IV: ERP Present and Future Hours:07

Enterprise Application Integration (EAI), ERP and e‐business, ERP, Internet and WWW – ERP II, ERP and Total Quality Management, Future Directions and Trends in ERP. Unit V: Customer Relationship Management and Supply Chain Management Hours:08

Introduction to CRM, Introduction to eCRM, Difference between CRM & eCRM, Features of eCRM, Implementing CRM, Introduction to Supply Chain Management, Creating Outcome‐Driven Tasks and Processes, Transportation Systems. Unit VI: Business Analytics Hours:09

ERP and Related Technology, Business Intelligence, Business Process Reengineering, Data Warehousing, Data Mining, On‐Line Analytical Processing (OLAP). Core books:

1. Alexis Leon : ERP Demystified, Tata Mc Graw Hill, 2008. 2. Thomas F. Wallace, Michael H. Kremzar : ERP: Making It Happen: The Implementers’ Guide

to Success with Enterprise Resource Planning, John Wiley & Sons, Inc., 2001. Reference books:

1. K. C. Laudon, J. P. Laudon : Management Information Systems, 11th Edition, Pearson Education, 2010.

2. W.S. Jawadekar : Management Information Systems, Tata Mc Graw Hill, 2004. Web References:

1. http://www.tutorialspoint.com/management_concepts/enterprise_resource_planning.htm [For ERP Concepts]

2. www.lesman.com/downloads/CRM2011‐Step‐by‐Step.pdf [For CRM Implementation]

CA916:Intrusion Detection and Computer Forensics (200 Marks)

Credit Hours: 07 Objectives of the Course: The primary objective of this course is to,

1) Understand when, where, how, and why to apply Intrusion Detection techniques in order to improve the security posture of an enterprise.

2) Apply knowledge of the fundamentals and history of Intrusion Detection in order to avoid common pitfalls in the creation and evaluation of new Intrusion Detection Systems.

Prerequisite: CA807: Network Technologies Learning Outcomes: Upon successful completion of this course, the students should be able to: Describe different threats and attacks to networks, How to identify them and solving out the problems related to it. Student will also get idea about the Fundamental of Computer Forensics & how it will be useful in real life. Instructional Methods & Pedagogy: During theory lectures, different types of network attacks will be discussed. Also, detection and prevention of attacks will be discussed. Through case study based approach students will be asked to identify different attacks and how to resolve it.

Unit No. Title of the Unit

Minimum Numbers of hours

Theory Practical

1. Concepts and Definitions 07

36

2. System Security 08

3. Network Attacks 08

4. Analysis Schemes 10

5. Responses 07

6. Computer Forensics Fundamentals 08



Total: 84

Detailed Syllabus:

Unit I: Concepts and Definitions Hours: 07

An introduction to Intrusion Detection, Security Concepts: Definition of Computer Security, Threat, Vulnerability, Security Policy Intrusion Detection Concepts: Architecture, Monitoring Strategy, Analysis Type, Timing, Goals of Detection, Control Issues, Determining Strategies for Intrusion Detection,

Network defense tools: Firewalls, Intrusion Detection, Traffic shapers, and filters

Unit II: System Security Hours: 08

Intruders, Intrusion detection, Password management

Malicious software: Viruses and related threats, virus countermeasures Firewalls: Firewall design principles – Firewall configurations – Trusted systems

Unit III: Network Attacks Hours: 08

Attack Taxonomies, Privilege Escalation Attack: Buffer Overflow Attacks, Race condition, Man‐in‐the‐middle Denial of Service (Dos) and Distributed Denial of Service (DDos) Attacks: Detection approaches for Dos & DDoS Attacks, Prevention and Response for DoS & DDoS Attacks, Examples related to it. Worm Attacks: Modeling and Analysis of Worm Behaviors, Detection and Monitoring, Worms Containment, Examples Routing Attacks: OSPF Attacks, BGP Attack

Unit IV: Analysis Schemes Hours: 10

Defining Analysis, Detecting Intrusion Model for Intrusion analysis: Performing Analysis, Feedback and refinement Techniques: Misuse Detection: Pattern Matching, Rule‐based Techniques, State‐based Techniques Anomaly Detection: Advanced Statistical Models, Rule based Techniques, Biological Models Alternative detection Schemes, Specification Based Detection, Hybrid Detection

Unit V: Responses Hours: 07

Requirements for response: Operational Environment, System purpose & priorities, Regulatory or statutory requirements Types of Response: Active Response, Passive Response

Unit VI: Computer Forensics Fundamentals Hours: 08

Introduction to Computer Forensics, Use of Computer Forensics in Law, Computer Forensics Services Computer Forensics Technology: Type of Military Computer Forensics Technology, Type of Law Enforcement Computer Forensics Technology, Type of Business Computer Forensics Technology, Specialized Forensics Techniques, Hidden Data and how to find it, Spyware and adware, Internet Tracing Methods, Security and wireless Technologies Systems: Internet Security Systems, Intrusion Detection Systems, Firewall Security Systems

Core books:

1. Rebecca Gurley Bace : Intrusion detection, ISBN: 1‐57870‐185‐6, Macmillan Technical Publishing

2. Ali A. Ghorbani, Wei Lu, Mahbod Tavallaee : Network Intrusion Detection and Prevention, Springer, ISBN : 978‐0‐387‐88771‐5

3. Paul E. Proctor : The Practical Intrusion Detection Handbook, Pearson Publication, ISBN‐10: 0130259608 , ISBN‐13: 9780130259608

4. John R. Vacca : Computer Forensics Computer Crime Scene Investigation, Volume 1, 2nd Edition, Course Technology

5. Ryan Trost : Practical Intrusion Analysis Prevention and detection for the Twenty – First Century, Pearson Publication, ISBN‐13 : 978‐0‐321‐59180‐7

Reference Books:

1. Michael Sheetz: Computer Forensics: An essential guide for accountants, lawyers, and managers, John Wiley & Sons, ISBN : 978‐0‐471‐78932‐1

2. Stephen Northcutt, Judy Novak : Network Intrusion Detection, 3rd Edition, New Riders Publishing

Web References:

1. http://www.routeralley.com/ra/docs/intro_ids.pdf [For Intrusion Detection] 2. http://opensecuritytraining.info/HTID.html [For Intrusion Detection] 3. http://en.wikipedia.org/wiki/Computer_forensics [For Computer Forensic]


FOR

MCA PROGRAMME (6TH SEMESTER)


CA917: Project Work Credit Hours: 30 1. Objectives:

• Application of knowledge and techniques learnt in theoretical classes for developing the s/w for real problems or inventing new things related to original concept.

• Gives an insight into the working of the real organizations/companies. • Gaining deeper understanding in specific functional areas. • Helps in exploring career opportunities in their areas of interest.

2. Project/dissertation work: Students of MCA have to do the Project work in an Industrial/ Research Organization of computer field. Project work shall be carried out under the supervision of a qualified teacher in the Department as well as an expert from organization. Students have to meet the institute supervisor periodically and to attend the project/dissertation review meetings for evaluating the progress. The Project work shall be pursued for a minimum of 16 weeks during the semester. 2.1 MORI Principle to choose the topic:

Final semester project work is important and challenging element of MCA study. Selection of topic of project work is very crucial and important aspect of that. Following are important principles that will help students to select the appropriate topic of project work.

• Manageable: your project topic must be sufficiently focused so that it is possible for you to do the topic justice within the available time (one semester). You may have a real interest in, say, 'the impact of technology computers on Indian Economic Growth since Independence, but you certainly won't be able to cover this topic in any detail in the space of one semester

• Original: this relates to the above point, since a topic that is focused and manageable is more likely to be one that has not been written about too extensively, thus leaving room for your original contribution. Ideally you will find an interesting and well‐chosen topic which will impress those marking your work.

• Relevant: your project should clearly be relevant to some aspect of your studies, but it might also be relevant to your plans for, say, postgraduate study or a career. The dissertation may also be relevant in the sense that it plays to some of your established strengths, such as a particular course module or topic that you have enjoyed studying and in which you have previously done well.

• Interesting: you are obviously more likely to enjoy and be successful in your dissertation if it is of real interest to you and to those marking your work. Ask yourself if you are

sufficiently committed to your idea to be able to give it your best throughout the duration of your project. You should also ascertain whether your supervisor finds the idea interesting during your initial discussions with her or him.

2.2 Evaluation of project/dissertation work: The project report shall normally be written in English in the specified format and shall be characterized by significant contribution to knowledge in the field. Normally two copies of the report are to be submitted for evaluation. The Project report prepared according to approved guidelines and duly signed by the supervisor(s) and the Head of the Department shall be submitted to the Head of the Institution. The evaluation scheme of Project/Dissertation is as under:

Teaching Scheme Internal End Semester Examination TotalContact Hours Credit Continuous

EvaluationReport Presentation & Viva

Inst. Industry Total

2

28

30

30 200 200 400 800

The internal evaluation of project is done based on progress reports and internal presentations. The final evaluation of the project will be based on the project report submitted and a Viva‐Voce Examination by a Board of Examiners. If a candidate fails to submit the project report on or before the specified deadline, he/she is deemed to have failed in the Project Work and shall re‐enroll for the same in a subsequent semester. If a candidate fails in the viva‐voce examinations of Project he/she shall resubmit the project report within specified duration decided by university. The resubmitted project will be evaluated during the subsequent academic session. A copy of the approved project report after the successful completion of viva examinations shall be kept in the library of the college / institution. Web References: 1. http://www.microtoolsinc.com/Howsrs.php [ For Software Requirement Specification

Guidelines] 2. http://techwhirl.com/writing‐software‐requirements‐specifications/ [ For goals of SRS] 3. https://kepler‐project.org/developers/reference/software‐development‐guidelines [ For

Software Development Guidelines]