Total Lectures = 50
Concept: Nature, Functions of Managers, Management: Arts vs Science, Evolution of Management Thoughts, Functions of Management.
Types of Control, Steps involved in Control Process, Meaning and importance of the study of Organisational Behaviour. Improving inter-personal effectiveness, inter-personal communication.
Introduction of Accounting, Basics of Accounting - Meaning of Accounting and Accounting Cycle, Users of Accounting Information and Their Needs, Objectives, Types of Accounting Information, Advantages, Limitations, and Branches of Accounting, Basic Accounting Terminology.
Double Entry System of Book Keeping, Accounting and Economic Concept of Income, Computation of Accounting Income and economic Income.
Journalising, Posting and Balancing. Financial Statements - Meaning, Usefulness, Elements of Financial Statements, Manufacturing Financial Statements. Trading Account, Profit & Loss Account, Balance Sheet (Position Statement), Distinction Between Manufacturing Account and Trading Account, Trial Balance.
Use of Computers in Accounting – Meaning, Capability and Role of Computers in Accounting, Computer Terms.
Total Lectures = 50
Database and Database Users, Characteristics of the Database Approach, Structure, Function and Components of DBMS, Different people behind DBMS, Advantages of using DBMS. Database System Concepts and architecture: Data Models, Schemas, and Instances. DBMS 3-Level ANSI/SPARC Architecture and Data Independence, Types of DBMS.
Entity-Relationship Model: Entity types, Entity sets, attributes, and Keys, ER Model Concepts, Notation for ER Diagrams, Reducing E-R Diagrams to tables. Abstraction - Generalisation, Specialisation, and Aggregation. Cardinality and Modality. Exercises.
Structure and properties of relational model, Relation, Attribute, Tuple, Keys: Super, Primary, Candidate, Alternate, and Foreign keys. Relational Algebra: Union, Intersection, Difference, Cartesian Product, Division, Join. Introduction to Network and Hierarchical Data models.
Functional Dependencies and its types, Axioms for FDs, Decomposition Rules, Different Normal Forms: 1NF, 2NF, 3NF, BCNF, Multi-valued dependencies – 4NF and 5NF, DKNF.
Data definition in SQL, DDL Commands, DML Commands, Queries in SQL - Simple Queries, Nested Queries, Aggregate Functions, Insert, Delete and Update, Views in SQL, Specifying General Constraints as Assertions, specifying indexes.
Introduction, Transaction and System Concepts, Desirable (ACID) properties of transaction, Recovery Techniques: Log-based, Check-points and Shadow paging, Serializability of schedules, Problems with concurrency, Concurrency Control, Locking Techniques, Lock types, Granularity of Locking, Concurrency Control based on time stamp ordering.
Total Lectures = 50
Object oriented programming concepts. Why do we need object oriented. C++ Programming basics:
Output using
cout
. Directives. Input with
cin
.
Type
bool
, The
setw
manipulator, Type conversions.
Functions: Returning values from functions, Reference arguments, Overloaded function, Inline function, Friend function, Static function, Default arguments, Returning by reference.
Object and Classes: Making sense of core object concepts (Encapsulation, Abstraction, Polymorphism, Classes, Messages Association, Interfaces). Implementation of class in C++, C++ Objects as physical object, C++ object as data types, constructor, Object as function arguments, The default copy constructor, returning object from function, Structures and classes, Classes objects and memory static class data, Const and classes.
Arrays and string arrays fundamentals, Arrays as class Member Data: Arrays of object, string, The standard C++ String class. Operator overloading: Overloading unary operations, Overloading binary operators, data conversion, pitfalls of operators overloading and conversion keywords. Explicit and Mutable.
Inheritance: Concept of inheritance, Derived class and base class, Derived class construction member function, inheritance in the English distance class, class hierarchies, inheritance and graphics shapes, public and private inheritance, aggregation: Classes within classes, inheritance and program development, Virtual Function: Virtual Function and Function.
Pointer: Addresses and pointers. The address of operator and pointer and arrays. Pointer and Function member and C-types string. Memory management: New and Delete, pointers to objects, debugging pointers. Assignment and copy initialization, this pointer, dynamic type information. Streams and Files: Streams classes, Stream Errors, Disk File I/O with streams, file pointers, error handling in file I/O with member function, overloading the extraction and insertion operators, memory as a stream object, command line arguments and printer output. Templates and Exceptions: Function templates, Class templates Exceptions.
Total Lectures = 50
Solution of a nonlinear algebraic and transcendental equations: Bisection method, False position, Newton Raphson method, Iterative Method, Lin Bairstow’s method.
Solution of Simultaneous linear equation: Gauss elimination, Gauss Jordan, LU decomposition, Crout’s method, Jacobi, Gauss Seidel, Relaxation method, Inverse of a matrix using iterative method.
Finite differences: Introduction and different types of operators and relation between them. Factorial notation and Polynomial in factorial notation.
Interpolation: Introduction Newton forward and backward interpolation, Newton Divided differences, Lagrange’s Interpolation, Central difference interpolation formula, Gauss forward and backward interpolation formula. Numerical differentiation.
Numerical Integration: Trapezoidal and Simpson’s rules, Weddle’s rule and their order of error.
Solution of ordinary differential equation: Euler’s method, Euler’s modified method, Runga Kutta method, Taylor’s Series method, Picard’s method, Adams-Bashforth method.
Note: Students may use scientific calculator for numerical calculations of various functions (Log, Exponential, Trigonometrical, etc.)
Total Lab Classes = 60
DDL:
CREATE, ALTER, DROP, INDEX
DML:
insert, delete, update, and commands related to queries on tables – simple and nested queries. Basic data retrieval; condition specification; order by; Use of logical operators – and, or, not; Range searching; Pattern matching; arithmetic and aggregate functions; Joining multiple tables – (Equi joins); set manipulations – Any, All, In, Exists, Union, Intersect, Minus, grouping command. Creating views.
DCL:
GRANT and REVOKE
TCL:
COMMIT, ROLLBACK and SAVEPOINT
Total Lectures = 60
Input/Output using
cin
/
cout
. Decision making using
if else
,
switch case
, conditional operator. Looping using
while
,
do while
and
for
. Array – single and multi dimension. Function – simple, recursive, call by value and reference, overloading, default argument value. Class - Constructor, Member Functions. Operator overloading. Friend function. Inheritance – Single, Multilevel, Multiple, Virtual Function. Stream handling.
Ex 1A:
if .. else
statement
for loop - Write a C++ program to print the different Pyramid structures.
while loop - Write a C++ program to print the Fibonacci series 0 1 1 2 3 5 8 13 ....
By getting number of numbers to be displayed as input.
Eg. If 5 is input value, it should print first 5 numbers: 0 1 1 2 3
Write a C++ program to find the number of vowels present in the given character array using pointer arithmetic.
Write a C++ program to print the given number in reverse order. Use functions with return type and without return type for reversing the number.
Ex:
Given number is 2345, output should be 5432
Write a C++ program to find the sum of factorial of a given number using recursive function.
Write a C++ program to perform different arithmetic operations such as addition, subtraction, division, modulus, and multiplication using inline function.
Write a C++ program to swap two numbers by both call by value and call by reference mechanism, using two functions
swap_value()
and
swap_reference()
respectively, by getting the choice from the user and executing the user's choice by switch-case.
Write a C++ program to demonstrate the static and non-static variable usage defining them within a function.
Create a class for counting the number of objects created and destroyed within various blocks using constructor and destructor.
Write a C++ program to create three objects for a class named
pntr_obj
with data members such as roll number and name.
Create a member function
set_data()
for setting the data values and
print()
member function to print which object has invoked it using
this
pointer.
Write a C++ program with different classes related through multiple inheritance and demonstrate the use of different access specifiers by means of member variables and member functions.
Write a C++ program to explain virtual function (polymorphism) by creating a base class
c_polygon
which has virtual function
area()
.
Two classes
c_rectangle
and
c_triangle
derived from
c_polygon
and they have
area()
to calculate and return the area of rectangle and triangle respectively.
Write a C++ program to count the number of persons inside a bank, by increasing count whenever a person enters a bank, using an increment (
++
) operator overloading function,
and decrease the count whenever a person leaves the bank using a decrement (
--
) operator overloading function inside a class.
Write a C++ program to create two objects of a class called
company
and add their data members using an operator overloaded function for
+
operator and
-
operator.
Write a program to accept the student detail such as name and 3 different marks by
get_data()
method and display the name and average of marks using
display()
method.
Define a friend class for calculating the average of marks using the method
mark_avg()
.