MCA -Master of Computer Applications 5th Semester - University Syllabus and Classes of MCA - MCA Fifth Semester Coaching Classes in Nagpur - MCA Syllabus of Nagpur University

Atlanta Computer Institute Conducts Tuition Classes for MCA Semester 1, MCA Semester 2, MCA Semester 3, MCA Semester 4,and MCA Semester 5. We also provide final year Projects of MCA Students and guidance for Final Year Projects with Certificates.

MCA. Semester- 5

5CSA-1 Data Warehousing and Data Mining

5CSA-2 Embedded Systems

5CSA-3 Network Security

5CSA-4 Elective –I

Legal Aspects of IT

Software Engineering

System Management

5CSA-5 Elective –II

VB.NET

ASP.NET

5CSA-6 Practical –I (Based on Embedded System, Network Security & Data Warehousing & Data Mining)

5CSA-7 Practical –II (Based on Elective–I or Elective–II)

5CSA-1 : Data Warehousing And Data Mining

Unit - 1
Characteristics of A Data Warehouse, Data Mart, Type of Data Mart, Loading a Data Mart, Metadata for a Data Mart, Data Model for a Data Mart, Maintenance of a Data Mart, Nature of a Data in a Data Mart, Software Components for a Data Mart, Tables in Data Mart, External Data, Reference Data, Performance Issues, Monitoring Requirements for a Data Mart, Security in Data Mart.

Unit - 2
OLTP and OLAP Systems, Data Modeling, Star Schema for Multidimensional view, Multifact Star Schema, Categories of OLAP Tools, Managed Query Environment (MQE), Cognos Powerplay, IBI Focus Fusion, Pilot Software, Arbor Web, Information Advantage Web OLAP, Micro strategy DSS Web, Brio
Technology, OLAP Tools and the Internet

Unit - 3
Data Mining: Introduction, From Data Warehouse to Data Mining, Steps of Data Mining, Data Mining Algorithm, Database segmentation, Predictive modeling, Link Analysis, Tools for Data Mining.

Unit - 4
Developing a Data Warehouse, Building a Data Warehouse, Data Warehouse Architectural Strategies, Design Considerations, Data Content, Metadata, Distribution of Data, Tools for Data Warehousing, Performance Considerations, Crucial decisions in Designing a Data Warehouse, Various technological considerations.

Unit-5
Application of Data Warehousing & Data Mining, National Data Warehouses, Census Data,Areas for Data Warehousing and Data Mining with Case studies.
Case Study - 1: Data Warehousing in State Government.
2: Data Warehousing for Ministry of Commerce.
3: Data Warehousing in Hewlett-Packard.
4: Data Warehousing in World Bank,
Books

Data Warehousing - C.S.R. Prabhu, PHI Publication.
Web Warehousing & Knowledge Management - Mattison, fata McGraw Hill.
Data Warehousing - Amitesh Sinha, Thomson Publication.
Data Mining - Claude Seidman, PHI Publication.

5CSA-2 : Embedded Systems

Unit - 1
Introduction to embedded systems, Microprocessor, Micro controllers and DSPs, Types of memory used, Types of RAM and ROM, Memory mapped IO and I/O mapped 10, Compilers, Debuggers, Emulators and Simulators, Real Time Systems, Soft and Hard real-time systems, Real-time Operating Systems, Windows CE Vs VxWorks, Characteristics of Embedded System, Throughput, Response, Reliability, Memory Space, Power consumption, Cost Issues in Embedded System, Testing, Debugging, Installation

Unit - 2
Introduction to Windows CE.NET Platform Builder, Creating a custom OS using Windows CE.NET, Role of OEM Adaption Layer, Configuration Files, Boot Loader and Device Drivers, Introduction various OS features, Debugging the custom OS, Creating and Adding Board Support Packages (BSPs), Catalog Editor

Unit - 3
Creating and Exporting MFC SDKs, Creating embedded applications in VC+ + , Introduction to .NET and C#, Creating applications in C#, Writing multithreaded applications, Testing multithreaded applications using Remote Kernel Tracker, Synchronization
Unit - 4
Windows CE.NET Architecture, Processes and Threads, Memory management, Virtual Memory, Heap and Stack, Real-time features, Interrupt latency, Nested Interrupts, Interrupt Priorities Priority Inversions
Unit - 5
Interrupt Service Routines, Interrupt Service Threads, Introduction to Windows CE.NET Device Driver
Development, Development of COM components, DCOM components and ActiveX controls in Windows CE.NET, Internationalization, Introduction to Real-time communication

BOOKS

