Cse Sem I Sem Ii Sem Iii & Sem Iv
Cse Sem I Sem Ii Sem Iii & Sem Iv
(Deemed to be University)
Pune, India
(2021 Course)
VISION OF UNIVERSITY:
Social Transformation through Dynamic Education
MISSION OF UNIVERSITY:
To make available quality education in different areas of knowledge to the students as
per their choice and inclination.
To offer education to the students in a conducive ambience created by enriched
infrastructure and academic facilities in its campuses.
To bring education within the reach of rural, tribal and girl students by providing them
substantive fee concessions and subsidized hostel and mess facilities.
To make available quality education to the students of rural, tribal and other deprived
sections of the population.
Graduate Attributes/
a b c d e f g h i j k l
Programme Outcomes
Engineering Knowledge
Problem Analysis
Design/Development of
solutions
Conduct Investigations of
Complex Problems
Environment and
Sustainability
Ethics
Communication
Project management and
finance
Life-long learning
DEFINITION OF CREDITS:
Teaching
Sr. Scheme Examination Scheme (Marks) Credits
Course Name of Course (Hrs./Week)
No.
Code
L P T ESE IA TW OR PR Total L P T Total
Teaching
Scheme Examination Scheme (Marks) Credits
Sr. No. Name of Course (Hrs./Week)
Course
Code L P T ESE IA TW OR PR Total L P T Total
6 Vocational Course-I - 2 - - - 25 25 - 50 - 1 - 1
Social Activity – I - - - - - - - - - - - - 2
List of Vocational Courses will be published by the department before the commencement of respective semester.
Program: B.TECH. (Computer Science and Engineering) Semester – IV CBCS 2021 Course
7 Vocational Course-II - 2 - - - 25 25 - 50 - 1 - 1
MOOC - I# - - - - - - - - - - - - 2
# Add-on Course - List of MOOC and Vocational Courses will be published by the department before the commencement of respective
semester.
Program: B.TECH. (Computer Science and Engineering) Semester – V CBCS 2021 Course
Sr. No. Course Name of Course Teaching Examination Scheme (Marks) Credits
Code Scheme
(Hrs./Week)
L P T ESE IA TW OR PR Total L P T Total
1 Software Testing and Quality 3 2 - 60 40 25 25 - 150 3 1 - 4
Assurance
2 Big Data Analytics 4 - - 60 40 - - - 100 4 - - 4
7 Vocational Course-III - 2 - - - 25 25 - 50 - 1 - 1
Social Activity-II - - - - - - - - - - - - 2
Environmental Studies** 2 - - 50 - - - - - - - - -
Sr. No. Course Name of Course Teaching Examination Scheme (Marks) Credits
Code Scheme
(Hrs./Week)
L P T ESE IA TW OR PR Total L P T Total
1 Business Intelligence System* 3 2 - 60 40 25 - 25 150 3 1 - 4
7 Vocational Course-IV - 2 - - - 25 25 - 50 - 1 - 1
MOOC - II # - - - - - - - - - - - - 2
# Add-on Course - List of MOOC and Vocational Courses will be published by the department before the commencement of respective
semester.
Program: B.TECH. (Computer Science and Engineering) Semester – VII CBCS 2021 Course
Sr. No. Course Name of Course Teaching Examination Scheme (Marks) Credits
Code Scheme
(Hrs./Week)
L P T ESE IA TW OR PR Total L P T Total
1 Machine Learning 3 2 - 60 40 25 - 25 150 3 1 - 4
4 Elective I 3 2 - 60 40 25 25 - 150 3 1 - 4
7 Internship - - - - - 25 25 - 50 - 3 - 3
Sr. No. Course Name of Course Teaching Examination Scheme (Marks) Credits
Code Scheme
(Hrs./Week)
L P T ESE IA TW OR PR Total L P T Total
1 Data Visualization & Reporting 3 - 1 60 40 25 - - 125 3 - 1 4
# Add-on Course
Elective -II Pattern Recognition Industrial IOT Knowledge Management System Information Retrieval
B.TECH (Computer Science and Engineering)
SEMESTER – I
COURSE SYLLABUS
Mathematics for Computing-I
Course Objective:
Linear equations and its basis and dimension.
Linear mapping and its matrix representation.
Orthogonalization and diagonalisation of matrices
Prerequisite:
The students should have knowledge of algebra of matrices and determinants.
Course Outcomes: On completion of the course, students will have the ability to:
1. Apply rank of matrix in solving system of equations.
2. Identify basis and dimension of matrix.
3. Solve problems on kernel and image of linear transformation.
4. Apply linear operator to represent matrix.
5. Evaluate orthogonalization of inner product space.
6. Use methods to find eigen values and eigen vectors.
Unit I 06 Hours
System of Linear Equation: Vectors and linear combinations, Rank of a matrix,
Gaussian elimination, LU Decomposition, Solving Systems of Linear Equations using
the tools of Matrices.
Unit II 06Hours
Vector Spaces: Definition, linear combination, spanning sets subspaces, linear
dependence and independence, basis and dimension, rank of matrix.
Unit IV 06 Hours
Linear mapping and matrices: Matrix representation of linear operator, change of
base, similarity matrices.
Unit V 06 Hours
Inner Product space and orthogonalization: Inner product space,Cauchy-schwarz
equality,orthogonality, orthogonal sets and bases, projections,
Gramschidtorthogonalization, orthogonal and positive definite matrices, matrix
representation of inner product.
Unit VI 06Hours
Diagonalisation: Eigen values and eigenvectors: Characteristic polynomial, Cayley-
Hamilton theorem, eigen values and eigenvectors, properties.
Textbooks
1. P. N. Wartikar and J. N. Wartikar, Applied Mathematics (Volumes I and II), 7 th Ed., Pune
VidyarthiGrihaPrakashan, Pune, 2013
2. .B. S. Grewal, Higher Engineering Mathematics, 42nd Ed., Khanna Publication, Delhi
3. B.V. Ramana, Higher Engineering Mathematics, 6th Ed., Tata McGraw-Hill, New Delhi,
2008.
4. ErwinKreyszig, Advanced Engineering Mathematics, 10th Ed., John Wiley & Sons, Inc.,
2015.
Reference Books
1. Peter V. O'Neil, Advanced Engineering Mathematics, 7th Ed., Cengage Learning, 2012.
2. MichaelGreenberg,Advanced Engineering Mathematics, 2nd Ed., Pearson Education, 1998.
List of Assignments
Six assignments to be given by the course coordinator (Theory)-one from each unit
(Note:- *Students in a group of 3 to 4 shall complete any one project from the above list)
Prerequisite:
Basic knowledge about computers, web applications and internet.
Course Outcomes:On completion of the course, students will have the ability to:
1. Explain the fundamentals of programming languages.
2. Implement the Hyper Text Markup Language.
3. Use of Cascading Style Sheets in web page development.
4. Elucidate with implementation of Dynamic Hyper Text Markup Language.
5. Apply the knowledge to implement the Extensible Markup Language.
6. Implement the Hyper Text Transfer Protocol and DNS.
Unit I 08 Hours
Introduction to internet programming: Computer Network, working of internet, Web
applications, Introduction to web programming languages: HTML, DHTML, JSP, PHP, Role of
the Server on the internet, Introduction to JSP, Introduction about Node JS and angular JS
Unit II 08 Hours
Hyper Text Markup Language: Introduction to HTML, Tags, Div Span, Lists, Images,
Hyperlink, Table, Iframe, Form, Headers, all content with HTML5
Unit IV 08 Hours
Dynamic Hyper Text Markup Language: Introduction of DHTML- HTML vs. DHTML,
Advantages of DHTML, CSS of DHTML, Event Handling, Data Binding, Browser Object Models
Unit V 08 Hours
Extensible Markup Language: Introduction of XML- Features of XML, Anatomy of XML
document, The XML Declaration, Element Tags- Nesting and structure, XML text and text
formatting element, Table element, Mark-up Element and Attributes,
XML Objects, Checking Validity, Understanding XLinks, XPointer, Event-driven Programming,
XML Scripting, XML with Style Sheet Technologies- Concept of XSL, XML Schema, Importance
of XML schema, Creating Element in XML Schema, XML Schema Types.
Unit VI 08 Hours
Hyper Text Transfer Protocol and DNS: DNS, WWW, HTTP, HTTPs, XML HTTP Request-
Introduction, XMLHttpRequest, The XMLHttpRequest Object, Events for the XMLHttpRequest
Object, Request Object for XMLHttpRequest, Response Object for XMLHttpRequest, Complete
working of web browser
1.HTML & CSS: The Complete Reference, Fifth Edition Paperback byThomas Powell, McGraw
Hill Education.
2.HTML & XHTML: The Complete Reference, byThomas Powell,McGraw Hill Education,
McGraw-Hill Education.
3.XML: The Complete Reference, by Heather Williamson, McGraw Hill Education.
4.HTTP Pocket Reference (Pocket Reference (O'Reilly)), Clinton Wong, O′Reilly Publication.
5.HTML & XHTML: The Definitive Guide, 5th Edition, by Bill Kennedy and Chuck Musciano,
O’Reilly Publications.
List of Assignments:
(Course coordinator can design his/her own theory assignment. Following are samples of theory assignments.)
1. Explain the role of web programming languages in internet.
2. Explain any five HTML tags with example.
3. Consider any web-based example to explain the role of CSS in web programming.
4. Explain the role of DHTML in web programming and web applications.
(Note:- *Students in a group of 3 to 4 shall complete any one project from the above list)
Prerequisite:
Basic Chemistry
Course Outcomes: On completion of the course, students will have the ability to:
1. Differentiate between ionic and covalent bonding and classify the bonding in a compound as ionic or
covalent.
2. Develop a working knowledge of the twelve fundamental principles of green chemistry and what it is all
about.
3. Apply standard reduction potential data to determine the relative strength of oxidizing/reducing agents
4. Demonstrate the knowledge of polymer materials for futuristic engineering applications
5. Describe the properties of materials and Application of semiconductor electronics
6. Describe the manufacturing and refining process of fuels and lubricants
Unit I 06 Hours
Chemical Bonding in Molecules:MO theory, Structure, bonding and energy levels of bonding
and shapes of many atom molecules, Coordination Chemistry, Electronic spectra, and magnetic
properties of complexes with relevance to bio-inorganic chemistry, organometallic chemistry.
Unit II 06 Hours
Green Chemistry: Introduction, Twelve Principles of Green chemistry, numerical on atom
economy, synthesis, adipic acid and indigo. Organic dye- Traditional methods of organic dye.
Green solvents (ionic liquid supercritical CO2), and products from natural materials.
Unit IV 06 Hours
Polymers for The Electronics Industry: Polymers, Conduction mechanism, Preparation of
conductive polymers, Polyacetylene, Poly (p- phenlylene), Polyhetrocyclic systems, Polyaniline
Poly (Phenylene sulphide), Poly (1,6-heptadiyne), Applications, Photonic applications.
Unit V 06 Hours
Semi-Conductors, Insulators and Superconductors: Semi conductivity in non-elemental
materials, Preparations of semiconductors, Chalcogen photoconductors, photocopying process
Introduction to Superconductors, types of Superconductors, Properties of superconductors,
Applications of Superconductors, Electrical insulators, or Dielectrics.
Unit VI 06 Hours
Fuels & Lubricants: Classification of fuels, Calorific values, Comparison between solid, liquid,
and gaseous fuels, Theoretical calculation of calorific value of a fuel, Selection of coal, analysis
of coal, Natural Gas, Producer gas, water gas, Lubricants, Mechanism of lubrication, classification
of lubricants, lubricating oils, Solid lubricants, Greases or Semi-Solid lubricants, Synthetic
lubricants, Lubricating emulsions, Properties of lubricating oils.
Textbooks:
1. Polymer Science and technology (2nd Edition), P. Ghosh, Tata McGraw Hill, 2008.
2. Polymers: Chemistry & Physics of Modern Materials (2nd edition) J.M.G.Cowie, Blackie Academic &
Professional, 1994.
3. A Textbook of Engineering Chemistry, Shashi Chawla, DhanpatRai& Co, 2004
4. Engineering Chemistry (16th Edition) Jain, Jain, DhanpatRai Publishing Company, 2013.
Reference Books:
1. Inorganic Chemistry (4th edition), D. F. Shrives and P. W. Atkins, Oxford University, Oxford, 2006.
2. Reactions, Rearrangements and Reagents (4th edition), S. N. Sanyal, Bharti Bhawan (P & D), 2003.
3. Applications of Absorption Spectroscopy of Organic Compounds (4th edition), John R. Dyer, Prentice
Hall of India Pvt. Ltd., 1978.
List of Assignments:
Six assignments to be given by the course coordinator (Theory)-one from each unit/one mini project with report-
students can work in group of 4 Maximum
Note: -*Students in a group of 3 to 4 shall complete any one project from the above list)
Prerequisite:
Mathematics and Elementary Physics
Course Outcomes: On completion of the course, students will have the ability to:
1. Comprehend different number systems and Boolean algebraic principles.
2. Apply logic design minimization techniques to simplify Boolean expressions
3. Analyse and design combinational logic circuits.
4. Demonstrate the operations of systems with sequential circuit elements.
5. Comprehend characteristics and structure of Programmable Logic Devices and Memory.
6. Draw ASM charts for sequential circuit design.
Unit I 08 Hours
Digital systems: Number Systems: Introduction to Number Systems-Decimal, Binary, Octal,
Hexadecimal, Conversion of number system, Representation of Negative Numbers, 1’s complement
and 2’s complement.
Binary Arithmetic: Binary addition, Binary subtraction, Subtraction using 1’s complement and 2’s
complement, Binary multiplication, and division.
Digital Codes: BCD code, Excess-3 code, Gray code and ASCII code.
Logic Gates: Logical Operators, Logic Gates-Basic Gates, Universal Gates, realization of other gates
using universal gates.
Unit II 08 Hours
Logic Design Minimization: Boolean algebra, De Morgan’s Theorems, Standard representation of
logic functions, Sum of Product (SOP) form, Product of Sum (POS) form, Simplification of logical
functions, Minimization of SOP and POS forms using Karnaugh-Maps up to 4 variables Don’t care
condition, Quine-McCluskey Method.
Unit IV 08 Hours
Sequential Circuits: Flip- flop: SR, JK, D, T flip flops, Truth Tables and Excitation tables,
Conversion from one type to another type of Flip Flop.
Registers: Buffer register, Shift register.
Counters: Asynchronous counters, Synchronous counters, Modulus counters
Unit V 08 Hours
FSM and ASM charts: Introduction to FSM, Moore and Mealy State machine, state machine as a
sequential controller. Design of state machines: state table, state assignment, transition/excitation
table, excitation maps and equations, logic realization, ASM chart notations, ASM block, State
diagram, ASM chart for sequential circuits, Multiplexer Controller.
Unit VI 08 Hours
Memory and PLD:Semiconductor memories: memory organization, memory expansion,
Classification and characteristics of memories, RAM, ROM, EPROM, EEPROM, NVRAM, SRAM,
DRAM.
Programmable logic devices: Study of PROM, PAL, PLAs. Architecture of PLA, Designing
combinational circuits using PLDs.
Textbooks:
1. M. Morris Mano and M. D. Ciletti, Digital Design, Pearson Education.
2. RP Jain, Modern Digital Electronics, Tata McGraw Hill Publication.
3. F.J. Hill and G.L. Peterson, Switching Theory and Logic Design, John Wiley
4. J.F.Wakerly “Digital Design: Principles and Practices”, 3rd edition, 4th reprint, Pearson Education, 2
Reference Books:
1. David J. Comer, Digital Logic & State Machine Design, Oxford University Press.
2. Digital Integrated Electronics- H. Taub&D.Shilling, McGraw Hill.
List of Assignments:
Six assignments to be given by the course coordinator (Theory)-one from each unit
(Note:- *Students in a group of 3 to 4 shall complete any one project from the above list)
Prerequisite:
Basic knowledge of mathematics.
Course Outcomes: On completion of the course, students will have the ability to:
1. Describe the steps in problem-solvingand write a pseudocode for a given problem.
2. Identify the suitable control structure and write a C code for the same.
3. Write the C code for a given algorithm.
4. Illustrate use of pointers and functions
5. Write programs that perform operations using derived data types.
6. Validate the logic building and code formulation by designing code capable of passing various test cases
Unit I 08 Hours
Introduction to Computer Problem Solving: The problem solving Aspect, Top Down Design,
Implementation of Algorithms, Program Verification, The Efficiency of Algorithms, The Analysis
of Algorithms, Fundamental Algorithms:
General problem solving strategies: Introduction to program Planning tools- algorithm, flowcharts,
and pseudo codes. Introduction to Programming Logic.
Unit II 08 Hours
Control structures: Features of C, basic concepts, structure of C program, program, declarations,
variables, data types, expressions, operators assignment, arithmetic, relational, logical, increment and
decrement, precedence of operators, type conversions, scanf and printf functions if-else, nested if-
else, ladder if-else and switch statement. C Conditional control structures: for, while do-while
Unconditional control structures: break, continue, goto statement.
Unit IV 08 Hours
Functions and structures: What is a Function , Benefits of a Function , Function Terminology ,
Array of Structures, How does Function Works , Scope and Lifetime of Variables in function ,Storage
Classes of Variables , Call by value and call by reference ,Recursion ,Overview of Structures ,
Defining and Using a Structure , Structures within a Structure.
Unit V 08 Hours
Pointers: Declaring and Initializing Pointers, Function and Pointer Parameters, Pointer Arithmetic,
Pointer and Arrays, Two Dimensional Arrays and Pointers.
Unit VI 08 Hours
Files : FILE , Opening and Closing of Files , Writing and Reading in Text Format, Writing and
Reading in Binary Format, Command Line Arguments
Textbooks:
1. Let Us C by YashavantKanetkar, 13e, BPB Publication.
2. BrainW. Kernighan& Dennis Ritchie, C Programming Language, 2nd edition, PHI.
3. E.Balaguruswamy, Programming in ANSI C 5th Edition McGraw-Hill.
4. How to Solve it by Computer by R. G. Dromey, 1e, Pearson Education.
Reference Books:
1. C: The Complete Reference by Herbert Schildt.
List of Assignments:
1. Write a pseudocode and draw a flowchart for a given problem.
2. Justify the selection of appropriate control structure
3. Write a function to check whether the string is palindrome.
4. List and explain the working of standard string I/O functions.
5. Define a dynamic array to store the student record.
6. List and explain the different modes of opening file.
(Note:- *Students in a group of 3 to 4 shall complete any one project from the above list)
Prerequisite:
Basics of Mathematics at Secondary School Level
Course Outcomes: On completion of the course, students will have the ability to:
1. Understand dimensioning methods and drawing of engineering curves.
2. Draw orthographic projections using 1st angle method of projection.
3. Draw Isometric views from given orthographic projections.
4. Draw projection of Lines, its traces and projections of planes.
5. Draw projection of different solids.
6. Draw development of lateral surfaces of solids.
Unit I 04 Hours
Lines and Dimensioning in Engineering Drawing and Engineering
Curves:Different types of lines used in drawing practice, Dimensioning–linear,
angular, aligned system, unidirectional system, parallel dimensioning, chain
dimensioning, location dimension and size dimension.
Ellipse by Arcs of Circles method, Concentric circles method. Involutes of a circle,
Cycloid.
Introduction to Auto CAD commands.
Unit II 04 Hours
Orthographic Projections: Basic principles of orthographic projection (First and
Third angle method). Orthographic projection of objects by first angle projection
method only. Procedure for preparing scaled drawing, sectional views and types of
cutting planes and their representation, hatching of sections.(Using AutoCAD
commands)
Unit IV 04 Hours
Projections of Points & Lines: Projections of points, projections of lines, lines
inclined to one reference plane, Lines inclined to both reference planes. (Lines in First
Quadrant Only). (Using AutoCAD commands).
Unit V 04 Hours
Projections of Planes: Projections of Planes, Inclination of the plane with HP, VP.
(Using AutoCAD commands)
Unit VI 04 Hours
Projections of Solids: Projection of prism, pyramid, cone and cylinder by rotation
method. (Using AutoCAD commands)
Textbooks:
1. “Elementary Engineering Drawing”, N. D. Bhatt, Charotar Publishing house, Anand India,
2. “AutoCAD 2020 Beginning and Intermediate”, MunirHamad, Mercury Learning &
Information Publication, 2019.
3. “Engineering Drawing and Graphics”, Venugopal K., New Age International publishers.
Reference Books:
1. “Textbook on Engineering Drawing”, K. L. Narayana& P. Kannaiah, Scitech Publications,
Chennai.
2. “Fundamentals of Engineering Drawing”, Warren J. Luzzader, Prentice Hall of India, New
Delhi.
3. "Engineering Drawing", M. B. Shah and B.C. Rana,1st Ed, Pearson Education, 2005.
4. "Engineering Drawing", P. J. Shah, C. Jamnadasand Co., 1stEdition,1988.
5. "Engineering Drawing (Geometrical Drawing)", P. S. Gill, 10thEdition, S. K. Kataria and
Sons, 2005.
Prerequisite:
The students should have knowledge of vector algebra, derivative and integration.
Course Outcomes: On completion of the course, students will have the ability to:
1. Use periodic functions as Fourier series.
2. Apply methods of finding Fourier and Z-transforms.
3. Apply methods of Laplace transform of piecewise continuous functions.
4. Identify concepts of double and triple integrals.
5. Apply vector derivative for physical quantities.
6. Evaluate line, surface and volume integrals.
Unit I 06 Hours
Fourier Series: Definition, Dirichlet's conditions, Fourier Series and Half Range
Fourier Series, Harmonic Analysis
Unit II 06 Hours
Fourier and Z-Transform: Fourier Transform (FT): Complex Exponential Form of
Fourier series, Fourier Integral Theorem, Sine & Cosine Integrals, Fourier Transform,
Fourier Sine and Cosine Transform and their Inverses. Introductory
Z-Transform (ZT): Definition, Standard Properties, ZT of Standard Sequences and
their Inverses. Solution of Simple Difference Equations.
Unit IV 06 Hours
Multiple Integrals and their Application: Double and Triple integrations,
Applications to Area, Volume, Mean and Root Mean Square Values, moment of
inertia, centre of gravity
Unit V 06 Hours
Vector Differential Calculus: Physical interpretation of Vector differentiation, Vector
differential operator, Gradient, Divergence and Curl, Directional derivative,
Solenoidal, Irrotational and Conservative fields, Scalar potential, Vector identities.
Unit VI 06 Hours
Vector Integral Calculus and Applications: Line, Surface and Volume integrals,
Work-done, Green’s Lemma, Gauss’s Divergence theorem, Stoke’s theorem.
Applications to problem in engineering.
Textbooks:
1. P. N. Wartikar and J. N. Wartikar, Applied Mathematics (Volumes I and II), 7 th Ed., Pune
VidyarthiGrihaPrakashan, Pune, 2013.
2. B. S. Grewal, Higher Engineering Mathematics, 42nd Ed., Khanna Publication, Delhi
3. B.V. Ramana, Higher Engineering Mathematics, 6th Ed., Tata McGraw-Hill, New Delhi,
2008.
Reference Books:
1. Erwin Kreyszig, Advanced Engineering Mathematics, 10th Ed., John Wiley & Sons, Inc.,
2015.
2. Peter V. O'Neil, Advanced Engineering Mathematics, 7th Ed., Cengage Learning, 2012.
List of Assignments:
Six assignments to be given by the course coordinator one from each unit.
Note: -*Students in a group of 3 to 4 shall complete any one project from the above list.
Credits
Lecture: 4 Hours/Week End Semester Examination: 60 Marks Theory 4
Practical: 2 Hours/Week Internal Assessment: 40 Marks
Term Work : 25 Marks Practical 1
Practical: 25 Marks
Total: 150 Marks Total 5
Course Objectives:
Probability theory and expected value.
Probability distribution and its applications.
Multiple regression and ANOVA.
Course Outcomes: On completion of the course, students will have the ability to:
1. Apply Bayes theorem to find probability.
2. Compute mathematical expectations.
3. Identify various theoretical distributions.
4. Use correlation coefficient to interpret numerical data.
5. Use regression to estimate the dependent variable.
6. Apply concept of graph in optimization.
Unit I 08 Hours
Probability Theory: Definition of probability: classical, empirical, and axiomatic approach
of probability, Addition theorem of probability, Multiplication theorem of probability,
Bayes’ theorem of inverse probability, Properties of probabilities
Unit II 08 Hours
Random Variable and Mathematical Expectation. Definition of random variables,
Probability distributions, Probability mass function, Probability density function,
Mathematical expectation, Join and marginal probability distributions, Properties of
expectation and variance with proofs, Examples
Unit IV 08 Hours
Correlation: Introduction, Types of correlation, Correlation and causation, Methods of
studying correlation, Karl Pearson's correlation coefficient, Spearman’s rank correlation,
Coefficient, Properties of Karl Pearson's correlation coefficient, Properties of Spearman’s
rank correlation coefficient, Probable errors, Examples...
Unit V 08 Hours
Linear Regression Analysis: Introduction, Linear and non-linear regression, Lines of
regression, Derivation of regression lines of y on x and x on y, Angle between the regression
lines, Coefficients of regression, Theorems on regression coefficient, Properties of
regression coefficient
Unit VI 08 Hours
Multiple Regression and AVOVA: Multiple regression & multiple correlation, Analysis
of variance (one way, two way with as well as without interaction)
Textbooks
1.S. C. Gupta, "Fundamentals of Statistics", 46th Edition, Himalaya Publishing House.
2.G. V. Kumbhojkar, "Probability and Random Processes", 14th Edition, C. Jamnadas and company.
3.Murray Spiegel, John Schiller, R. ALU Srinivasan, Probability and Statistics, Schaum's Outlines
Kishor S. Trivedi, "Probability, Statistics with Reliability, Queuing and Computer Science
Applications", 2nd Edition, Wiley India Pvt. Ltd.
5.Vijay K. Rohatgi, A. K. Md. Ehsanes Saleh, An Introduction to Probability And Statistics, 3rd
Edition, Wiley Publication
6.I.R. Miller, J.E. Freund and R. Johnson. Fun “Probability and Statistics for Engineers” (4th E
dition)
Note: - *Students in a group of 3 to 4 shall complete any one project from the above list.
List of Laboratory Experiments (The course co-ordinator may frame 8-10 experiments)
Prerequisite:
Basic understanding of physics and calculus.
Course Outcomes: On completion of the course, students will have the ability to:
1. Interpret the properties of charged particles to develop modern instruments such as electron
microscopy.
2. Appraise the wave nature of light and apply it to measure stress, pressure, and dimension
etc.
3. Summarise the structure and properties of lasers to their performance and intended
applications.
4. Classify the optical fiber, understanding the structure, types, and its applications in the
field of communication.
5. Solve quantum physics problems to micro level phenomena and solid-state physics
6. Explain mechanical properties of solid matter and connect to applications in the field of
engineering.
Unit I 06 Hours
Modern Physics Motion of a charged particle in electric and magnetic fields,
Electrostatic and Magnetostatic focusing, Electron microscope, Wavelength and
resolution, Specimen limitation, Depth of field and focus, Transmission electron
microscope (TEM), Scanning electron microscope (SEM), Separation of isotopes by
Bainbridge mass spectrograph, Cathode ray tube (CRT).
Unit II 06 Hours
Wave Optics: Interference of waves, interference due to thin film (Uniform and
nonuniform (only formula-no derivation is expected), Newton’s ring, Applications of
interference (optical flatness, highly reflecting films, non-reflecting coatings).
Diffraction Introduction, Classes of diffraction, Diffraction at a single slit (Geometrical
method), Conditions for maximum and minimum, Plane diffraction grating,
Conditions for principal maxima and minima Polarisation, Introduction, Double
refraction and Huygen’s theory, Positive and negative crystals, Nicol prism,
Dichroism.
Unit IV 06 Hours
Fibre Optic: Principle of fibre optics, Construction, Numerical Aperture for step index
fibre; critical angle, angle of acceptance, V number, number of modes of propagation,
types of optical fibres, Fibre optic communication system, advantages, and
disadvantages of fibre optics.
Unit V 06 Hours
Quantum Mechanics: Dual nature of matter, DeBroglie’s hypothesis, Heisenberg’s
uncertainty principle with illustrations, Physical significance of wave function,
Schrodinger’s time dependant and time independent wave equation, Application of
Schrodinger’s time independent wave equation to the problems of Particle in a rigid
box, step potential and potential barrier (analytical discussion), tunnelling effect.
Unit VI 06 Hours
Solid state physics: Free electron theory, Density of states, Bloch theorem (Statement
only), Origin of band gap, Energy bands in solids, Effective mass of electron, Fermi-
Dirac probability function and position of Fermi level in intrinsic semi-conductors
(with derivation) and in extrinsic semi-conductors, Band structure of p-n junction
diode under forward and reverse biasing, Conductivity in conductor and semi-
conductor, Hall effect and Hall coefficient, Photovoltaic effect, Solar cell and its
characteristics.
Textbooks:
1. A Textbook of Engineering Physics, M N Avadhanulu, P G Kshirsagar and TVS Arun
Murthy, S. Chand Publishing (2018)
2. Engineering Physics, R K Gaur and S L Gupta, DhanpatRai Publishing Co Pvt Ltd (2015)
3. Concepts of Modern Physics, Arthur Beiser, Shobhit Mahajan and S. Rai Choudhury,
McGraw Hill Education (2017)
Reference Books:
1. Fundamentals of Physics, Jearl Walker, David Halliday and Robert Resnick, John Wiley and
Sons (2013
2. Optics, Francis Jenkins and Harvey White, Tata McGraw Hill (2017)
3. Principles of Physics, John W. Jewett, Cengage publishing (2013
4. Introduction to Solid State Physics, C. Kittel, Wiley and Sons (2004)
5. Principles of Solid State Physics, H. V. Keer, New Age International (1993)
6. Laser and Non-Linear Optics, B. B. Laud, New Age International Private Limited (2011)
7. Nanotechnology: Principles and Practices, Dr. S. K. Kulkarni, Capital Publishing Company
(2014)
8. Science of Engineering Materials- C.M. Srivastava and C. Srinivasan, New Age
International Pvt. Ltd. (1997)
9. Introduction to Electrodynamics –David R. Griffiths, Pearson (2013
10. Renewable Energy: Power for a Sustainable Future, Boyle, Oxford University Press (2012)
List of Assignments:
Six assignments to be given by the course coordinator (Theory)-one from each unit/one mini project
with report-students can work in group of 4 Maximum
Note: -*Students in a group of 3 to 4 shall complete any one project from the above list)
Prerequisite: NIL
-
Course Outcomes: On completion of the course, students will have the ability to:
1. Explain the various parameters related to magnetic circuit.
2. Describe basic concepts of AC fundamentals and circuits.
3. Illustrate constructional features and describe different parameters of transformer.
4. Describe basic concepts of power system and three phase circuits.
5. Demonstrate AC and DC electrical machines.
6. Classify types of batteries.
Unit I 08 Hours
Magnetic Circuits:Magnetic effect of electric current, Cross & DotConvention, Right
hand thumb rule, Concept of flux, flux linkages, magnetic field, magnetic field
strength, magnetic field intensity, absolute permeability, relative permeability
Kirchhoff’s laws for magnetic circuits. Magnetic circuit concepts, analogy between
electric& magnetic circuits, magnetic circuits with DC and AC excitations, magnetic
leakage, B-H curve, hysteresis and eddy current losses, magnetic circuit calculations,
mutual coupling.
Unit II 08 Hours
AC Fundamentals and circuits:AC Fundamentals:Sinusoidal, square and triangular
waveforms – average and effective values, form and peak factors, concept of phasor,
phasor representation of sinusoidally varying voltage and current. Analysis of series,
parallel and series-parallel RLC Circuits: apparent, active & reactive powers, power
factor, causes and problems of low power factor, power factor improvement; resonance
in series and parallel circuits, bandwidth and quality factor (simple numerical
problems.
Unit VI 08 Hours
Batteries:Basic idea of primary and secondary cells, Construction, working principle
and applications of Lead-Acid, Nickel Cadmium and Silver-Oxide batteries, charging
methods used for lead-acid battery (accumulator), Care and maintenance of lead-acid
battery, Series and parallel connections of batteries, General idea of solar cells, solar
panels and their applications, Introduction to maintenance free batteries, Safe disposal
of Batteries; Fuel cell: Principle & Types of fuel cell.
Textbooks:
1. B.L.Theraja, A Textbook of Electrical Technology, Vol.1, S.Chand& Company Ltd. New
Delhi
2. V.K.Mehta, Basic Electrical Engineering, S Chand & Company Ltd. New Delhi.
3. J.Nagarath and Kothari, Theroy and applications of Basic Electrical Engineering, Prentice
Hall of India Pvt. Ltd.
Reference Books:
1. Electrical Technology - Edward Huges (Pearson
2. Basic Electrical Engineering - D. P. Kothari, J Nagarath (TMC)
3. Electrical power system technology - S. W. Fordo, D. R. Patric (Prentice Hall)
4. Electrical, Electronics Measurements and Instruments - (SatyaPrakashan)
List of Assignments:
Six assignments to be given by the course coordinator (Theory)-one from each unit.
(Note:- *Students in a group of 3 to 4 shall complete any one project from the above list)
List of Laboratory Exercises:
1. Plotting B-H characteristics for a material.
2. Load test on single phase transformer.
3. Testing and maintenance of batteries.
4. Verification of voltage and current relationships in star and delta connected 3-phase
networks.
5. Load test on DC machine.
6. To find the performance of series R-L-C circuit at different condition
7. OS & SC test on single phase transformer to find efficiency and regulation
8. Speed control of DC motor
9. Study of different types of starters for DC & AC Machine
10. Load test on 3 phase Induction motor.
Course Outcomes: On completion of the course, students will have the ability to:
1. Use appropriate data structure to solve a particular problem
2. Demonstrate the use of linked list and compare it with array.
3. Demonstrate the use of stack as an ADT.
4. Perform the operations on queue.
5. Apply the searching and sorting algorithms
6. Demonstrate the use of Files and different File Organizations
Unit I 08 Hours
Introduction to Data structures: Introduction to algorithm, Algorithm analysis, Big
O Notations, Need of Data structure, Classification of Data Structures, Operations on
Data Structures. Arrays: Introduction, Array Operations, representation of Arrays in
Memory, One- & Two-dimensional array in function, Implementation of One- & Two-
Dimensional Arrays in Memory, Abstract Data Types.
Unit II 08 Hours
Linear Lists: Introduction, Singly linked list, Circularly Linked List, Doubly Linked
lists, Basic operations, - Insertion, Deletion, retrieval, traversal, create List, insert node,
delete node, List Search, Empty list, Destroy list, Applications of Linked List
Unit IV 08 Hours
Queue: Introduction, Definition, Storage Methods Queue Operations- Enqueue,
Dequeue, Queue front, Queue rear, Queue Example, Create Queue, priority Queue,
Circular Queue, Application of Queue: Categorising Data, Queue. Simulation, Array
and Linked representation of queue (operations on array and Linked representation.
Unit V 08 Hours
Implementation &Application: Searching: Linear Search, Binary Search, Hashing:
Introduction. Hash Tables, Hash Functions, Collision, Applications
Sorting – Selection Sort, Bubble Sort, Insertion Sort, Merge Quick Sort, Shell Sort
Unit VI 08 Hours
Files and Organization: Introduction, Data Hierarch, FileAttributes, Text and Binary
Files, Basic File Operations, File Organization, Sequential Organization, Relative File
Organization, Indexed Sequential File `Organization.
Textbooks:
1. Richard F Gilberg&Behrouz A Forouzan, Data Structures (A PseudocodeApproach with C),
second edition, Cengage Learning, 2004.
2. PAI, Data Structures, Tata McGraw-Hill Education, 2008
3. Data Structures Using C, ReemaThareja, OXFORD University Press
Reference Books:
1. Mayank Patel, Data Structure and Algorithm With C, Educreation Publishing, 2018
2. Thomas H. Cormen, Charles E Leiserson, Ronald L Rivest, Clifford Stein,
Introduction to Algorithms, MIT Press, 2001.
List of Assignments:
(Note:- *Students in a group of 3 to 4 shall complete any one project from the above list)
Course Objective:
Provide student a much-needed knowledge of computer hardware and networking, enabling them to
identify computer hardware, software and network related problems, and develop an ability to use
the basics of computing, necessary for computing courses
Prerequisite:
Basic knowledge of Computer and Electronics.
Course Outcomes: On completion of the course, students will have the ability to:
1. Identify the architecture of a computer and its different components, including their
technology evolution.
2. Apply their knowledge about computer peripherals to identify problems.
3. Install and uninstall given software step-by-step.
4. Learn the working of Internet.
5. Prepare document using Latex.
6. Learn GitHub tool for coding and collaboration.
Unit I 04 Hours
Computer hardware peripherals: Introduction to hardware components, random
access memory (ram), Types Of RAM & their speed, tips for buying ram, how to add
memory to a computer, problems when installing memory, Central Processing Unit
(CPU), Types Of CPU: considerations when buying a new CPU (Types &
Differences), different speeds available for CPU and what do they mean, 32 Bit vs 64
Bit – Which One To Choose &Why? How to choose a CPU type for different
needs? Graphic Card & Types, How to install a Graphics Card, Installing a CD or
DVD burner, Jumper Switch settings, Hard Disk upgrade, Different ports and why we
use them - USB, PS2, DivX, Graphic card & types, Virtual Memory and how to
configure it for optimum system performance.
Unit II 04 Hours
Assembly of Computer and Software Installations: Assembling the motherboard,
Replacing fan, how to avoid common mistakes during assembly, Installation of system
software: Operating system (Windows and Linux), Installations step for operating
system, Dual booting, Configure the BIOS, Installation of Antivirus, Installation of
the open source software such as Scilab, Latex Installation of Ms Office.
Unit IV 04 Hours
Computer network environments: Network connecting devices. Configure the
TCP/IP setting, connect to Local Area Network and access the Internet, Configuring
Wireless network. Server and Its Configuration, Email Clients, Browsers, Office tools,
customize web browsers with the LAN proxy settings, bookmarks, search toolbars and
pop-up blockers, Browsing netiquettes and cyber laws. Cloud Access Tools
Unit V 04 Hours
Configuration of External devices: Physical set-up of Printers- Performing test print
out, Printing of document etc, Scanner set-up, Webcam, Bluetooth device, Memory
card reader etc
Unit VI 04 Hours
Productivity tools: Open Source Tools Such as Latex, GitHubLaTeX: Format words,
lines, and paragraphs, design pages, create lists, tables, references, and figures in
LATEX. Introduction to LaTeX Packages and classes. Using Git, Version Control
Systems, interacting with GitHub, Reverting Changes, Creating Pull Requests.
Textbooks:
1. Introduction to Information Technology, ITL Education Solutions limited, Pearson
Education.
2. PC Hardware and A Handbook – Kate J. Chase PHI (Microsoft).
3. LaTeX Companion – Leslie Lampert, PHI/Pearson.
4. https://nptel.ac.in/courses/106/105/106105081/.
5. http://nptel.ac.in/courses/106105084/.
6. https://guides.github.com/.
7. Introduction to Linux: Installation and Programming B Venkateswarlu, BS Publication.
Reference Books:
1. IT Essentials PC Hardware and Software Companion Guide Third Edition by David
Anfinson and Ken Quamme. – CISCO Press, Pearson Education.
2. Computer Fundamentals, MS Office and Internet & Web Technology by Dinesh Maidasani.
(Note: -*Students in a group of 3 to 4 shall complete any one project from the above list)
Course Objective:
The objective of the course is to provide the students the knowledge of different Non-linear data
structures and how to use these to solve real world problems.
Prerequisite:
Basic Knowledge of Algorithm, programming fundamentals, Data types.ADT, Linear data
Structure.
Course Outcomes: On completion of the course, students will have the ability to:
1. Identify and Apply appropriate algorithms on the graph to solve real world problems.
2. Demonstrate the use of trees and binary search trees to solve the real world problem.
3. Compare the different types of trees like AVL trees, BTree,B+ Tree, red Black tree and select
an appropriate one to solve a particular one
4. Perform insertion and deletion operation on heap.
5. Apply appropriate hash function for a search process.
6. Explains the use of dictionaries and concept of text processing.
Unit I 06 Hours
Graphs: Introduction to Non-Linear data structure, Graphs, Representation of graph,
AND/OR Graphs, ADT for Graph, Traversing a Graph, Dijkstra’s Algorithm,
Minimum Spanning Trees.
Unit II 06 Hours
Trees: Introduction, Binary Trees, Binary Tree Representation, Tree Traversal
Algorithms, Threaded Binary Tree, Binary Search Tree, Operations on Binary Search
Tree, Huffman’s Algorithm.
Unit IV 06 Hours
Heaps:Heaps as priority queues, Heap Implementation, Insertion and Deletion
operations, binary heaps, binomial and Fibonacci heaps, heapsort, heaps in Huffman
coding.
Unit V 06 Hours
Hashing: Introduction, Hash functions, Collision Resolution Strategies,
Types of Hashing, Separate Chaining, Open Addressing, Linear Probing, Quadratic
Probing, Double Hashing, Rehashing, Extendible Hashing.
Unit VI 06 Hours
Dictionaries & Text Processing: Definition, Dictionary Abstract Data Type,
Implementation of Dictionaries, Text Processing: String -+Operations, Brute-Force
Pattern Matching, The Boyer-Moore Algorithm, The Knuth-Morris-Pratt Algorithm,
Standard tries, Suffix Tries, The Huffman Coding Algorithm.
Textbooks:
1. Mark Allen Weiss, Data Structures and Algorithm Analysis in C++, 2nd Edition, Pearson, 2004.
2. M T Goodrich, Roberto Tamassia, Algorithm Design, John Wiley, 2002.
3. Fundamentals of Data Structures in C by Horowitz, Sahni& Anderson-Freed, 2e
Universal Press
Reference Books:
1. T. H. Cormen, C. E. Leiserson, R. L. Rivest, and C. Stein, Introduction to Algorithms,
MIT Press, 3/e, 2009.
2.A. M. Tenenbaum, Y. Langsam, and M. J. Augenstein, Data Structures Using C and
C++,Prentice Hall, 3/e.
List of Assignments:
The following are some sample assignments. The course co-ordinator will frame one assignment on
each unit for internal assessment.
1. Apply the shortest path algorithm on the given graph.
2. Apply the appropriate algorithm and find the solution for the problem.
3. Generate Huffman code
4. Write a pseudocode for tree traversal operation
5. Explain the concept of linear probing
6. Explain the steps in text processing
(Note: -*Students in a group of 3 to 4 shall complete any one project from the above list)
Course Objective:
The objective is to provide a mathematical foundation and skills those are required in further study of Computer
Science and Engineering. The course Discrete Mathematical Structures deals with discrete objects, countable sets. It
helps to develop logical thinking and a wide variety of real-world applications to computer science. It is a very good
tool for improving reasoning and problem-solving capabilities.
Prerequisite:
Basic knowledge of Elementary Linear Algebra, Numerical Mathematical Computation, Programming basics.
Course Outcomes: On completion of the course, students will have the ability to:
1. Demonstrate the ability to write the sentences in the symbolic logic and evaluate a proof technique.
2. Apply the basic principles of set theory to analyse the data relationship and prove basic properties of set.
3. Analyse the properties of relations and functions to determine their properties.
4. Apply the knowledge of Boolean algebra for building basic electronic and digital circuits.
5. Solve problems of combinatorics and recurrence relations.
6. Model problems in Computer Science using graphs and trees.
Unit I 06 Hours
Mathematical Logic: Propositional Logic, Predicate logic, First order logic, Rules of
inference, Introduction to proof techniques, resolution, Mathematical induction, Methods of
proofs.
Unit II 06 Hours
Set Theory: Types of sets, Sets operations and laws, Algebra of Sets, Multisets, Application
of the principle of inclusion and exclusion.
Number Theory:Modular arithmetic, prime numbers, and properties, GCD, Chinese
remainder theorem, Extended Euclidean algorithm.
Unit IV 06 Hours
Algebraic Structures: Isomorphism and Homomorphism, Groups, Algebraic Structures
with Binary Operations, rings, Cyclicgroups, codes.
Lattice:Posets andHasse Diagrams, Lattice as an algebraic system, Properties of lattices.
Group Codes: The Communication Model and Basic notion of Error Correction, Generation
of Group codes, Parity Check, Error Recovery
Unit V
Combinatorics and Recurrence Relations: 06 Hours
Combinatorics: Permutations, Sumrule, Product rule, Combinatorial proofs.
Recurrence Relations: Linear Recurrence relation, Second order RR with constant
coefficients, Applications of Recurrence Relation.
Unit VI 06 Hours
Concepts of Graphs and Trees: Definition, Degree, Types, Operations on graphs, Paths,
Circuits, Connectedness, Planar graphs and their properties, Eulerian and Hamiltonian
graphs.
Trees: Basic properties of trees, Binary trees, Application: Minimum Spanning Tree, Shortest
Path.
Textbooks:
1. J.P. Tremblay and Manohar: Discrete mathematical structures with application to Computer Science,
McGraw hill- New Delhi.
2. Kolman and R.C. Busby: Discrete mathematical structures for computer science Prentice Hall, New-Delhi.
3. Malik and M. K. Sen: Discrete Mathematics, Cengage Learning India Pvt. Ltd.
4. R.M. Somasundaram: Discrete Mathematical Structures, Prentice Hall India Learning Private Limited.
5. C.L.Liu, Elements of Discrete Mathematics, second edition, McGraw-Hill Book Company.
Reference Books:
1. Kenneth H. Rosen: Discrete Mathematics and its applications Eighth Edition McGraw Hill Education.
2. Stanat and McAlister: Discrete Mathematics for Computer Science, PHI.
List of Assignments:
The following are some sample assignments. The course co-ordinator will frame one assignment on each unit for
internal assessment.
1. Given a fact or a statement prove or disprove using suitable technique.
2. Write the given English language sentences represent in the Symbolic logic.
3. Given the statement forms Infer the validity of the statement form.
4. Draw a Hasse diagram and find chains and antichains.
5. Find the number of ways for any event or given sample space.
6. Given a problem represent in a graph and compute the optimal solution.
7. Given a communication network find the path between the given nodes.
Course Objective:
The course would provide students with an understanding of the design of fundamental blocks used in organization
of computer system and interfacing techniques of these blocks to achieve different configurations of Machine
organization. Students will learn the basic operations of computing hardware and how it interfaces to software.
Prerequisite:
The students should have basic Knowledge Digital electronics and logic design.
Course Outcomes: On completion of the course, students will have the ability to:
1. Explain the architecture and functional blocks of Computer System.
2. List the functional requirements for implementing ALU.
3. Discuss design approaches implementing control unit.
4. Analyse the characteristics and hierarchy of memory system.
5. Describe Peripherals and Input-Output organization.
6. Describe the concepts of parallel processing and pipelining.
Unit I 08 Hours
CPU:-Machine architecture and organization, Von Neumann architecture Structure of IAS
machine, memory, input-output subsystems, control unit. Introduction to 80x86
microprocessor, Architecture, Register organization, Segmentation, Instruction execution
cycle, Addressing modes, and Instruction set. Instruction Formats, Instruction Types.
Unit II 08 Hours
ALU:-Computer arithmetic, Signed number representation, fixed and floating point
representations, character representation. Integer addition and subtraction, signed number
multiplication, Booth’s multiplierit's Hardware Implementation, Restoring and Non-
restoring Division techniques, floating point arithmetic, IEEE 754 format.
Unit IV 08 Hours
Memory:- Characteristics of Memory system, Memory hierarchy, Cache memory, cache
size and block size, mapping functions, replacement algorithms, cache coherency, Multilevel
Caches, Cache Coherence, Snooping & MESI Protocols, Memory Segmentation &
Interleaved Memory System.
Unit V 08 Hours
I/O organization: - I/O module, Peripheral devices and their characteristics, Input-output
subsystems, I/O device interface, I/O transfers, interrupt driven and DMA transfer, I/O
device interfaces – SCSI, USB, Fire wire.
Unit VI 08 Hours
Parallel Organization – Overview of Instruction Pipelining, Performance Improvement,
Flynn’s classification for Multiple Processor Organizations, Closely and Loosely Coupled
Multiprocessors Systems, Symmetric Multiprocessor (SMP) Organization, Multithreading –
Fine Grained, Coarse Grained & Simultaneous (SMT) Threading, Chip Multiprocessing,
Cluster Configuration, UMA, NUMA & CC-NUMA. Multicore Architectures – Hardware
& Software Issues in Multicore Organization.
Textbooks:
1. William Stallings. “Computer organization and architecture: designing for performance”. Pearson
Education India, 2010
2. Carl Hamacher, ZvonkoVranesic and SafwatZaky. “Computer Organization”, McGraw Hill, 2011.
3. Computer System Architecture M. M. Mano:, 3rd ed., Prentice Hall of India, New Delhi, 1993.
4. Computer Architecture and Organization, John P. Hayes.
Reference Books:
1. Computer Organization and Design: The Hardware/Software Interface, David A. Patterson and John L.
Hennessy.
2. David A. Patterson, John L. Hennessy. “Computer organization and design: the hardware/software interface”.
Elsevier, 2011
List of Assignments:
1. Describe the structure of IAS computer with neat block diagram.
2. Describe architecture of 8086 with neat block diagram.
3. Explain the concept of Segmentation and state its advantages and disadvantage.
4. Draw and explain working of Micro programmed Control Unit.
5. Describe structure of IAS computer with neat block diagram.
6. Describe architecture of 8086 with neat block diagram.
(Note: -*Students in a group of 3 to 4 shall complete any one project from the above list)
Prerequisite:
Programming paradigms, Basic mathematical ability
Course Outcomes: On completion of the course, students will have the ability to:
1. Outline the basic concepts of software engineering lifecycle.
2. Analyse and categorize the requirements of software systems.
3. Design the software qualitatively.
4. Implement the software with the standard guidelines.
5. Validate the software with standard testing techniques.
6. Demonstrate troubleshooting of software application.
Unit I 08 Hours
Introduction:
Software and Software Engineering: The Nature of Software, The Software Process,
Software Myths.
Process Models: A Generic Process Model, Prescriptive Process Models, Specialized
Process Models, The Unified Process.
Agile Development: Agility, Agility and the Cost of Change, Agile Process, Agile
Process Models.
Unit II 08 Hours
Requirement engineering and modelling:
Understanding Requirements: Requirements Engineering, Eliciting Requirements,
Building the use case, Building Analysis Model, negotiating requirements and
Validating Requirements. Drafting the software requirement specification.
Requirement Analysis and Modelling: Domain Analysis, Object Oriented Analysis,
Scenario based Modelling, Class Based Modelling, Behaviour Modelling. CASE
Tools.
Unit IV 08 Hours
Design
Design Concepts: The Design Process, Design Model - Data Design model,
Architecture Design model, Transform and Transaction Flow, Interface design Flow,
Component Level and Deployment level design elements.
Design Concepts – Abstraction, Architecture, Patterns, Modularity, Functional
Independence, Refinement, Refactoring, Object-Oriented Design Concepts. CASE
Tools in Software Design.
Unit V 08 Hours
Coding and Testing:
Coding Approach, Coding Standards, Error, Bug,Defects.
Software Testing Life Cycle, Software Testing Principles, Verification and Validation,
Types of Testing, White Box Testing techniques, Black Box Testing techniques,
Testing OO Applications, Website Testing. CASE Tool.
Unit VI 08 Hours
Implementation and maintenance: Software Maintenance-Software Supportability.
Reengineering-Business Process Reengineering- Software Reengineering- Reverse
Engineering, Restructuring.
Forward Engineering- Economics of Reengineering.
Textbooks:
1. Roger S, “Software Engineering – A Practitioner’s Approach”, seventh
edition, Pressman, 2010.
2. Pearson Edu, “Software Engineering by Ian sommerville”, 9th edition, 2010.
Reference Books:
1. Van Vliet, “Software Engineering: Principles and Practices”–, 2008.
2. Richard Fairley, “Software Engineering Concepts”, 2008..
List of Assignments:
1. Presentation on one topic related to this syllabus.
2. Conducting six Multiple choice question online test on each unit
3. Prepare a report based on the understanding by viewing the NPTEL videos of this
subject.
4. Perform the following Assignments:
i. Suggest Which SDLC model will be used to develop ATM software?
Justify?
ii. Develop Requirement Specification for ATM Software.
iii. Design the Class Diagram and Use case Diagram for ATM software.
iv. Discuss on Automated Software Testing. Create Test cases for
Functionality of ATM software using a Test Tool (Test Link).
v. Discuss and Prepare IEEE Quality Document for ATM software.
vi. vi. Prepare a Gantt chart using MS Project CASE Tool for a small Project.
(Note: -*Students in a group of 3 to 4 shall complete any one project from the above list)
List of Laboratory Exercises:
1. For the given system, students are required to identify and document the
RequirementsSpecifications.
2. To study and explore the working of any UML modelling CASE Tools.
3. For the given system, students are required to Model UML Use Case Diagrams and
Capture the Use Case Scenarios.
4. For the given system, students are required to create data models like ER and EER.
5. For the given system, students are required to Model UML State chart and Activity
diagrams.
6. For the given system, students are required to Model UML Class and sequence diagrams.
7. For the given system, students are required to Model UML collaboration, Component and
Deployment diagrams.
8. To study and explore the working of any Software Testing CASE Tools.
9. For the given system, students are required to design and execute the test suites.
10. Prepare a case study on Agile Methodologies.
Course Objective:
To teach fundamentals of object-oriented concepts and programming.
To apply the concepts of object-oriented paradigm.
To develop object-oriented programming skills.
To design and implement applications for real life problems by using object-oriented programming.
Prerequisite:
Paradigms of Programming.
Course Outcomes: On completion of the course, students will have the ability to:
1. Analyse the basics of object-oriented programming withJava.
2. Identify class, objects,methods for real time problems.
3. Make use of constructor,garbage collector and methods of string class.
4. Explore the concept of inheritance and polymorphism with the help of real time applications.
5. Handle exception with exception handling mechanism and understand the concept of multithreading.
6. Design the graphical user interface by using Applets AWT and SWING.
Unit I 08 Hours
Introduction: History and Features of Java, Difference between Java, C, C++, Internals of
Java Program, Difference between JDK, JRE and JVM, Internal Details of JVM,
Basics of Java Language-Variable and Reserve / Keywords present in Java, Primitive Data
types, Java Operators, Decision making and branching statements in Java.
Unit II 08 Hours
Classes, Objects and Methods: Creating a Class, Visibility/Access Modifiers,
Encapsulation, Methods: Adding a Method to Class, returning a Value, adding a Method
That Takes Parameters,’ this’ Keyword, Method Overloading, Object Creation, Using Object
as a Parameters, Returning Object, Array of Objects, Memory Allocation: ‘new’, Static Data
Members, Static Methods.
Unit IV 08 Hours
Inheritance and Polymorphism: Use of Inheritance, Types of Inheritance in Java, Role of
Constructors in inheritance, Polymorphism in OOP, Types of Polymorphism, static and
dynamic polymorphism, Overriding Super Class Methods. Use of “super” keyword.
Interfaces, Implementing interfaces.
Unit V 08 Hours
Exception Handling and Multithreaded programming:
Exception Handling: try and catch block, catch block, Nested try, finally block, throw
keyword, Exception Propagation, throws keyword, Exception Handling with Method
Overriding, Custom Exception
Introduction to threads, life cycle of a thread, thread states, threadproperties, methods in
Threads and Runnable, setting priority of threads,synchronization and inter thread
communication Life Cycle of a Thread.
Unit VI 08 Hours
Designing Graphical User Interfaces in Java: Applet and its use, Design Patterns using
Applet and JApplet. Run Applet application by browser and applet tool. Applet Architecture.
Parameters to Applet Life Cycle.
Basics of Components Using Containers, Layout Managers and User defined layout. Border
Layout, Flow Layout, Grid Layout, Grid bagLayout, Box Layout. AWT Components,
Adding a Menu to Window, Extending GUI Features Using SWING, Components Designing
GUI, Advanced swing components like Progress, JSlider, JRadioButton, JTree, JTable,
JToggleButton, etc.
Textbooks
1. E. Balaguruswamy, “Object Oriented Programming Using C++ and Java”, Tata McGrawHill
2. Steven Holzner et al. “Java 2 Programming”, Black Book, Dreamtech Press, 2009.
Reference Books
1. Java The complete reference, Herbert Schildt, McGraw Hill Education (India) Pvt. Ltd. 9th edition, 2014,
ISBN: 978-0-07-180856-9 (E-book).
2. Object-Oriented Design Using Java, Dale Skrien, McGraw-Hill Publishing, 2008, ISBN - 0077423097,
9780077423094.
3. MitsunoriOgihara, “Fundamentals of Java Programming”, Springer; 2018, ISBN 978-3-319-89490-4.
4. Brahma DathanSarnathRamnath, “Object-Oriented Analysis, Design and Implementation An Integrated
Approach”, Springer; 2nd ed. 2015, ISSN 1863-7310 ISSN 2197-1781 (electronic) Undergraduate Topics in
Computer Science ISBN 978-3-319-24278-1, ISBN 978-3-319-24280-4.
5. T. Budd (2009), An Introduction to Object Oriented Programming, 3rd edition, PearsonEducation, India.
6. J. Nino, F. A. Hosch (2002), An Introduction to programming and OO design using Java, John Wiley & sons,
New Jersey.
7. Y. Daniel Liang (2010), Introduction to Java programming, 7th edition, Pearson education, India.
List of Assignments:
(Note:- *Students in a group of 3 to 4 shall complete any one project from the above list)
Prerequisite:
Discrete Mathematics
Course Outcomes: On completion of the course, students will have the ability to:
1. Estimate the importance of automata theory in designing computer languages.
2. Demonstrate and understand the relationships between language classes and regular
expression
3. Design grammars and recognizers for different formal languages
4. Identify the equivalence of languages described by pushdown automata
5. Evaluate the Language Acceptability by Turing Machine
6. Explain the basics of compiler
Unit I 06 Hours
Preliminaries and Finite state machines: Introduction to Theory of Computation-
Automata, Alphabet, Symbol, String, Formal Languages, Deterministic Finite
Automaton (DFA)- Definition, Representation, Acceptability of a String and
Language, Non Deterministic Finite Automaton (NFA), Equivalence of DFA and
NFA, NFA with ε-Transition, Equivalence of NFA’s with and without ε-Transition,
Finite Automata with output- Moore machine, Mealy Machine, Equivalence of Moore
and Mealy Machine, Minimization of Finite Automata.
Unit II 06 Hours
Regular Languages -Definition and Examples. Conversion of RE To FA, FA to RE,
algebraic laws, applications of RE. Pumping lemma for regular languages and
applications. Closure properties of regular Languages Union, Concatenation,
Complement, Intersection and Kleene closure. Decidability- Decision properties.
Unit IV 06 Hours
Push Down Automata (PDA): Introduction, Pushdown Automata (PDA), Transition
Diagrams, Functions and Tables, Deterministic Push- down Automata (DPDA) -
definition, Nondeterministic Pushdown Automata (NPDA), Equivalence of context
free grammars and PDA, properties of context free languages. Introduction to Post
Machines (PMs).
Unit V 06 Hours
Turing Machines: The Turing Machine Model and Definition of TM, Language
Acceptability of Turing Machines, Techniques for Turing Machine Construction,
Modifications of Turing Machine, Composite and Iterative Turing machines ,Multi
Tape Turing machine ,Multi Stack and Multi Track Turing machine ,Universal Turing
machine, Linear Bounded Automata, Church’s Thesis, Halting Problem.
Unit VI 06 Hours
Applications: Applications of Regular expressions, Lexical analyser, Text editor, and
searching using RE, Context free grammar, Basics of parsing techniques, application
of leftmost and rightmost derivations during parsing, Primitive recursive functions,
Recursive and recursively enumerable languages, Introduction to Natural language
Processing.
Textbooks:
1. Vivek Kulkarni “Theory Computation” Oxford higher education
2. Theory of Computer Science (Automata, Language & Computation) K. L. P. Mishra & N.
Chandrasekaran, PHI Second Edition.
3. E.V. Krishnamurthy, “Theory of Computer Science”, EWP Publication.
Reference Books:
1. Hopcroft Ullman, “Introduction to Automata Theory, Languages &Computations, Narosa.
2. Daniel A. Cohen, “Introduction to Computer Theory”, Wiley Publication.
3. Automata Theory, Languages, and Computation, John E. Hopcroft Cornell University,
Rajeev Motwani Stanford University, Jeffrey D. Ullman Stanford University,3rd Edition.
List of Assignments:
1. Study of JFLAP tool for Constructing FA.
2. Construct regular expressions defined over the alphabet Σ= {a, b}, which denote the
given languages.
3. Translate the following Mealy machine into its equivalent Moore machine.
4. Write a context-free grammar (CFG) which generates the language L denoted by:(a+
b)*bbb(a+ b)*.
5. Construct a PDA that accepts the language defined by the following regular grammar.
6. Design a TM to recognize an arbitrary string divisible by 4, from Σ= {0, 1, 2}.
Course Objectives:
To help the students understand functioning of various system programs and Compiler,
Loaders and Linkers.
To help students for different concepts of operating system and management with file
system.
Prerequisite:
Knowledge of Microprocessor concepts and Assembly language and Concept of system software,
application software, knowledge of input output devices and its usage.
Course Outcomes: On completion of the course, students will have the ability to:
1. Apply fundamental concepts and practical skills of system programming.
2. Design and Demonstrate working of assemblers, Loaders and Linkers.
3. Compare and evaluate different scheduling algorithms.
4. Outline the concept of concurrency and deadlocks.
5. Analyse of Memory Management and Virtual Memory.
6. Prepare a comparison report of different operating system.
Unit I 08 Hours
Introduction to Systems Programming:Introduction: Components of System
Software, Language Processing Activities, Fundamentals of Language Processing.
Assemblers: Elements of Assembly language programming. Simple assembler scheme,
Structure of an assembler, Design of single and two pass assembler. Macro Processors:
Macro Definition and call, Macro expansion, Nested Macro Calls, Advanced Macro
Facilities, Design of a two-pass macro-processor, Case study related to unit contents.
Unit II 08 Hours
Compiler, Loaders and Linkers:Compilers: Basic compilers function, Phases of
compilation, memory allocation, compilation of expression, Compilation of
expressions, compilation of control structures, Code of optimization.
Loaders: Loader Schemes: Compile and go, General Loader Scheme, Absolute loaders,
subroutine linkages, relocating loaders, direct linking loaders, Design of an absolute
loader. Linkers: Relocation and linking concepts, Design of linker, self-relocating
programs, Static and dynamic linker, Case study related to unit contents.
Unit IV 08 Hours
Concurrency control:Concurrency: Interprocess communication, Mutual Exclusion,
Semaphores, Classical Problems of Synchronization: Readers-Writers, Producer
Consumer, and Dining Philosopher problem. Deadlock: Principles of deadlock,
Deadlock Prevention, Deadlock Avoidance, Deadlock Detection, Case study related to
unit contents.
Unit V 08 Hours
Memory Management: Basics of memory management, Swapping, Memory
Allocation, Paging, Segmentation,Virtual memory, Demand Paging, Page
replacement, Page replacement algorithms – Optimal FIFO, LRU, LRU
approximation, Allocation of frames, Case study related to unit contents.
Unit VI 08 Hours
Input and Output, File System: I/O management & Disk scheduling: I/O Devices,
Organization of I/O functions, Operating System Design issues, I/O Buffering, Disk
Scheduling (FCFS), RAID, Disk Cache. File Management: Concepts, File
Organization, File Directories, File Sharing, Record Blocking, Allocation methods,
Free Space management, Case study related to unit contents.
Textbooks:
1. System Programming by John J. Donovan, TATA McGRAW-HILL Edition.
Reference Books:
1. Operating System Concepts, 9th edition Peter B. Galvin, Greg Gagne, Abraham
Silberschatz, John Wiley & Sons, Inc.
2. Operating Systems 5th Edition, William Stallings, Pearson Education India.
3. D. M. Dhamdere : “Systems programming and operating system”, Tata McGraw
Hill.
List of Assignments:
1. Describe the types of errors that can be identified in the process of language
translation. Illustrate the same with example
2. Explain the different types of optimization techniques
3. Compute average waiting time and average response time for the given set of
processes.
4. Apply page replacement algorithm and compute the number of page faults.
5. Case study 1
6. Case study 2
Note:-*Students in a group of 3 to 4 shall complete any one project from the above list.
List of Laboratory Exercises:
1. Design one pass assembler
2. Design two pass assembler
3. Write a program to create Dynamic Link Library for any mathematical operation and write
an application program to test it
4. 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.
5. Implement UNIX system calls like ps, fork, join, exec family, and wait for process
management.
6. Implementation of various scheduling algorithm.
7. Implementation of Banker’s algorithm.
8. Find out the page fault of any given string.
9. Implementation of various Page replacement Algorithm.
10. Study assignment on process scheduling algorithms for latest OS.
Total 03
Course Objectives:
To introduce the principles of computer graphics and the components of a graphics system.
To introduce basic algorithms for drawing line, circle and curves.
To develop understanding of the basic principles of 2D and 3D computer graphics and how
to transform the shapes to fit them as per the picture definition.
To introduce multimedia architecture and hardware.
To introduce multimedia file formats.
Prerequisite:
Knowledge of C programming language, Linear Algebra.
Course Outcomes: On completion of the course, students will have the ability to:
1. Apply fundamental concepts and practical skills in computer graphics.
2. Design and apply two-dimensional graphics.
3. Implement and use classic and modern algorithms and data structures in computer graphic
to 3-D geometry.
4. Apply Illumination and colour models.
5. Identify suitable file format to develop a multimedia application.
6. Design Basic 3- D Scenes using Blender.
Unit I 08 Hours
Introduction to computer graphics and devices:Introduction to computer graphics,
Graphics Primitives: Raster scan & random scan displays, display processor, display
file structure, Output primitives, points and lines, line drawing algorithms, loading the
frame buffer, line function; circle and ellipse generating algorithms; Pixel addressing
and object geometry, filled area primitives. GRAPHIC DEVICES Cathode Ray Tube,
Quality of Phosphors, CRTs for Colour Display, Beam Penetration CRT, The Shadow
-Mask CRT, Direct View Storage Tube, Tablets, The light Pen, Three Dimensional
Devices.
Unit II 08 Hours
Two-dimensional graphics: Two dimensional geometric transformations — Matrix
representations and homogeneous coordinates, composite transformations; Two-
dimensional viewing — viewing pipeline, viewing coordinate reference frame;
window-to-viewport coordinate transformation, Two dimensional viewing functions;
clipping operations — point, line, and polygon clipping algorithms.
Unit IV 08 Hours
Illumination and colour models: Light sources, basic illumination models, halftone
patterns and dithering techniques; Properties of light, Diffused illumination, point
source illumination, Standard primaries and chromaticity diagram; Intuitive colour
concepts, RGB colour model, YIQ colour model, CMY colour model ,HSV colour
model; Colour selection, ray tracing.
Unit V 08 Hours
Multimedia system design & multimedia file handling:Multimedia basics –
Multimedia applications – Multimedia system architecture – Evolving technologies for
multimedia – Defining objects for multimedia systems – Multimedia data interface
standards – Multimedia databases. Compression and decompression – Data and file
format standards – Multimedia I/O technologies – Digital voice and audio – Video
image and animation – Full motion video – Storage and retrieval technologies.
Unit VI 08 Hours
Hypermedia: Multimedia authoring and user interface-Hypermedia messaging -
Mobile messaging – Hypermedia message component – Creating hypermedia message
– Integrated multimedia message standards– Integrated document management –
Distributed multimedia systems. CASE STUDY: BLENDER GRAPHICS Blender
Fundamentals—Drawing Basic Shapes— Modelling—Shading & Textures.
Textbooks
1. Donald Hearn and Pauline Baker M, Computer Graphics”, Prentice Hall, New Delhi, second
edition.
2. Andleigh, P. K and KiranThakrar, Multimedia Systems and Design, PHI, 2015.
Reference Books
1. Foley, Vandam, Feiner and Hughes, Computer Graphics: Principles and Practice, 2nd
Edition, Pearson Education, 2003.
2. Peter Shirley, Michael Ashikhmin, Michael Gleicher, Stephen R Marschner, Erik Reinhard,
KelvinSung, and AK Peters, Fundamentals of Computer Graphics, CRC Press, 2010.
List of Assignments:
1. Study on any latest data generating device in computer Graphics .
2. Describe in detail any one color model process.
3. Using the determinant to calculate the signed areas, determine whether the point p=[23]T is
in the triangle formed by the points s=[22]T, t=[51]T and r=[35]T. Show all of your work.
4. Elaborate in detail the any one curve generation methods.
5. Describe how Multimedia system architecture process is used in real time.
Project Based Learning
1. Helicopter game
2. Sinking Ship
3. Scientific calculator
4. Traditional wall Clock
5. Tower of Hanoi game
6. Windmill
7. Steam engine
8. Traffic signal
9. Aquarium
10. Prepare a PowerPoint Presentation
11. Mobile app for online shopping
12. Arrival and departure of the train with announcement and signal
13. Mobile application for online tour guidance app
14. Create a small video on the given topic
15. Story tell mobile app
(Note: -*Students in a group of 3 to 4 shall complete any one project from the above list)
List of Laboratory Exercises:
1. Study of Fundamental Graphics Functions.
2. Implementation of Line drawing algorithms: DDA Algorithm, Bresenham's
Algorithm.
3. Implementation of Circle drawing algorithms: Bresenham's Algorithm, Mid-Point
Algorithm.
4. Programs on 2D and 3D transformations.
5. Write a program to implement Cohen Sutherland line clipping algorithm.
6. Using Flash/Maya perform different operations (rotation, scaling move etc..) on
objects Create a Bouncing Ball using Key frame animation and Path animation.
7. Write a program to make wave audio file.
8. Write a program to create links in HTML.
9. Write a program to create file split.
Course Objective:
The Course gives an overview of about the Performance and Analysis of Algorithms.
Prerequisite:
The students should possess the knowledge of Data Structures and Discrete Mathematics.
Course Outcomes: On completion of the course, students will have the ability to:
1. Analyze the asymptotic performance of algorithms by providing Optimal Solution.
2. Synthesize divide-and-conquer algorithms. Derive and solve recurrences describing the
performance of divide-and-conquer algorithms.
3. Analyze the performance of Greedy Methods and describe its limitations.
4. Analyse Dynamic Programming Problems.
5. Solve Problems using Backtracking Approach.
6. Compare NP-Hard, NP-Complete Problems and Online Algorithms.
Unit I 06 Hours
Models of Computation:Algorithm Specification, Pseudocode Conventions Recursive
Algorithms, PERFORMANCE ANALYSIS, Space Complexity Time Complexity
Asymptotic Notation, Practical Complexities, Performance Measurement Randomized
AlgorithmsIterative Algorithms: Measures of Progress and Loop Invariants. Steps to develop
Iterative Algorithms.
Unit II 06 Hours
Divide-and-Conquer:Binary Search Finding the Maximum and Minimum, Merge Sort,
Quick Sort, Performance Measurement: Best Case and Worst-Case Analysis. Strassen's
matrix Multiplication.
Unit IV 06 Hours
Dynamic Programming:Multistage graph, All Pairs Shortest paths, Single-Source Shortest
Path, Optimal Binary search trees, 0/1-knapsack, The Traveling Salesperson Problem, Basic
Traversal and Search Technique.
Unit V 06 Hours
Backtracking:Backtracking: The General Method, The 8- Queens Problem, Sum of Subsets,
Graph Colouring, and Hamiltonian Cycles. Branch and Bound: Least Cost (LC) Search, The
15-puzzle Control abstraction of LC Search, Bounding, FIFO Branch and Bound, LC Branch
and Bound.
Unit VI 06 Hours
Files:NP-HARD AND NP-COMPLETE PROBLEMAlgorithm Complexities:
Nondeterministic Algorithms, The classes NP-Hard and NP- Complete, Cook's Theorem, NP-
Hard Graph Problems, NP-Hard Scheduling Problems, NP-Hard Code Generation Problems.
Approximation Problems.Online Algorithms: The Online Paging Problem, Adversary
Models, Paging against an Oblivious Adversary, Relating the Adversaries, The Adaptive
Online Adversary, The k-Server Problem
.
Textbooks:
1. Alfred Aho, John E. Hopcroft, “Design and Analysis of Computer Algorithms”, Pearson
Education.
2. Thomas Cormen, Charles E Leiserson, Ronald Rivest, “Introduction to Algorithms, Tata Mc-Graw
Hill Publication, Second Edition.
3. Rod Stephens, “Essential Algorithms: A Practical Approach to Computer Algorithms”, John Wiley
and Sons Publications.
4. Jon Kleinberg, Eva Tardos, “ Algorithm Design”, Pearson Education.
5. Robert Sedgewick, Philippe Flajolet, “An Introduction to the Analysis of Algorithms”, Adison-
Wesley Publication, Second Edition.
6. Jeff Edmonds, How to think about Algorithms, York University, Cambridge University Press.
7. Python Algorithms: Mastering Basic Algorithms in the Python Language, by Magnus Lie,
Hetland ,APress.
8. Ian Parberry and William Gasarch, WProblems on Algorithms, Second Edition, Prentice Hall Inc.
9. Rajeev Motwani, PrabhakarRaghavan, Randomized Algorithms, Cambridge University Press.
Reference Books:
1. ElitzHorowith and SartajSahani, S. Rajasekaran, “Fundamentals of Computer Algorithms”,
Galgotia Publications.
List of Assignments:
1. Calculate the space complexity of various algorithms.
2. Implement Knapsack Algorithm.
3. Implement Prim's Algorithm
4. Implement Kruskal’s Algorithms
5. Study and analysis of 8-Queens Problem.
6. Implement Optimal Binary Search Tree.
(Note: -*Students in a group of 3 to 4 shall complete any one project from the above list)
Course Objective:
This course focuses on the core principles and techniques required in the design and implementation of
database systems.
Prerequisite:
Discrete mathematics, Data structures and Programming languages.
Course Outcomes: On completion of the course, students will have the ability to:
1. Use the basic concepts of Database Systems in Database design.
2. Design a Database using ER Modelling
3. Apply SQL queries to interact with Database.
4. Apply normalization on database design to eliminate anomalies.
5. Analyse database transactions and can control them by applying ACID properties.
6. Investigate the knowledge about emerging trends in the area of database for unstructured data
and applications for it.
08 Hours
Unit I
Introduction to Databases and Database Design:Introduction, purpose of database
system, Data Independence, view of data, Database System architecture- Levels, Mappings,
Database users and DBA, applications of DBMS,The importance of data models, Basic
building blocks, Business rules, The evolution of data models, Degrees of data abstraction.,
Database Design Process, ER Diagrams - Entities, Attributes, Relationships, Constraints,
keys, extended ER features, Generalization, Specialization, Aggregation, Conceptual design
with the E-Rmodel.
Unit II 08 Hours
Relational Model:Introduction to the relational model, Integrity constraints over relations,
enforcing integrity constraints, querying relational data, Logical database design: E-R to
relational, Introduction to views, Destroying/altering tables and views.
Relational Algebra and Calculus: Preliminaries, relational algebra operators, relational
calculus - Tuple and domain relational calculus, expressive power of algebra and calculus.
Unit IV 08 Hours
SQL:Basics of SQL, DDL, DML,DCL, structure – creation, alteration, defining constraints
– Primary key, foreign key, unique, not null, check, IN operator, Functions - aggregate
functions, Built-in functions – numeric, date, string functions, set operations, sub-queries,
correlated sub-queries, Use of group by, having, order by, join and its types, Exist, Any,
All, view and its types. transaction control commands – Commit, Rollback, Save point,
cursors, stored procedures, Triggers.
Unit V 08 Hours
Transactions Management:Transaction concept, transaction state, implementation of
atomicity and durability, concurrent executions, Serializability, recoverability,
implementation of isolation, transaction definition in SQL, testing for Serializability.
Concurrency Control and Recovery System: Concurrency control, lock based protocols,
time-stamp based protocols, validation based protocols, multiple granularity. Recovery
system - failure classification, storage structure, recovery and atomicity, log- based
recovery, shadow paging, buffer management, failure with loss of non-volatile storage,
advanced recovery techniques, remote backup systems.
Unit VI 08 Hours
Emerging Database Technologies:Introduction to unstructured data, NOSQL,
Introduction to unstructured data, NOSQL, spatial and geographic databases,
Database Analysis Tools multimedia databases, Massive Datasets and Hadoop.
Textbooks:
1. Raghurama Krishnan, Johannes Gehrke , Database Management Systems, 3rd edition, Tata
McGraw Hill, New Delhi,India.
2. ElmasriNavate, Fundamentals of Database Systems, Pearson Education,India.
Reference Books:
1. Abraham Silberschatz, Henry F. Korth, S. Sudarshan (2005), Database System Concepts, 5th
edition, McGraw-Hill, New Delhi,India.
2. Peter Rob, Carlos Coronel (2009), Database Systems Design, Implementation and Management,
7thedition.
List of Assignments:
1. Define Database. Explain Importance of Data Models in detail
2. Write a short note on Following:
a) Relational Algebra and Calculus
b) Integrity Constraints
3. Define Normalization. Explain all Normal forms in detail
4. Explain DDL, DML and DCL in detail.
5.Explain ACID properties of TCL in detail.\
6. Explain NOSQL and Database Analysis Tools in detail.
Prerequisite:
1. Create PHP programs that use various php library functions,
2. Design interactive forms using PHP.
3. Implement various operations on arrays and control structures in PHP
4. Create database and demonstrate the manipulation of Files, Directories and relational data.
5. Implement cookies and session
6. Develop dynamic web Content.
Unit I 08 Hours
Introduction to Dynamic Web Content &Environment: Overview of HTTP & HTML,
Request/Response Procedure, Advantage of PHP, MySQL, JavaScript, CSS & HTML 5,
The Apache Web Server, Overview of Open Source. Basics of WAMP, MAMP,LAMP,
Installation, Accessing document root, Working Remotely – Looking In, Using FTP, Using
IDE.
Unit II 08 Hours
Introduction to PHP, Expression & Control Flow: Incorporating PHP within HTML,
Structure of PHP – Comments, Basic Syntax, variables, operators, Assignments, multiline
commands, constants, echo & print commands, Functions, variable Scope. Expressions:
TRUE or FALSE, Literals & Variables. Operators: Precedence, Associativity, Relational
Operators. Conditionals – if, else, elseif, switch operator. Looping: While, do-while,
breaking out of loop, continue statement
Unit IV 08 Hours
PHP in Action & Introduction to MySQL:UsingPrintf, Date and Time Functions, File
handling, System Calls.Introduction to MySQL: Basics, Database Terms, Accessing
MySQL via Command line, MySQL Commands, Data types, Indexes, MySql Functions,
Accessing Mysql via PhpMyAdmin, Primary Keys, Relationships, Select Queries,
creatingmysqldump, backup file, dumping data in CSV format.
Unit V 08 Hours
Cookies, Sessions, Authentications and Accessing: Using cookies in PHP, HTTP
Authentication, Using Sessions. Accessing: Querying a MySQL Database with PHP – The
Process, create login file, connecting to database, Practical Example, Preventing Hacking
Attempts: Using Placeholders, HTML Injection. Building Forms, Retrieving submitted
Data.
Unit VI 08 Hours
Exploring JavaScript:JavaScript and HTML Text – using within a Document Head, Older
& Nonstandard Browsers, Including Javascripts, debugging Javascript errors, using
variables, semicolon, variables, operators, variable typing, functions, global variables, local
variables, Document Object Model, Document.write.
Textbooks:
1. Learning PHP, MySQL &Javascript, Robin Nixon, OREILLY, 4thEditon, 2015.
2. Head First PHP & MySQL-Lynn Beighley& Michael Morrison-O’Reilly.
3. PHP: A Beginner’s Guide-VikramVaswani- McGraw-Hill Education.
Reference Books:
1. The Complete Reference PHP – Steven Holzner, Tata McGraw-Hill.
2. The Joy of PHP Programming: A Beginner’s Guide – Alan Forbes, BeakCheck LLC,6th edition.
Note: -*Students in a group of 3 to 4 shall complete any one project from the above list.