Computer Science
Computer Science
Computer Science
Object Oriented Programming: Concept of Object Oriented Programming – Data hiding, Data
encapsulation, Class and Object, Abstract class and Concrete class, Polymorphism
(Implementation of polymorphism using Function overloading as an example in C++); Inheritance,
Advantages of Object Oriented Programming over earlier programming methodologies,
Inheritance (Extending Classes): Concept of Inheritances, Base Class, Derived classes, protected
visibility mode; Single level inheritance, Multilevel inheritance and Multiple inheritance, Privately
derived, publicly derived and Protectedly derived class, accessibility of members from objects and
within derived class (es);
Data File Handling: Need for a data file, Types of data files – Text file and Binary file;
Text File: Basic file operations on text file: Creating/Writing text into file, Reading and
Manipulation of text from an already existing text File (accessing sequentially).
Binary File: Creation of file, Writing data into file, Searching for required data from file,
Appending data to a file, Insertion of data in sorted file, Deletion of data from file, Modification
of data in a file;
Implementation of above mentioned data file handling in C++;
Components of C++ to be used with file handling: Header file:
fstream.h; ifstream, ofstream, classes;
Opening a text file in—in, out, and app modes;
Using cascading operators (>>,<<) for writing text to the file and reading text from the file; open
(), get (), read (), put (), write(), getline() and close() functions; Detecting end-of-file (with or
without using eof() function), tellg(), tellp(), seekg(), seekp();
Pointers:
Introduction to Pointer, Declaration and Initialization of Pointer; Dynamic memory allocation/de-
allocation operators: new, delete; Pointers and Arrays: Array of Pointers, Pointer to an array (1
dimensional array), Function returning a pointer, Reference variables and use of alias; Function
call by reference. Pointer to structure: De-reference/Deference operator: *, ->; self referential
structure;
Introduction to data structure- array, stack queues primitive and non-primitive data structure,
linear and non-linear structure, static and dynamic data structure.
Arrays:
One and two Dimensional arrays: Sequential allocation and address calculation;
One dimensional array: Traversal, Searching (Linear, Binary Search), Insertion of an element in an
array, deletion of an element from an array, Sorting (Insertion, Selection, Bubble)
Two-dimensional arrays: Traversal Finding sum/difference of two NxM arrays containing numeric
values, Interchanging Row and Column elements in a two dimensional array;
Unit 3: Database Management System and SQL (20 Theory + 20 Practical) Periods
Data base Concepts: Introduction to data base concepts and its need.
Relational data model: Concept of domain, tuple, relation, key, primary key, alternate key,
candidate key;
General Concepts: Advantages of using SQL, Data Definition Language and Data Manipulation
Language;
SQL COMMANDS: CREATE TABLE, DROP TABLE, ALTER TABLE, UPDATE ….SET…., INSERT, DELETE;
SELECT, DISTINCT, FROM, WHERE, IN, BETWEEN, GROUP BY, HAVING, ORDER BY;
SQL functions: SUM ( ), AVG ( ), COUNT ( ), MAX ( ) AND MIN ( ); Obtaining results (SELECT query)
from 2 tables using equi-join, Cartesian product and Union
Note: Implementation of the above mentioned commands could be done on any SQL supported
software on one or two tables.
Unit 4: Boolean Algebra (16 Theory + 0 Practical) Periods
Binary-valued Quantities, Boolean Variable, Boolean Constant and Boolean Operators: AND, OR,
NOT; Truth Tables; Closure Property, Commutative Law, Associative Law, Identity law, Inverse
Law, Principle of Duality, Idempotent Law, Distributive Law, Absorption Law, Involution Law,
DeMorgan’s Law and their applications;
Obtaining Sum of Product (SOP) and Product of Sum (POS) form the Truth Table, Reducing Boolean
Expression (SOP and POS) to its minimal form, Use of Karnaugh Map for minimization of Boolean
expressions (up to 4 variables);
Application of Boolean Logic: Digital electronic circuit design using basic Logic Gates (NOT, AND,
OR, NAND, NOR)