Programming Microsoft windows CE - Douglas Boling.
Microsoft .NET - David Platt (PHI).
Microsoft .NET Framework - Chakraborti, Sandhu (PHI).
Introducing .NET - James Conard et. Al. (Wrox Publication).
The Complete Reference C# - Schildt (TMH).

5CSA-3: Network Security

UNIT :1

Network Security Fundamentals: Introduction, security Vulnerabilities and Threats, Classification of Security Services.
Cryptography: Encryption Principles, Conventional Encryption DES, IDEA, Algorithms, CBC, Location of Encryption Devices key Distribution.

UNIT :2
Message Digests and Checkstfms/MeSSaQe"Authentication, Message Digests, Hash Functions and SHA, CRCs. Public Key Systems: RSA, Diffie-Hellman, DSS, Key management.
Intruders: ntrusion Techniques, Intrusion Detection. Viruses, Access Control and Management, Access Control Policies, Access Control Mechanisms, Types of Viruses, Anti-virus Techniques

UNIT :3
Number Theory: Modular Arithmetic, Euclid Algorithm, Euler Theorem, Chinese Remainder Theorem. Confidentiality, Integrity, Non-Repudiation, Mechanisms, Protocol Requirements, Options, NonRepudiation - Process Non-Repudiation - Delivery.

UNIT :4
Authentication, Password-Based Authentication, Address-Based Authentication, Certificates, Authentication Services, Email Security, Threats, PGP, S/MIME. Firewalls, Design Principles, Packet Filtering, Access Control, Trusted Systems, Monitoring and Management.

UNIT :5
IP Security: IP Overview, IP security Architecture, Authentication Header, Encapsulating Security Payload, Key Management, Network Management. Web Security, Web Security Threats, Web Security Requirements, Secure Socket Layer and Transport Layer Security, Secure Electronic Transactions.

Text Book:

Network security Essentials: Applications and Standards.
William Stallings.
Pearson Education.

Reference:

Cryptography and Network Security.
William stallings.
Pearson Education.

Elective - 1 (A) Legal Aspects of IT

Unit -1
Cyber Law: Introduction, Defining Cyber Law, Legal Identity -Netizen, Private? International Law in Cyberspace. IT Law: History of Information Technology Act 2000, About IT Law, IT Act 2000 and Emails,

Unit - 2
Cryptography, Application of Cryptography, IT Act 2000 and Technology. Business: Classification of Internet Business Models, E-Business models, E-Commerce and Security, Online payment facilities, IT Act
2000 and E-Commerce. ElectronicContract: E-Agreement5- and Web Surfing, Terms of service contracts,
General precautions, Cyber Contracts, IT Act 2000 and E-Contracts. '

Unit - 3
Collecting Persona! information, Means of identifying personal identity, Online Ads and Profilers, Protecting Privacy policy for an E-Commerce site, Privacy Law and Problems, Personal Data protection Mark, IT Act 2000 and Issue of Piracy.

Unit – 4
Digital content rights, Copyright Infringements, Steps to protect the content on WWV, Reconceptuliazing
Copyright in a digital society, Software Patents, Domain name system and Trademarks, Emergence of Cyberspace Trademark Law, IT Act 2000 and Issue of Copyright, Patent and Trademark.
Unit - 5
Age of Cyber Crime: The Interface, Establishing the nature of Offence, Economy/ Cost of Cyber Crime,
Future Impact, Strategy to Combat Cyber Crime, IT Act 2000 and Cyber
Crime

Books

Handbook of Cyber Laws - Vakul Sharma, McMillan.
IT and the Indian Legal System - Kamlesh Agrawala, McMillan.
E-Security and You - Oberoi, Sundeep, Tata McGraw Hill.
Information Warface: How to Survive Cyber Attacks - Erbschloe, Tata WcGraw Hill.
Cyber Law - Rakesh Sood, Tata McGraw Hill.

5CSA-4: Elective - 1 (B) Software Engineering

Unit - 1:

Introduction to software Engineering-Trie Role of Software Engineering, History of Software Engineering, The Role of Software Engineer, The Software Life cycle, The Relationship of Software Engineering to Other Areas of Computer Science. The Relationship of Software Engineering to other
Disciplines. Software: Its Nature and Qualities- Classification of software Qualities, Representative Qualities, Quality Requirements in Different application Areas, Measurement of
Quality.

Unit – 2:
Software Engineering Principles-Rigor and Formality, Separation of Concern, Modularity, Abstraction, Anticipation of Change, Generality, Instrumentality. Software Design-Software, Design Activity and its Objectives, Modularization Techniques, Object-Oriented Design.

