Programming Skill in C
Programming Skill in C
Programming Skill in C
Curriculum for
SY B. Tech.
(Computer Engineering)
2018 Pattern
Department of
Computer Engineering
1
Bansilal Ramnath Agarwal Charitable Trust’s
Vishwakarma Institute of Information Technology, Pune-48
(An Autonomous Institute affiliated to Savitribai Phule Pune University)
“Excellence in the field of Computer Engineering for rendering services to the industry
and society”.
• Mission
To strive for excellence at different levels and diverse dimensions in the field of
computer engineering.
• PSO a: Use knowledge to write programs and integrate them with the
hardware/software products in the domains of embedded systems, data Science,
networking and web technology.
2
Bansilal Ramnath Agarwal Charitable Trust’s
Vishwakarma Institute of Information Technology, Pune-48
(An Autonomous Institute affiliated to Savitribai Phule Pune University)
S.Y.B.Tech.
Pattern 2018
Syllabus Structure
3
Bansilal Ramnath Agarwal Charitable Trust’s
Vishwakarma Institute of Information Technology, Pune-48
(An Autonomous Institute affiliated to Savitribai Phule Pune University)
ISE ES PR/
L T P CE
T1 T2 E OR
Analog and Digital
CSUA21181 Electronics TH 3 1 - 20 10 20 50 - 100 4
M2 Mandatory Course AU - - - - - - - - - -
Total 17 1 8 100 50 250 250 50 700 22
Lab practice will be based on * marked ‘TH’ Courses mentioned in the structure.(DSA 4 Hrs + CAO 2 Hrs.)
CSUA22186 CE-
Lab Practice – II - - 6 - - 50 - 50 100 3
PR/OR
CSUA22187 IT Workshop (Java) CE 2 - 2 - - 100 - - 100 3
Fundamentals of
CSUA22188 CE 2 - - - - 100 - - 100 2
Computer Networks
M2 Mandatory Course AU - - - - - - - - - -
Total 19 1 8 100 50 350 250 50 800 24
Lab practice will be based on * marked ‘TH’ Courses mentioned in the structure
5
Bansilal Ramnath Agarwal Charitable Trust’s
Vishwakarma Institute of Information Technology, Pune-48
(An Autonomous Institute affiliated to Savitribai Phule Pune University)
Prerequisites :
Basic Electronics Engineering
Course Objectives :
To learn basic digital circuit design techniques.
To study the implementation of digital circuits using combinational logic.
To explain and implement circuits using sequential logic.
To illustrate the concept of PLD’s & ASM.
To show the implementation of digital circuits using VHDL.
To explain the basics of Logic Families.
Course Outcomes :
After completion of the course, student will be able to
1. Simplify Boolean algebraic expressions for designing digital circuits using K-
Maps. (Analyzing)
2. Apply digital concepts in designing combinational circuits. (Applying)
3. Apply digital concepts in designing sequential circuits. (Applying)
4. Design digital circuits using PLA and PAL. (Creating)
5. Develop digital circuits using VHDL. (Creating)
6. Design and implement Mini digital circuits. (Creating)
6
Bansilal Ramnath Agarwal Charitable Trust’s
Vishwakarma Institute of Information Technology, Pune-48
(An Autonomous Institute affiliated to Savitribai Phule Pune University)
Flip-flop: SR, JK, D, T; Preset & Clear, Master and Slave Flip Flops, Truth Tables and
Excitation tables, Conversion from one type to another type of Flip Flop.
Registers: Buffer register, shift register (SISO, SIPO, PISO& PIPO), Applications of shift
registers.
Unit IV : Counters
Counters: Asynchronous counter. Synchronous counter, ring counters, Johnson Counter,
Modulus of the counter (IC 7490).
Synchronous Sequential Circuit Design: Models – Moore and Mealy, State diagram and
State Tables, Design Procedure, Sequence generator and detector.
Asynchronous Sequential Circuit Design: Difference with synchronous circuit design,
design principles and procedure, applications.
Unit V : Logic Families
Classification of logic families: Unipolar and Bipolar Logic Families, Characteristics of Digital
ICs: Speed, power dissipation, figure of merits, fan-out, Current and voltage parameters, Noise
immunity, operating temperature range, power supply requirements.
Transistor-Transistor Logic: Operation of TTL, TTL characteristics.
CMOS: CMOS Inverter, CMOS characteristics, CMOS configurations- Wired Logic, Open
drain outputs.
Interfacing: TTL to CMOS and CMOS to TTL.
Digital Circuit Implementation using IOT: Introduction to soldering techniques and its types,
Mounting of electronic components on PCB. Introduction and applications of Raspberry pi
and Arduino architecture.
Unit VI : Introduction to PLD’s & VHDL
Introduction to PLD’s: - PAL, PLA, Applications of PLAs to implement combinational and
sequential logic circuits, FPGA and CPLD.
VHDL: Introduction to HDL, Data Objects & Data Types, Attributes., VHDL- Library,
Design Entity, Architecture, Modeling Styles, Concurrent and Sequential Statements.
Design Examples: VHDL for Combinational Circuits-Adder, MUX, VHDL for Sequential
Circuits, Synchronous and Asynchronous Counter.
Text Books :
1 R. P. Jain, “Modern Digital Electronics”, 3rd Edition, Tata McGraw-Hill, 2003,
ISBN0 – 07 – 049492 – 4.
2 J. Bhaskar, “VHDL Primer” 3rd Edition, Pearson Edition.
3 Stephen Brown, ZvonkoVranesic, “Fundamentals of Digital Logic with VHDL
Design”, McGraw Hill, ISBN–13:978-1-25-902597-6.
4 G.K.Kharate, ”Digital Electronics”, Oxford University Press.
Reference Books :
1 John Yarbrough, “Digital Logic applications and Design” Thomson.
2 Flyod “Digital Principles”, Pearson Education.
3 Malvino, D.Leach “Digital Principles and Applications”, 5th edition, Tata Mc-
Graw Hill.
7
Bansilal Ramnath Agarwal Charitable Trust’s
Vishwakarma Institute of Information Technology, Pune-48
(An Autonomous Institute affiliated to Savitribai Phule Pune University)
8
Bansilal Ramnath Agarwal Charitable Trust’s
Vishwakarma Institute of Information Technology, Pune-48
(An Autonomous Institute affiliated to Savitribai Phule Pune University)
Prerequisites :
Basic Algebra
Course Objectives :
To study basic of logic and set theory
To understand notion of functions and relations
To study fundamental principles of graphs
To study fundamental principles of trees elementary combinatorial processes
To study fundamental principles of probability theory
To study basic of logic and set theory
Course Outcomes :
After completion of the course, student will be able to
1. Demonstrate use of logical arguments, proof techniques and set theory principles
2. Determine type, properties and solution of relations and functions
3. Solve the problems using graph methods and algorithms
4. Apply tree models and methods to obtain solutions of applications involving
searching, prefix code and vertex connectivity
5. Apply principles of counting to obtain solution to counting problems
6. Apply probability theory, principles and distributions in problem
9
Bansilal Ramnath Agarwal Charitable Trust’s
Vishwakarma Institute of Information Technology, Pune-48
(An Autonomous Institute affiliated to Savitribai Phule Pune University)
graph, Paths and Circuits, Hamiltonian and Euler paths and circuits, Shortest path in weighted
Graph (Dijkstra’s algorithm), Factors of a graph, Planar graph and Travelling salesman
problem, Graph coloring.
Unit IV : Trees
Trees, Rooted trees, Path length in rooted trees, Prefix codes and optimal prefix codes, Binary
search trees, Tree traversals, Spanning trees, Fundamental circuits and cut set, Minimal
spanning trees, Kruskal’s and Prim’s algorithms for minimum spanning tree, The Max flow –
Min cut theorem (transport network).
Unit V : Counting
Permutations and Combinations: Rule of sum and product, Pigeonhole principle, Permutations,
Combinations, Binomial Coefficients and identities, Algorithms for generation of Permutations
and Combinations.
Unit VI : Discrete Probability
Discrete Probability, Conditional Probability, Bayes’ Theorem, Random variable, Random
process, Mean, Mode, Variance, Probability distributions: Binomial trials and Distribution,
Binomial probability distribution, Poisson probability distribution, Gaussian probability
distribution,
Text Books :
1 Kenneth H. Rosen, “Discrete Mathematics and its Applications”, 6th edition,
McGraw-Hill, 2007. ISBN 978-0-07-288008-3.
2 C. L. Liu and D. P. Mohapatra, “Elements of Discrete Mathematics”, 6th
edition,TataMcGraw-Hill, 2008, ISBN 10:0-07-066913-9.
3 R. Johnsonbaugh, “Discrete Mathematics”, 5th Edition, Pearson Education, 2001
ISBN 81 –7808 – 279 – 9.
Reference Books :
1 B. Kolman, R. Busby and S. Ross, “Discrete Mathematical Structures”, 4th Edition,
Pearson Education, 2002, ISBN 81-7808-556-9
2 N. Deo, “Graph Theory with application to Engineering and Computer Science”,
Prentice Hall of India, 1990, 0 – 87692 – 145 – 4
3 Eric Gossett, “Discrete Mathematics with proof”, 2nd edition, Wiley Student
Edition, ISBN: 978-81-265-2758-8
10
Bansilal Ramnath Agarwal Charitable Trust’s
Vishwakarma Institute of Information Technology, Pune-48
(An Autonomous Institute affiliated to Savitribai Phule Pune University)
Prerequisites :
Computer Fundamentals
Course Objectives :
Employ a problem-solving strategy to breakdown a complex problem into a series
of simpler tasks.
Execute problem-solving actions appropriate to completing a variety of sub
problems.
Apply analytical and logical thinking to extract facts from a problem description
and determine how they relate to one another and to the problems to be solved.
Design and implement a solution using appropriate programming paradigm to
solve a real life problem.
Develop problem-solving and programming skills
Course Outcomes :
After completion of the course, student will be able to
1. Employ a problem-solving strategy to breakdown a complex problem into a series
of simpler tasks.
2. Apply analytical and logical thinking to extract facts from a problem description
and determine how they relate to one another and to the problems to be solved.
3. Abstract data and entities from the problem domain, build object models and
design software solutions using object –oriented principles and strategies.
4. Develop programs that appropriately utilize Logic programming concepts.
5. Develop programs that appropriately utilize Functional programming concepts.
6. Adequately use standard programming constructs and implement a given algorithm
as a computer program (in Python)
11
Bansilal Ramnath Agarwal Charitable Trust’s
Vishwakarma Institute of Information Technology, Pune-48
(An Autonomous Institute affiliated to Savitribai Phule Pune University)
Introduction to programming structure - modules and their functions, cohesion & coupling,
local and global variable, parameters, return values, variable names and data dictionaries, three
logic structures
Problem solving with sequential logic structure - algorithm instructions, flowchart, symbols,
pseudo code , the sequential logic structure, solution development.
Problem Solving with Decisions – decision logic structure, multiple if/then/else instructions,
straight-through logic, positive logic, negative logic, logic conversion, decision tables, case
logic structures.
Problem solving with loops- the loop logic structure, incrementing, accumulating,
while/whileEnd, repeat/Until, automatic counter loop, nested loops, indicators, recursion
Unit III : Procedural & Object Oriented Programming
Procedural Programming- Design Principles, Control flow: statement-oriented and block-
oriented structure programming, execution steps, desirable and undesirable characteristics of
procedural programming, comparative study of C and PASCAL.
Object Oriented Programming- Design Principles: Objects, classes, Messages and methods,
implementation of Object-oriented Programming, Object oriented programming with C++-
Program structure, Object and class declarations, constructors, inheritance, polymorphism,
access specification, exception handling, comparative study of C++ and Java.
Unit IV : Logic Programming
Logic Programming: Relations, First Order Logic, Logic Programming and Horn-Clause
Programming, Unification, Deduction and Search as a strategy for deduction, Indexing,
Pruning, Definite Clause Grammars. Case Study on Logic Programming with Prolog
Unit V : Functional Programming
Introduction and basic elements of Functional Programming, Lists and associated Operations,
Function Declaration, Higher Order Functions, Polymorphism, Data Types
Case Study on Functional Programming with LISP.
Unit VI: Programming in Python
Variables, operations, control flow - assignments, condition-als, loops, functions, types,
expressions, strings, lists, tuples , Python memory model: names, mutable and immutable
values, list operations-slices, Dictionaries More on Python functions- optional arguments,
default values, passing functions as arguments , higher order functions on lists: map, iter, list
comprehension
Text Books :
1 Ravi Sethi , "Programming Languages: Concepts and Constructs" 2nd Edition by
Addison Wesley
2 Maureen Spankle & Jim Hubbard, “Problem Solving and Programming Concepts”,
Pearson, 9th edition, ISBN-13: 978-0132492645.
3 R G Dromey, “How to Solve it by Computer”, Pearson Education, 2008, ISBN-13:
978-8131705629.
Reference Books :
1 Scbesta R., "Concepts Of Programming Languages", 4th Edition, Pearson Education,
12
Bansilal Ramnath Agarwal Charitable Trust’s
Vishwakarma Institute of Information Technology, Pune-48
(An Autonomous Institute affiliated to Savitribai Phule Pune University)
ISBN-81-7808-161-X
2 Herbert Schildt "The Complete Reference Java2", 5th Edition, Tata McGraw-Hill 0 - 07-
049543-25.
3 K.Venugopal., "Programming in Turbo PASCAL", Tata-McGraw Hill
4 Winston P., Klaus B., Horn P., "LISP", 3rd Edition, Pearson Education, 81 - 7808 -155-
5
5 Carl Townsend ,”Programming in turbo PROLOG”, Tata-McGraw Hill
6 Herbert Schildt, “C++: The Complete Reference”, McGraw-Hill.
7 E. Balaguruswamy, “Object-oriented Programming with C++”, Tata McGraw Hill, 5th
edition.
8 Mark Lutz, "Learning Python" O'Reilly , 5th edition, ISBN-10: 0-596-51398-4
13
Bansilal Ramnath Agarwal Charitable Trust’s
Vishwakarma Institute of Information Technology, Pune-48
(An Autonomous Institute affiliated to Savitribai Phule Pune University)
Prerequisites :
Basics of Computer Programming
Course Objectives :
To study linear and non-lineardata structures and their applications.
To understand concepts about searching and sorting techniques.
To enable students to write algorithms for solving problems with the help of fundamental
data structures.
Course Outcomes :
After completion of the course, student will be able to
1. Understand arrays and their implementation with basics of algorithm analysis.(Understand)
2. Select appropriate searching and/or sorting techniques in the application
development.(Evaluate)
3. Apply various linear data structures using sequential and linked organization for problem
solving and programming.(Apply)
4. Apply advanced linear data structures stack and queue for problem solving and
programming.(Apply)
5. Use tree data structure for problem solving and programming. (Apply)
6. Use graph data structure for problem solving and programming. (Apply)
14
Bansilal Ramnath Agarwal Charitable Trust’s
Vishwakarma Institute of Information Technology, Pune-48
(An Autonomous Institute affiliated to Savitribai Phule Pune University)
Application of stack for expression conversion and evaluation, Recursion concept and use of
internal stack.
Queues: Concept of queue & its application, Linear queue, Circular queue Priority queue,
Applications of queue
Unit V : Non-linear Data Structures: Trees
Difference in linear and non-linear data structure, Basic tree concepts, Binary tree, Binary
Search Tree ADT, Concept of threaded binary tree and traversal, Applications of trees
Unit VI : Non-linear Data Structures: Graphs
Basic concept, Graph as an ADT, Representation of graphs using adjacency matrix and
adjacency list, Depth First Search and Breadth First Search traversal, Prim’s and Kruskal’s
algorithm for MST, Dijkstra’s algorithm, Applications of Graphs.
Text Books :
1 Horowitz and Sahani, ―Fundamentals of Data Structures in C++, University
Press, ISBN 10: 0716782928 ISBN 13: 9780716782926.
2 R. Gillberg, B. Forouzn, ―Data Structures: A Pseudo code approach with C‖,
Cenage Learning, ISBN 9788131503140.
3 Tanenbaum, Y. Langsam, M. Augenstein: Fundamentals of Data Structure, 2nd
edition, Pearson Education, 2002, ISBN-81-7808-670-0.
Reference Books :
1 M. Weiss, ―Data Structures and Algorithm Analysis in C++, 2nd edition,
Pearson Education, 2002, ISBN-81-7808-670-0.
2 Introduction to Algorithms 3rd Edition by Thomas H. Cormen, Charles
E.Leiserson,Ronald L Rivest,& Clifford Stein, MIT Press ,Cambridge MA USA
,ISBN 978-81-203-4007-7
15
Bansilal Ramnath Agarwal Charitable Trust’s
Vishwakarma Institute of Information Technology, Pune-48
(An Autonomous Institute affiliated to Savitribai Phule Pune University)
Prerequisites:
Analog and Digital Electronics
Course Objectives:
To identify the elements of modern instructions sets and explain their impact on
processor design.
To study memory management in microprocessor.
To study protection mechanism of microprocessor.
To explain the function of each element of a memory hierarchy, identify and
compare different methods for computer I/O.
To understand various computer arithmetic techniques.
To study pipelined architecture in microprocessors.
Course Outcomes:
After completion of the course, student will be able to
1 Demonstrate the use of Instruction sets in assembly programming. (Understand)
2 Comprehend segmentation and paging techniques.(Understand)
3 Compare segment descriptors and different privileges levels. (Analyze)
4 Sketch the concepts of memory and I/O. (Apply)
5 Solve numerical problems using computer arithmetic techniques.(Analysis)
6 Use of Pipeline Architecture. (Apply)
16
Bansilal Ramnath Agarwal Charitable Trust’s
Vishwakarma Institute of Information Technology, Pune-48
(An Autonomous Institute affiliated to Savitribai Phule Pune University)
Text Books :
1 W. Stallings, ―Computer Organization and Architecture: Designing for
performance‖, Pearson Education/ Prentice Hall of India, 2003, ISBN 978-93-325-
1870-4, 7th Edition.
2 Zaky S, Hamacher, ―Computer Organization‖, 5th Edition, McGraw-Hill
Publications, 2001, ISBN- 978-1-25-900537-5, 5th Edition.
3 Douglas Hall, “Microprocessors & Interfacing”, McGraw Hill, Revised 2nd
Edition, 2006 ISBN 0-07-100462-9
Reference Books :
1 John P Hays, ―Computer Architecture and Organization‖, McGraw-Hill
Publication, 1998, ISBN:978-1-25-902856-4, 3rd Edition.
2 Intel 64 and IA-32-bit architectures Software Developer’s Manual, Volume 3A,
Intel, (Digital Content PDF: 253668.pdf)
3 A.Ray, K.Bhurchandi, ”Advanced Microprocessors and peripherals: Arch,
Programming & Interfacing”,Tata McGraw Hill,2004 ISBN 0-07-463841-6
17
Bansilal Ramnath Agarwal Charitable Trust’s
Vishwakarma Institute of Information Technology, Pune-48
(An Autonomous Institute affiliated to Savitribai Phule Pune University)
Prerequisites :
Computer Fundamentals
Course Objectives :
To impart the basic concepts of data structures and algorithms
To understand concepts about searching and sorting techniques
To understand basic concepts about stacks, queues, lists, trees and graphs
To enable them to write algorithms for solving problems with the help of fundamental data
structures
Course Outcomes :
After completion of the course, student will be able to
1. Understand the basic concepts of data structures and algorithms.
2. Represent, implement and apply various data structures viz. Arrays, Linked list,
stack queue, Trees and Graphs to real time application
3. Apply searching and sorting techniques required for given application
18
Bansilal Ramnath Agarwal Charitable Trust’s
Vishwakarma Institute of Information Technology, Pune-48
(An Autonomous Institute affiliated to Savitribai Phule Pune University)
19
Bansilal Ramnath Agarwal Charitable Trust’s
Vishwakarma Institute of Information Technology, Pune-48
(An Autonomous Institute affiliated to Savitribai Phule Pune University)
Text Books :
1 Horowitz and Sahani, ―Fundamentals of Data Structures in C++, University
Press, ISBN 10: 0716782928 ISBN 13: 9780716782926.
2 R. Gillberg, B. Forouzn, ―Data Structures: A Pseudo code approach with C‖,
Cenage Learning, ISBN 9788131503140.
3 A. Tanenbaum, Y. Langsam, M. Augenstein: Fundamentals of Data
Structure, 2nd edition, Pearson Education, 2002, ISBN-81-7808-670-0.
Reference Books :
1 M. Weiss, ―Data Structures and Algorithm Analysis in C++, 2nd edition, Pearson
Education, 2002, ISBN-81-7808-670-0.
2 Introduction to Algorithms 3rd Edition by Thomas H. Cormen, Charles
E.Leiserson,Ronald L Rivest,& Clifford Stein, MIT Press ,Cambridge MA USA
,ISBN 978-81-203-4007-7
20
Bansilal Ramnath Agarwal Charitable Trust’s
Vishwakarma Institute of Information Technology, Pune-48
(An Autonomous Institute affiliated to Savitribai Phule Pune University)
Prerequisites :
Computer Fundamentals
Course Objectives :
To understand object-oriented concepts such as data abstraction, encapsulation,
inheritance, dynamic binding, and polymorphism.
To use the object-oriented paradigm in program design.
Provide programming insight using OOP constructs.
To lay a foundation for advanced programming.
Course Outcomes :
After completion of the course, student will be able to
1. Understand the concept of OOP.
2. Apply concept and use of reusability
3. Develop application using concept of polymorphisms
4. Implement application using generic programming concepts
5. Ability to perform file operations
6. Percept the utility and applicability of OOP.
21
Bansilal Ramnath Agarwal Charitable Trust’s
Vishwakarma Institute of Information Technology, Pune-48
(An Autonomous Institute affiliated to Savitribai Phule Pune University)
Text Books :
1 Behrouz A. Forouzan, Richard F. Gilberg, “COMPUTER SCIENCE – A
Structred Programming approach using C”, Indian Edition, Thomson, 3rd edition
2 Bjarne Stroustrup, ― The C++ Programming language‖, Third edition, Pearson
Education. ISBN 9780201889543
Reference Books :
1 Kernighan, Ritchie, “The C Programming Language”, Prentice Hall of India
2 Robert Lafore, ―Object-Oriented Programming in C++, fourth edition, Sams
Publishing, ISBN:0672323087 (ISBN 13: 9780672323089)
3 Herbert Schildt, ―C++ The complete reference‖, Eighth Edition, McGraw Hill
Professional, 2011, ISBN:978-00-72226805
4 E. Balagurusamy-- Object-oriented programming with C++, fourth edition, Mc
Hill Professional,2008, ISBN 978-0-07-066907-9
22
Bansilal Ramnath Agarwal Charitable Trust’s
Vishwakarma Institute of Information Technology, Pune-48
(An Autonomous Institute affiliated to Savitribai Phule Pune University)
Prerequisites :
Basics of Derivatives, Integration, Trigonometry, Vector algebra & Partial differentiation
Course Objectives :
To study the Linear Differential equations and their applications.
To impart knowledge of Fourier transform and Z- transform.
To apply Numerical techniques for data analysis.
To apply statistical techniques for data analysis.
To solve probability distributions.
To solve complex variables and complex integrations.
Course Outcomes :
After completion of the course, student will be able to
1. Solve the Linear Differential equations, modelling of mass spring systems, free and
forced damped and undamped systems.
2. Solve Fourier Transform and Z-Transform.
3. Solve Numerical technique to analyses the data,
4. Solve statistical technique to analyze the data.
5. Solve Different Probability Distributions
6. Solve Complex variables and Applications of CR Equations.
23
Bansilal Ramnath Agarwal Charitable Trust’s
Vishwakarma Institute of Information Technology, Pune-48
(An Autonomous Institute affiliated to Savitribai Phule Pune University)
Text Books :
1 A Text book of Applied Mathematics by P.N. Wartikar, U.N.Wartikar (Pune Vidyarthi
Griha Prakashan ,Pune) (Volume II-ISBN 81-85825-07-6)((Volume III-ISBN 81-85825-01-
7)
2 Advanced Engineering Mathematics by Erwin Kreyszig (Wiley Eastern Ltd.).(ISBN 978-0-
470-45836-5.)
Reference Books :
1 Higher Engineering Mathematics by B.S.Grewal (Khanna Publication, Delhi)(ISBN-13. 978-
81-7409-195-5. ISBN-10. 81-7409-195-5)
2 Advanced Engineering Mathematics by Wylie C.R &Barrett L.C.(McGraw-Hill,INC)(ISBN
0 - 07 -463841 – 6)
3 Advanced Engineering Mathematics by Peter V.O’Neiol (ISBN-13: 9781111427429 / ISBN-10:
1111427429)
24
Bansilal Ramnath Agarwal Charitable Trust’s
Vishwakarma Institute of Information Technology, Pune-48
(An Autonomous Institute affiliated to Savitribai Phule Pune University)
Text books :
1. A Text book of Applied Mathematics by P.N. Wartikar, U.N.Wartikar (Pune Vidyarthi Griha
Prakashan ,Pune) (Volume II-ISBN 81-85825-07-6)((Volume III-ISBN 81-85825-01-7)
2. Advanced Engineering Mathematics by Erwin Kreyszig (Wiley Eastern Ltd.).(ISBN 978-0-470-
45836-5.)
Reference Books :
1. Higher Engineering Mathematics by B.S.Grewal (KhannaPublication,Delhi)
(ISBN-13. 978-81-7409-195-5. ISBN-10. 81-7409-195-5)
2. Advanced Engineering Mathematics by Wylie C.R &Barrett L.C.(McGraw-Hill,INC)(ISBN 0 -
07 -463841 – 6)
3. Advanced Engineering Mathematics by Peter V.O’Neiol
(ISBN-13: 9781111427429 / ISBN-10: 1111427429)
25
Bansilal Ramnath Agarwal Charitable Trust’s
Vishwakarma Institute of Information Technology, Pune-48
(An Autonomous Institute affiliated to Savitribai Phule Pune University)
Prerequisites :
Discrete Mathematics, Data Structure and Algorithms
Course Objectives :
To understand the fundamental concepts of database management.
To provide a strong formal foundation in database concepts, technology.
To give systematic database design approaches covering conceptual design,
logical design and an overview of physical design.
To learn basic issues of transaction management and concurrency control
To learn and understand various Database Architectures and Applications
To learn a powerful, flexible and scalable general purpose database to handle big
data
Course Outcomes :
After completion of the course, student will be able to
1. Remember the concepts of file processing and design E-R Model for given requirements
and convert the same into database tables.(Remember).
2. Apply database techniques such as SQL & PL/SQL(Apply).
3. Evaluate database design concept such as normalization.(Evaluate).
4. Analyze transaction management techniques in relational database System.(Analyze).
5. Comprehend various database architectures in real time environment. (Comprehend).
6. Apply advanced database programming concepts in Big Data applications.(Apply).
26
Bansilal Ramnath Agarwal Charitable Trust’s
Vishwakarma Institute of Information Technology, Pune-48
(An Autonomous Institute affiliated to Savitribai Phule Pune University)
Variables, Set comparison, Ordering of Tuples, Aggregate Functions, Nested Queries, Database
Modification using SQL Insert, Update and Delete Queries. PL/SQL: Concept of Stored
Procedures and Functions, Cursors, Triggers,
Roles and Privileges,Embedded SQL, Dynamic SQL.
Unit III : Relational Database Design
Relational Model: Basic concepts, Attributes and Domains, CODD's Rules, Functional
Dependencies: Basic concepts, closure of set of functional dependencies, closure of attribute set,
canonical cover,Decomposition: lossless join decomposition and dependency preservation, The
Process of normalization, 1NF, 2NF, 3NF,BCNF, 4NF, 5NF.
Unit IV : Database Transactions and Query Processing
Basic concept of a Transaction, Transaction Management, Properties of Transactions, Concept of
Schedule, Serial Schedule, Serializability: Conflict and View, Testing conflict and view
serializability, Recoverable and Non-recoverable Schedules, Concurrency Control: Need, Locking
Methods, Deadlocks, Timestamping Methods, Different Crash Recovery methods such as Shadow-
Paging and Log-Based Recovery: Deferred and Immediate, Checkpoints, Introduction to Query
Processing and Query Optimization, Performance Tuning in SQL.
Unit V : Database architecture
Introduction to Database Architectures: Multi-user DBMS Architectures, Parallel Databases:
Speedup and Scale up, Architectures of Parallel Databases. Distributed Databases: Architecture of
Distributed Databases, Distributed Database Design, Distributed Data Storage, Distributed
Transaction: Basics, Failure modes, Commit Protocols, Concurrency Control in Distributed
Database.
Unit VI : Advances in Databasesand Big Data
Introduction to NoSQL, Structured versesUnstructured data, Different NoSQL Data Models,
NoSQL using MongoDB,CAP theorem and BASE Properties, Comparative study of SQL and
NoSQL, Introduction to Big Data, HADOOP- Building blocks of Hadoop, components of Hadoop-
HDFS, MapReduce, HBASE, HIVE
Text Books :
1 Abraham Silberschatz ,HenryKorth , S.Sudarshan,"Database System concepts",5th
Edition ,McGraw Hill International Edition.
2 Elmasri R., Navathe S., "Fundamentals of Database Systems", 4* Edition,
PearsonEducation, 2003, ISBN 8129702282.
3 Pramod J. Sadalage and Martin Fowler, ―NoSQL Distilled‖, Addison Wesley,
ISBN10: 0321826620, ISBN-13: 978-0321826626
4 “Managing and Using MySQL”, Reese G., Yarger R., King T., Williums H, 2nd
Edition, Shroff Publishers and Distributors Pvt. Ltd., ISBN 81 - 7366 - 465 – X
5 MongoDB: The Definitive Guide by Kristina Chodorow
Reference Books :
1 Ramkrishna R., Gehrke J., "Database Management Systems", 3rd Edition, McGraw-
Hill, 2003, ISBN 0-07- 123151 –X.
2 C J Date, ―An Introduction to Database Systems‖, Addison-Wesley, ISBN:
27
Bansilal Ramnath Agarwal Charitable Trust’s
Vishwakarma Institute of Information Technology, Pune-48
(An Autonomous Institute affiliated to Savitribai Phule Pune University)
0201144719.
3 Connally T., Begg C., "Database Systems", 3rd Edition, Pearson Education, 2002,
ISBN 81-7808-861-4
4 MongoDB , O’Reilly Publications.
5 Hadoop, O’Reilly Publications.
6 http://docs.mongodb.org/manual/ or
SQL/XML/MongoDB (https://www.w3schools.com/)
28
Bansilal Ramnath Agarwal Charitable Trust’s
Vishwakarma Institute of Information Technology, Pune-48
(An Autonomous Institute affiliated to Savitribai Phule Pune University)
Prerequisites :
Computer Organization and Architecture
Course Objectives :
To provide understanding of the concepts like virtualization, concurrency and
persistence in operating systems.
To study the design and implementation of scheduling and memory management
policies in Operating systems.
To demonstrate the working of concurrency and locking mechanism in operating
systems
To provide insights of I/O management in Operating Systems
To make them aware of advanced topics e.g. data protection, distributed systems in
Operating Systems.
To teach the case studies of xv6 and Linux OS
Course Outcomes :
After completion of the course, student will be able to
1. Summarize the concepts of virtualization, concurrency and persistence
(Understanding)
2. Implement proper scheduling and memory management policies for the OS
(Create)
3. Analyze concurrency and locking mechanism in OS (Analyze)
4. Describe the I/O management in OS ( Remember)
5. Express the advanced topics in OS (Understanding )
6. Compare the working of xv6 and Linux OS (Compare)
29
Bansilal Ramnath Agarwal Charitable Trust’s
Vishwakarma Institute of Information Technology, Pune-48
(An Autonomous Institute affiliated to Savitribai Phule Pune University)
Text Books :
1 Remzi H. Arpaci-Dusseau and Andrea C. Arpaci-Dusseau “Operating Systems:
Three Easy Pieces”, Arpaci-Dusseau Books, March , 2015
2 Stallings William., "Operating Systems", Fourth Edition, Prentice Hall of
India,2001
Reference Books :
1 Silberschatz, A, Galvin, P.B, and Gagne, G., “Operating System Principles”, Eight
Edition, John Wiley & Sons, 2008.
2 Bach Maurice J. “The Design of the UNIX Operating System”, Second Edition
Prentice Hall of India, 2001
30
Bansilal Ramnath Agarwal Charitable Trust’s
Vishwakarma Institute of Information Technology, Pune-48
(An Autonomous Institute affiliated to Savitribai Phule Pune University)
Prerequisites :
Basic Mathematics, Discrete Structure
Course Objectives :
Understand fundamentals of computer mathematics.
Study the various abstract computing models.
Study the Regular expression
Study the different types of languages& their relationships
Study the different types of grammar & ambiguity in the grammar.
Study the recursive & recursively enumerable languages.
Course Outcomes :
After completion of the course, student will be able to
1. Apply the mathematical preliminaries with the help of proofs and lemmas for
language derivation.
2. Design of automata or hypothetical machines as language descriptors or recognizer.
3. Understand Regular expression & its conversion to automata & vice versa.
4. Understand the different application of Regular expression.
5. Understand the different types of languages ,grammars & ambiguity in the grammar.
6. Understand the recursive & recursively enumerable languages.
31
Bansilal Ramnath Agarwal Charitable Trust’s
Vishwakarma Institute of Information Technology, Pune-48
(An Autonomous Institute affiliated to Savitribai Phule Pune University)
derivation, parse tree, ambiguity in grammar and language, Simplifications of context free
Grammar-Eliminating unit productions, useless symbols, and Null-productions, Normal Forms
for CFG- Chomsky normal form, Greibach normal form .
Regular Grammar- Definition, left linear, right linear grammar, Interconversion between left
linear and right linear regular grammar
Unit IV : Push Down Automata
Push Down Automata- Definition, Notation, acceptance by final state, acceptance by empty
stack, Equivalence of PDA and CFG- Grammar to PDA, PDA to Grammar, Deterministic PDA
and Non Deterministic PDA. Closure Properties of CFLs.
Unit V : Turing machines
Turing machine Model, Representation of Turing machine, Language acceptability by Turing
machine, Design of Turing machine. Types of TM. Halting Problem
Unit VI : Recursively Enumerable Languages
Recursively Enumerable and Recursive, Properties of recursive and recursively enumerable
languages, Post correspondence problem,
Undecidability: Reducing one problem to another, Other unsolvable Problems. Tractable and In
Tractable Problems.
Text Books :
1 Mishra K., Chandrasekaran N., 'Theory of Computer Science (Automata, Languages
and Computation)", Second Edition, Prentice Hall of India
2 John C Martin. "Introduction to Language and Theory of Computation", Third
edition, Tata McGraw- Hill
Reference Books :
1 Hopcroft J., Motwani R., Ullman J., "Introduction to Automata Theory, Languages
and Computations", Third edition, Pearson Education Asia
32
Bansilal Ramnath Agarwal Charitable Trust’s
Vishwakarma Institute of Information Technology, Pune-48
(An Autonomous Institute affiliated to Savitribai Phule Pune University)
Prerequisites :
Nil
Course Objectives :
Human and social development
Contemporary national and international affairs
Emergence of Indian society and Economics
Sectoral development and Economic development and related issues (such as
international economics, WTO, RBI, etc)
Course Outcomes :
After completion of the course, student will be able to
1. Understand various issues concerning human and society.
2. Realize social, cultural, economic and human issues, involved in social changes
3. Understand the nature of the individual and the relationship between the self and the
community
4. Express their opinion about national health and education policies.
5. Understand major ideas, values, beliefs, and experiences that have shaped human
history and cultures.
6. Understand the fundamental concepts in engineering economics
33
Bansilal Ramnath Agarwal Charitable Trust’s
Vishwakarma Institute of Information Technology, Pune-48
(An Autonomous Institute affiliated to Savitribai Phule Pune University)
Text Books :
1 Krugman, International Economics, Pearson Education.
2 Prakash, The Indian Economy, Pearson Education.
3 Thursen Gerald, Engineering Economics, Prentice Hall.
4 C.S. Rao, Environmental Pollution Control Engineering, New Age International Pvt.
Ltd.
Reference Books :
1 Rangarajan, Environmental Issues in India, Pearson Education.
2 University of Delhi, The Individual & Society, Pearson Education.
3 Wikipedia.org / wiki /social studies.
4 M. N. Srinivas, Social change in modern India, 1991, Orient Longman.
5 David Mandelbaum, Society in India, 1990, Popular
34
Bansilal Ramnath Agarwal Charitable Trust’s
Vishwakarma Institute of Information Technology, Pune-48
(An Autonomous Institute affiliated to Savitribai Phule Pune University)
Prerequisites :
Computer Fundamentals
Course Objectives :
To develop basic, intermediate and advanced Database programming skills
To understand & apply various database commands for transaction processing
To have students understand the principles in the design and implementation of
operating systems software
To understand various operating system algorithms for resource management
To understand basic syntax of LEX specifications, and implement a lexical analyzer
using LEX specification
To understand parser generator tool YACC, and implement a parser using YACC
specification
Course Outcomes :
After completion of the course, student will be able to
1. Comprehend appropriate database programming constructs and apply for solving
problems of various domain
2. Comprehend advanced database Programming concepts to handle databases of
varying complexities
3. Comprehend the knowledge of operating systems software
4. Apply the operating system algorithms for tasks like scheduling, process
management etc
5. Apply LEX tool for lexical analysis purpose
6. Apply YACC tool for parsing purpose
List of Assignments
2. Design at least 10 SQL queries for suitable database application using SQL DML statements: Insert,
Select, Update, Delete with operators, functions, Set operators, Clauses.
35
Bansilal Ramnath Agarwal Charitable Trust’s
Vishwakarma Institute of Information Technology, Pune-48
(An Autonomous Institute affiliated to Savitribai Phule Pune University)
4.Write a PL/SQL code to implement all types of cursor (Implicit,Explicit) and display employee
number, name and salary of 5 highest paid employees using cursor.Employee(employee no, employee
name, join_date, designation, salary).
5.PL/SQL Stored Procedure and Stored Function : Write a PL/SQL procedure to find the number of
students ranging from 100-80%, 79-70%, 69-60%,59-50 & below 49% in each course from the
Student_course table given by the procedure as parameter.
Student_course(Roll_no,Course,Couse_code,Semester,Total_Marks,Percentage)
6. Database Trigger (Row level and Statement level triggers, Before and After Triggers):Write a database
trigger on Employee table. The System should keep track of the records that are being updated or deleted.
The old value of updated or deleted records should be added in to a new table when the Employee table is
updated. Employee(employee no, employee name, join_date, designation, salary).
10.Implement MYSQL database connectivity with Java for Database navigation operations such as
insert, delete, update etc. using ODBC/JDBC.
36
Bansilal Ramnath Agarwal Charitable Trust’s
Vishwakarma Institute of Information Technology, Pune-48
(An Autonomous Institute affiliated to Savitribai Phule Pune University)
2.Study LEX tool and write a program using LEX specification to implement lexical analysis phase of
compiler to generate tokens of subset of Java program.
3.Write a program using LEX specifications to implement lexical analysis phase of compiler to count no.
of words, lines and characters of given input file.
4.Write a program using YACC specifications to implement syntax analysis phase of compiler to validate
type and syntax of variable declaration in Java.
5.Write a program using YACC specifications to implement syntax analysis phase of compiler to
recognize simple and compound sentences given in input file.
Text Books :
1.SQL Server – Black Book”, Dalton Patrik, DreamTech Press.
A.
2. Kristina Chodorow, Michael Dirolf, ―MangoDB: The Definitive Guide‖, O‘Reilly Publications,
ISBN: 9781449381561
3. “Managing and Using MySQL”, Reese G., Yarger R., King T., Williums H, 2nd Edition, Shroff
Publishers and Distributors Pvt. Ltd., ISBN 81 - 7366 - 465 – X
1. Abraham Silberschatz Peter B. Galvin and Greg Gagne, Operating System Concepts, Wiley 8th
B
Edition,2008.
2. Andrew S. Tanenbaum and Herbert Bros, Modern Operating Systems (4th Edition), Pearson
C 1.John. R. Levine, Tony Mason and Doug Brown, ―Lex and Yacc‖, O'Reilly, 1998, ISBN: 1 -
56592-000-7
Reference Books :
A 1. MongoDB , O’Reilly Publications
2.http://www.tutorialspoint.com/json/ and http://docs.mongodb.org/manual/
B 1.Garry. J. Nutt, Operating Systems: A Modern Perspective, Addison-Wesley
2. Russ Cox, Frans Kaashoek, Robert Morris , xv6: a simple, Unix-like teaching operating
system",Revision 8 .
3. Sumitabha Das , UNIX Concepts and Applications, Tata McGraw-Hill
C 1.John E. Hopcroft, Rajeev Motwani, Jeffrey D.Ullman, ―Introduction to Automata Theory
Languages and Computation‖, Addison-Wesley, ISBN 0-201-44124-1.
37
Bansilal Ramnath Agarwal Charitable Trust’s
Vishwakarma Institute of Information Technology, Pune-48
(An Autonomous Institute affiliated to Savitribai Phule Pune University)
Prerequisites :
Object Oriented Programming
Course Objectives :
To explain the fundamentals of data structures and collections in Java.
To build software development skills using java programming for real world
applications.
To implement frontend and backend of an application
To implement classical problems using java programming.
Course Outcomes :
After completion of the course, student will be able to
1. Implement data structures and collections using Java language.
2. Explore and use the Java serialization and networking APIs for implementing various
functionalities of an Application.
3. Explore and use the database connectivity APIs and threading for implementing
various functionalities of an Application.
4. Analyze platform independent application runtime environment and choose
appropriate runtime environment to create GUI applications using AWT.
5. Implement data structures and collections using Java language.
6. Explore and use the Java serialization and networking APIs for implementing various
functionalities of an Application.
38
Bansilal Ramnath Agarwal Charitable Trust’s
Vishwakarma Institute of Information Technology, Pune-48
(An Autonomous Institute affiliated to Savitribai Phule Pune University)
Text Books :
1 Java Enterprise Best Practices by The O'Reilly Java Authors
2 Java 2: The Complete Reference by Herbert Schildt, Mcgraw-Hill
Reference Books :
1 Java in a Nutshell by David Flanagan, Oreilly
2 Java Cookbook by Ian F. Darwin Oreilly
39
Bansilal Ramnath Agarwal Charitable Trust’s
Vishwakarma Institute of Information Technology, Pune-48
(An Autonomous Institute affiliated to Savitribai Phule Pune University)
Prerequisites :
Nil
Course Objectives :
To study the fundamentals of networking
To understand functionalities of Physical layer
To understand the functionalities of Logical Link Layer
To study various protocols at Medium Access Control Layer
Course Outcomes:
After completion of the course, student will be able to
1. Explore network design issues- REMEMBER
2. Recognize the functions of OSI layers & TCP/IP protocol stack- UNDERSTAND
3. Describe the functionality of Logical Link layer- UNDERSTAND
4. Describe the functionality of Medium Access Control Layer- UNDERSTAND
40
Bansilal Ramnath Agarwal Charitable Trust’s
Vishwakarma Institute of Information Technology, Pune-48
(An Autonomous Institute affiliated to Savitribai Phule Pune University)
Text Books :
1 Fourauzan B., "Data Communications and Networking", 5th edition, McGraw-Hill
Publications
2 Stallings William., "Data and Computer Communications", Sixth Edition,
Prentice Hall of India .
3 Andrew S. Tanenbaum ,”Computer Networks”, Pearson
Reference Books :
1 CCNA Basics and Fundamentals-Cisco
2 CCNA Routing and Switching 200-125 Official Cert. Guide Library
3 Cisco CCNA Command Guide- An introductory Guide for complete beginners
41