Pages

Friday, August 16, 2013

BCSL-034 DBMS Lab 1 Credit------IGNOU BCA MCA MBA COACHING JAIPUR

BCSL-034 DBMS Lab 1 Credit

Objectives: This lab is based on the courses MCS-023,. This lab course involves the development
of the practical skills in DBMS using MS-Access , Theoretical aspects were already covered in the respective theory courses. This course is an attempt to upgrade and enhance your theoretical skills and provide the hands on experience. By the end of these practical sessions of this course, you will be able to create databases and use DBMS Tools in the areas of Database applications.



SECTION 1: DBMS Lab

 Introduction to MS-Access

 Database Creation


 Use of DBMS Tools/Client-Server Mode


 Forms and Procedures


IGNOU Coaching For BCA, MCA, MBA in Jaipur- 9680422112 (Rajat Sharma)

IGNOU JAIPUR

BCSL-033 Data and File Structures Lab---------IGNOU BCA MCA MBA COACHING JAIPUR

BCSL-033 Data and File Structures Lab


This lab is based on the courses MCS-021. This lab course involves the development of the practical skills in Data structures using C programming, Theoretical aspects were already covered in the respective theory courses. This course is an attempt to upgrade and enhance your theoretical skills and provide the hands on experience. By the end of these practical sessions of this course, you will be able to write programs using basic data structures such as Arrays etc. as well as advanced data  structures such as trees etc.


SECTION 1 : Data and File Structures Lab Manual
Arrays
Structures
Linked Lists
Stacks
Queues
Trees
Advanced Trees
Graphs
Searching
Sorting

IGNOU Coaching For BCA, MCA, MBA in Jaipur- 9680422112 (Rajat Sharma)

IGNOU JAIPUR

Thursday, August 15, 2013

BCSL-032: C++ Programming Lab 1 Credit------IGNOU BCA MCA MBA COACHING JAIPUR

BCSL-032: C++ Programming Lab 1 Credit

Objectives:

Objective of this course is to provide hands on experience to the learners in C++ programming.
Learners will write program in C++ based on concepts learned in C++ programming course. In
this course programming to be done for implementation of OO features such as class, objects,
inheritance, polymorphism.

Syllabus and Sessions Allocation:

Session1: Basics of C++, data type, I/O, Control Structures etc.,

Session 2: Class and Objects, function calling, 

Session 3: Constructor and Destructor, 

Session 4: Inheritance, 

Session 5: Operator Overloading, 

Session 6: Polymorphism, 

Session 7: Template class and function,

Session 8: I/O and streaming,

Session9: Exception Handling, 

Session10:STL.

IGNOU Coaching For BCA, MCA, MBA in Jaipur- 9680422112 (Rajat Sharma)

IGNOU JAIPUR




BCS-031 : C++ Programming-----IGNOU BCA MCA MBA COACHING JAIPUR

BCS-031 : C++ Programming

BLOCK 1: Basics of Object Oriented Programming & C++

Unit 1 : Object Oriented Programming
Structured vs. Object Oriented Programming, Object Oriented Programming Concepts,Benefits of Object oriented programming, Object Oriented Languages.

Unit 2 : Introduction to C++
Genesis of C++, Structure of a C++ program, Data Types, Operators and Control Structures. 

Unit 3 : Objects and Classes
Classification, Defining Classes, Encapsulation, Instantiating Objects, Member
Functions, Accessibility labels, Static Members.

Unit 4 : Constructors and Destructors
Purpose of Constructors, Default Constructor, Parameterized Constructors, Copy
Constructor, Destructor, Memory Management.

BLOCK 2: Inheritance and Polymorphism in C++

Unit 1 : Inheritance
Concept of Reusability, Types of Inheritance, Single and Multiple Inheritance,Multilevel Inheritance.

Unit 2 : Operator Overloading
Function and Operator Overloading, Overloading Unary and Binary Operators.

Unit 3 : Polymorphism and Virtual Function
Abstract Class, Function Overriding, Dynamic Binding, Pure Virtual Functions.

Block 3: Advanced Features of C++

Unit 1 : Streams and Files
Stream Classes, Types of I/O, Formatting Outputs, File Pointers, Buffer.

Unit 2 : Templates and STL
Function and Class Templates, Use of Templates, Standard Template Library.