Unit - 3:
Software specification-The Uses of Specification, Specification Qualities, Classification of Specification Styles, Verification of specifications, Operational Specifications, Descriptive Specifications. Software verification-Goals and Requirement of Verification, Approaches to Verification, Testing, Analysis, Symbolic Execution, Debugging, Verifying Other Software Properties.

Unit – 4:
The Software Production Process – Software Production, Process Models: Waterfall Mode, Evolutionary Model, Transformation Model, and Spiral Model, Organizing the Process. Management Of Software Engineering – Management Functions, Project Planning, Project Control, Organization, Risk Management.

Unit – 5:
Software Engineering Tools and Environments- Historical Evolution of Tools and Environments, Classification of Software Tools and Environments , Representative Tools, The role of programming Language in the Environment, Some Sample Tools and Environment.

Books:

Fundamentals of Software Engineering By Ghezzi, Jazayeri and Mandrioli [PHI]
Software Engineering By Pressman [Tata McGraw-Hill].
Fundamentals of Software Engineering By Mail
Software Engineering Concept By Richard Fairley [Tata McGraw-Hill]

5CSA-4: Elective - I(C) System Management UNIT – 1

Unit-1
Management Planning And Control - History of management thought, Classical principles of management, modern management principles, management movement, general management, scientific management, engineering management, manufacturing management, Systems management, time management, managerial process of planning, management functions, management control, skills of managers, responsibilities of management, hidden practices of management, managerial effectiveness, self-evaluation of managerial approaches, checklist of competent manager. Organization Planning, Design And Development -Introduction, Organization planning, Organization Design, Organization Development. Social Responsibility and Ethics of Management and Society - Operating in a pluralistic society, Social responsibility of managers, ethics in managing.

UNIT - 2
Human Resource Planning And Management - Human resource planning, job analysis, Acquisition of Human Resources, Training and Development, human Resource motivation, Organization development and change, Group Behavior, Working life and its quality, Communication, Leadership, Workers participation in management, Promotion policy, job evaluation, Collective Decision-Making, Trade Unions, Collective Bargaining, Industrial Disputes, Industrial Safety, Health and Safety at work.

UNIT – 3
Total Quality Management-Introduction, Total Quality Management, ISO 9000, Quality Audit. Product Design and development-Introduction, Design of the product, new product development. Maintenance and System Reliability-Introduction, objective of maintenance, Failure Analysis, Maintenance system, types of maintenance, performance criterion for maintenance system, maintenance planning and control, Maintenance strategy, system approach to maintenance management, Impact of terotechnology on maintenance management, maintenance costing and budgeting, maintenance performance indices.

UNIT - 4
Privatisation, Liberalisation and Globalisation-Introduction, reasons for Privatisation, determinants and constraints of Privatisation, global experience, necessary precautions in Privatisation, some impacts of Privatisation in the global context, methods of Privatisation, disinvestments techniques, Privatisation from within, fringe or cold Privatisation, regulatory mechanism consequent upon Privatisation,
Liberalisation, Liberalisation in practice, Globalisation, Globalisation and Indian Corporate, Implications and Impact, Introduction to Privatisation policy and Practice in India. International Management and the future-International Management in selected countries, Japanese Management and Theory Z, International Management and Multinational Corporations, The managerial functions in International Business, Toward a Unified, Global Theory of Management.

UNIT - 5
Communication Skills: Language and communication: Linguistic Communication, Barriers to Communication, Importance of Communication Introduction. Non-Verbal Communication: Personal Appearance, posture, Gestures, Facial Expression, Eye Contact, Space Distancing. Communication in Organization: Pattern of Communication, Management of Information. Dyadic Communication: Face to Face Conversation, Telephonic Conversation, Interviews, instructions, Dictation. Meeting: Purpose, Procedure, Chairmanship, Participation, And Physical Arrangement.
Seminars and Conferences: Types of Group Discussion, Regulating speech, conducting seminars, organization confererices, evaluating Oral presentation,. Group Discussion, AudioVisual Aids.

Books

Management of Systems by Gupt? ~ bharma-Macrr.illan, Essential Of management by Koontz & Weihrich -TMH.
Human Resource development and Management by Sheikh - S. Chand, Management of Systems by Gupta & Sharma-Macmillan, Business Administration by Applebay - Macmillan, Industrial Management by Chopde & sheikh - S. Chand.
Management of Systems by Gupta & Sharma-Macmillan, Industrial Management by Chopde & sheikh - S. Chand,
Essential Of management by Koontz & Weihrich - TMH, Public Enterprise Management and Privatisation.
Developing Communication Skills by K Mohan & Banerji - Macmillan, Profession communication Skills by Bhatia & Sheikh - S. Chand.

