Programme guide distance Education Programmes

MCA 8 - Numerical Computation & Statistical Methodology

Matrix Algebra: Introduction of a Matrix, its different kinds, Matrix Addition and Scalar Multiplication, Multiplication of Matrices, Square Matrix, Rank of a Matrix, Transpose, Multiplication, Multiplication of Matrices, Square Matrix, Rank of a Matrix, Transpose, Adjoint and Inverse of a Matrix, Solving Simultaneous Equations using Gauss Elimination Method, Gauss Jorden Method and Matrix Inversion Method.

Statistics: Measures of Central Tendency. Preparing Frequency Distribution Table, Arithmetic Mean, Geometric Mean, Harmonic Mean, Median and Mode. Measures of Dispersion: Range, Mean Deviation, Standard Deviation, Co-efficient of Variation, Moments, Skewness and Kurtosis.

Differential Calculus: Introduction, Differentiation, Derivative of a Function of One Variable, Power Function, Sum and Product of Two Functions, Function of a Function, Variable, Power Function, Sum and Product of Two Functions, Function of a Function Differentiation by Method of Substitution, Maxima and Minima.

Integral Calculus: Indefinite Integral, Integration by Substitution, Integration by Parts, Integration by Partial Fractions, Definite Integral.

Numerical Integration: Trapezoidal Method, Simpson’s 1/3 Rule, Simpson’s 3/8 Rule.

MCA 9 - Business Data Processing

Introduction to Data Processing Introduction to Data and Information, Logical and Physical Concept of Data, File Organization, Different Systems of Data Processing, Business Data Processing (Identification of Data, Classification of Business Data File, Data Security, Data Integrity and Type of Checking, Basic Task in Business Data Processing, File Generation, File Backup).

Business Accounting Accounting, Accounting Conventions (Single and Double Entry), Basic Accounting Equation, Types of Accounts, Personal Accounts, Impersonal Accounts, Real, Nominal, Terms in Accounting, Assets, Liabilities, Capital, Goods, Debtor, Creditor, Gross Profit, Net Profit, Revenue, Expense, Types of Vouchers, Journal Entries, Final Accounts, Trading/Manufacturing Account, Profit/Loss Account, Balance Sheet, Schedule to Final Account.

Introduction to Access Introduction to Database, DBMS, RDBMS, Feature of Access, Designing Database, Relationship (One to One, One to Many, Many to One, Many to Many), Create Table (Design View, Wizard, Datasheet View), Query (Update Query, Delete Query, Selection Query, Cross Table Query, Make Table Query).

Forms, Reports and Labels Create (Manually, Form Wizard, AutoForm), Sorting, Filtering, Report Creation (Design View and Wizards), Report using Single Tables/Multiple Tables/Queries, Labels..

MCA 10 - Object Oriented Programming Analysis and Design

UNIT-I

Introduction to Oops: Encapsulation, Data Abstraction, Inheritance, Polymorphism, message Passing, Extensibility

Introduction to C++: Function, Variables, Arithmetic operators

UNIT-II

Loops and Decisions: Relational Operators, Loop, and Logical operators

Structures : Simple structure, Initializing structure variables, Accessing Nested structure member Enumerated data types.

Function: Simple functions, Function declaration Function Call, Function definition, Overloaded function

Arrays: Defining Arrays, Multidimensional Arrays, Arrays of Structures.

UNIT-III

Object and Classes: Class, Objects, Constructors, Deconstructors.

Operator: Operator overloading, overloading ...operators, Overloading Binary Overloading operators

UNIT-IV

Inheritance: Defining Arrays, Multidimensional Arrays, Arrays of Structures.

Graphics: Text mode graphic Function, Graphic mode, Graphic function, Graphic driver

UNIT-V

Pointer: Address and Pointers, Pointers and Array.

SEMESTER - III

MCA 11 - Database Management System

Introduction To Database Systems and E-R Model Overview, A Historical Perspective, Files System versus DBMS, Advantages of DBMS, Describing and storing data in a DBMS Transaction management, Structure of a DBMS, People who work with Databases, Overview of Database Design. Entities, Attributes and Entity Sets, Relationships and Relationship sets, Additional Features of E-R Model: Key Constraints. Conceptual Design with the E-R Model, Overview of Unified Modeling Languages

Relational Model and Query Languages Introduction to the Relational Model. Integrity Constraints over Relations: Primary Key, Foreign Key and General Constraints. E-R Model to Relational Model: Entity Sets to Tables, Relationship Sets to Tables, Translating, Relationship Sets with Key Constraints. Translating Relationship Sets with Participation Constraints, Translating Weak Entity Sets, Translating Class Hierarchies. Translating E-R Diagrams with Aggregation, Introduction to Query Languages, Relational Algebra: Selection and Projection Operations. Set Operations, Renaming, Joins, Division

Structured Query Language Overview of SQL, Basic Queries in SQL, Union, Intersect and Except, Nested Queries, Aggregate Operators, Null Values, Complex Integrity Constraints in SQL, Triggers and Views in SQL, Embedded SQL and Cursors

Relational Database Design Introduction to Schema Refinement, Functional Dependencies, Properties of Decomposition, Normal Forms: First Normal Form, Second Normal Form, Third Normal Form, Boyce Codd Normal Form, Fourth Normal Form, Fifth Normal Form

Transaction Management, Concurrency Control and Distributed System The ACID Properties, Transactions and Schedules, Concurrent Execution of Transactions: Serialisability, Anomalies Due to Interleaved Execution. Schedules Involving Aborted Transactions, Lock-Based Concurrency Control: 2 PL – Basic & Strict, Dead Locks, Introduction to Crash Recovery, Concurrency Control:2 PL, Serialisability, and Recover-ability,: Introduction to Locking Management: Dealing with Deadlock .Introduction to ARIES, Introduction to Distributed Databases: Advantages & Disadvantages, Transaction Types – Local & Global Transactions, Distributed DBMS Architectures, Design of Distributed Databases: Replication, Fragmentation.