Unit 3 : Exception Handling
Exceptions in C++ Programs, Try and Catch Expressions, Exceptions with arguments.

Unit 4 : Case Study
A Case Study to implement a real world problem.

IGNOU Coaching For BCA, MCA, MBA in Jaipur- 9680422112 (Rajat Sharma)

IGNOU JAIPUR

MCS 023: Introduction to Database Management Systems------IGNOU BCA MCA MBA COACHING JAIPUR

MCS 023: Introduction to Database Management System


BLOCK 1 : The Database Management System Concepts

Unit 1 : The Basic Concepts
Need for a Database Management System, The file based system, Limitations of file based system, The Database Approach, The Logical DBMS Architecture, Three level architecture of DBMS or logical DBMS architecture, Mappings between levels and data independence, The need for three level architecture, Physical DBMS Architecture, DMLPrecompiler, DDL Compiler, File Manager, Database Manager, Query Processor, Database Administrator, Data files indices and Data Dictionary, Commercial Database  Architecture, Data Models.

Unit 2 : Relational and ER Models
The Relational Model, Domains, Attributes, Tuple and Relation, Super keys Candidate keys and Primary keys for the Relations, Relational Constraints, Domain Constraint, Key Constraint, Integrity Constraint, Update Operations and Dealing with Constraint  Violations, Relational Algebra, Basic Set Operation, Cartesian Product, Relational Operations, Entity Relationship (ER) Model, Entities, Attributes, Relationships, More  about Entities and Relationships, Defining Relationship for College Database, E-R Diagram, Conversion of E-R Diagram to Relational Database.

Unit 3 : Database Integrity and Normalisation
Relational Database Integrity, The Keys, Referential Integrity, Entity Integrity, Redundancy and Associated Problems, Single-Valued Dependencies, Single-Valued Normalisation, The First Normal Form, The Second Normal Form, The Third Normal Form, Boyce Codd Normal Form, Desirable Properties of Decomposition, Attribute Preservation, Lossless-join Decomposition, Dependency Preservation, Lack of redundancy, Rules of Data Normalisation, Eliminate Repeating Groups, Eliminate Redundant Data, Eliminate Columns Not Dependent on Key.

Unit 4 : File Organisation in DBMS
Physical Database Design Issues, Storage of Database on Hard Disks, File Organisation and Its Types, Heap files (Unordered files), Sequential File Organisation, Indexed (Indexed Sequential) File Organisation, Hashed File Organisation, Types of Indexes, Index and Tree Structure, Multi-key File Organisation, Need for Multiple Access Paths, Multi-list File Organisation, Inverted File Organisation, Importance of File Organisation in Databases..

BLOCK 2: Structured Query Language and Transaction Management

Unit 1 : The Structures Query Language
What is SQL? Data Definition Language, Data Manipulation Language, Data Control, Database Objects: Views, Sequences, Indexes and Synonyms, Table Handling, Nested Queries.

Unit 2 : Transactions and Concurrency Management
The Transactions, The Concurrent Transactions, The Locking Protocol, Serialisable Schedules, Locks. Two Phase Locking (2PL), Deadlock and its Prevention, Optimistic Concurrency Control.

Unit 3 : Database Recovery and Security
What is Recovery? Kinds of failures, Failure controlling methods, Database errors, Recovery Techniques, Security & Integrity, Relationship between Security and Integrity, Difference between Operating System and Database Security, Authorization.

Unit 4 : Distributed and Client Server Databases
Need for Distributed Database Systems, Structure of Distributed Database,Advantages and Disadvantages of DDBMS, Advantages of Data Distribution, Disadvantages of Data Distribution, Design of Distributed Databases, Data Replication, Data Fragmentation, Client Server Databases, Emergence of Client Server Architecture,Need for Client Server Computing, Structure of Client Server Systems, Advantages of Client Server Systems.

BLOCK 3: Application Development: 
 Development of a Hospital Management System Need to Develop the Hospital Management System (An HMS), Creating a Database for HMS, Developing Front End Forms, Reports, Using Queries and Record set.

BLOCK 4: Study Centre Management System:
A Case Study Software Development Process:Analysis, System Designing, Issues relating to Software Development, Testing and Maintenance.

IGNOU Coaching For BCA, MCA, MBA in Jaipur- 9680422112 (Rajat Sharma)