5CSA-5: Elective - II (a) Visual Basic .NET

UNIT - l
Introduction to Visual Basic .NET (VB .NET) - The .NET Framework, The .NET Programming Framework, .NET Languages, The .NET Class Library, About ASP .NET, Basic difference between C# and VB .NET, Visual Studio .NET, About VB .NET, Windows Applications using VB .NET, Object Oriented concept in VfijINEJ.

UNIT - 2
Programming building blocks - Variables, Data Types, Assignment Operators, Arithmetic Operators, Comparison Operators, Logical Operators, Type Conversion, Control Structure - if Statements, controls used for if statements, Loop Structures –For .... Next Statements, While ..... End Statements, Do Statements.

UNIT3:
Programming Concepts-Arrays-Declaring an array, useful Array function, properties & Methods, Resizing an array. Procedures-Types of Procedures, Built-in Vs Programmer defined Procedures, Methods Contrasted. Subroutine-Declaring a Subroutine, Calling the subroutine. Functions-Declaring Functions, Calling functions. Arguments-Passing arguments by Val & by Ref, optional arguments, parameters array. Procedure Overloading.

UNIT - 4
User Interface - Helper forms, Message process, Dialog Process, Owned Forms. Menus-Creating a menu, Functionality to the menu items, Enhancing the menu, Disabling Items on Windows form menus, creating context menu, Add functionality to the menu items. Toolbar-Adding the toolbar and buttons, Defining an Icon for a toolbar and buttons, Defining an ICON for a Toolbar Button, Adding Functionality to the toolbar.

UNIT - 5
Error handling & Prevention - Structured Exception Handling - Exception, Structured Vs Unstructured Exception Handling, Try .... Catch ... Finally Statement, Exception Class. Debugging - Break mode, starting Debugging, controlling the flow during debugging, Debugging Tools.

BOOKS

Visual Basic .NET by Jeffrey Kent - Tata McGraw- Hill.
The Complete Reference - Tata McGraw- Hill.

5CSA-5: Elective - II (b) ASP .NET

UNIT - 1
Introduction to ASP .NET - The .NET Framework, The .NET Programming Framework, .NET Languages, The .NET Class Library, About ASP .NET, Basic difference between C# and VB .NET, Data Types, Declaring Variables - Initializers, Arrays, Enumerations. Variable Operations - Advanced Math Operations, Type Conversions. Object-Based Manipulation - String Object, DateTime Object, TimeSpan Object & Array Object. Conditional Structures, Loop Structures, Functions & Subroutines - Parameters, Procedure Overloading, Delegates.

UNIT - 2
The Basics about Classes - Shared Members, A Simple Class, Adding properties, Basic Method, Basic Event, Constructors. Value Types & Reference Types - Assignment Operations, Equality Testing. Advanced Class Programming - Inheritance, Shared Members, Casting. Understanding Namespaces and Assemblies - Importing Namespaces, Assemblies.

UNIT - 3

Web Server and user - Installing US. US Manager - Creating a virtual Director, Virtual Directories and Applications, Folder Settings, Adding virtual directory to your Neighborhood. Installing ASP .NET. ASP .NET Applications - ASP .NET file Types, The bin directory, Code-Behind, The Global.asax Code-Behind,
Understanding ASP. Net Classes, ASP .NET Configuration

UNIT - 4

Web Form Fundamentals - A Simple Applets, Improving the Currency Converter, HTML Control classes, Page Class, Assessing HTML Server Controls. Web Controls - Basic Web Control classes, Auto PostBack and Web Control Events, A Web page Applets. Validation and Rich Controls. State Management. Tracing, Logging and Error Handling -Common errors, .NET Exception Object, Handling Exceptions, Throwing your own Exceptions, Logging Exceptions, Error pages, Page tracing.

UNIT - 5

Advanced Asp. NET - Component-Based Programming - Components Jargon, Creating Simple Component, Properties and State, Database Components, Using COM Components. Custom Controls-User Controls, Deriving Custom controls. Cashing and Performance tuning - Designing fro scalability, Profiling, Caching, output Caching, Data caching. Implementing Security-Determining Security Requirements, The ASP .NET Security Model, Forms Authentication, Windows Authentication, Impersonation. The IbuySpy Case Studies.

Books

1. The Complete Reference-ASP .NET by Matthew MacDonald-Tata McGraw- Hill.