IGNOU JAIPUR

MCS-021: Data and File Structures----IGNOU BCA MCA MBA COACHING JAIPUR

MCS-021: Data and File Structures

BLOCK 1 : Introduction to Algorithms and Data Structures

Unit 1 : Analysis of Algorithms
Mathematical Background, Process of Analysis, Calculation of Storage Complexity  Calculation of Run Time Complexity.
Unit 2 : Arrays
Arrays and Pointers, Sparse Matrices, Polynomials, Representation of Arrays, Row Major Representation, Column Major Representation, Applications.

Unit 3 : Lists
Abstract Data Type-List, Array Implementation of Lists, Linked Lists-Implementation, Doubly Linked Lists-Implementation, Circularly Linked Lists-Implementation, Applications.

BLOCK-2: Stacks, Queues and Trees

Unit 4 : Stacks
Abstract Data Type-Stack, Implementation of Stack, Implementation of Stack using Arrays, Implementation of Stack using Linked Lists, Algorithmic Implementation of Multiple Stacks, Applications.

Unit 5 : Queues
Abstract Data Type-Queue, Implementation of Queue, Array Implementation, Linked List Implementation, Implementation of Multiple Queues, Implementation of Circular Queues, Array Implementation, Linked List Implementation of a circular queue, Implementation of DEQUEUE, Array Implementation of a dequeue, Linked List Implementation of a dequeue.

Unit 6 : Trees
Abstract Data Type-Tree, Implementation of Tree, Tree Traversals, Binary Trees, Implementation of Binary Tree, Binary Tree Traversals, Recursive Implementation of Binary Tree Traversals, Non Recursive Implementations of Binary Tree Traversals,Applications.

BLOCK 3 : Graph Algorithms and Searching Techniques

Unit 7 : Advanced Trees
Binary Search Trees, Traversing a Binary Search Trees, Insertion of a node into a Binary Search Tree, Deletion of a node from a Binary Search Tree, AVL Trees, Insertion of a node into an AVL Tree, Deletion of a node from and AVL Tree, AVL tree rotations,Applications ofAVLTrees, B-Trees, Operations on B-Trees ,Applications of B-Trees.

Unit 8 : Graphs
Definitions, Shortest Path Algorithms, Dijkstra’s Algorithm, Graphs with Negative Edge costs, Acyclic Graphs, All Pairs Shortest Paths Algorithm, Minimum cost Spanning Trees, Kruskal’s Algorithm, Prims’s Algorithm, Applications, Breadth First Search , Depth First Search, Finding Strongly Connected Components.

Unit 9 : Searching
Linear Search, Binary Search, Applications.

BLOCK 4 : File Structures and Advanced Data Structures

Unit 10 : Sorting
Internal Sorting, Insertion Sort, Bubble Sort, Quick Sort, 2-way Merge Sot, Heap Sort, Sorting on Several Keys.

Unit 11 : Advanced Data Structures
Splay Trees, Splaying steps, Splaying Algorithm, Red-Black trees, Properties of a Red Black tree, Insertion into a Red-Black tree, Deletion from a Red-Black tree, AA-Trees.

Unit 12 : File Structures
Terminology, File Organisation, Sequential Files, Structure, Operations, Disadvantages,Areas of use, Direct File Organisation, Indexed Sequential File Organisation.


IGNOU Coaching For BCA, MCA, MBA in Jaipur- 9680422112 (Rajat Sharma)

IGNOU JAIPUR

Inviting Sealed Tenders from Manpower Supply Agencies (RC, Karnal), Last Date : 26-08-2013 -----IGNOU BCA MCA MBA COACHING JAIPUR

Sealed tenders are invited from Manpower Agencies for providing personnel on daily wage basis. Interested agencies may obtain form @ Rs.500/- in cash during working hours 9.30AM to 6.00PM from IGNOU Regional Centre, Karnal      (Kothi No. 06, Subhash Marg, Subhash Colony, Near Home Guard Office, Karnal – 132001, Phone 0184 - 2271514) on working days (Monday-Friday) upto 22.08.2013.
Last date of submission of form at IGNOU Regional Centre, Karnal: 26.08.2013.
 
Regional Director
 
 
 
IGNOU Coaching For BCA, MCA, MBA in Jaipur- 9680422112 (Rajat Sharma)

IGNOU JAIPUR