BCA - Syllabus - 2023
BCA - Syllabus - 2023
JOSEPH’S UNIVERSITY
BENGALURU-27
The Bachelor of Computer Application (BCA (Hons)) program enables students to attain
following additional attributes besides the afore-mentioned attributes, by the time of
graduation:
1. Apply standard Software Engineering practices and strategies in real -time software
project development
2. Design and develop computer programs/computer -based systems in the areas
related to AI, algorithms, networking, web design, cloud computing, IoT and data
analytics.
3. Acquaint with the contemporary trends in industrial/research settings and thereby
innovate novel solutions to existing problems
4. The ability to apply the knowledge and understanding to the analysis of a given
information handling problem.
5. The ability to work independently on a substantial software project and as an effective
team member.
DEPARTMENT OF COMPUTER SCIENCE AND COMPUTER APPLICATIONS(UG)
(2021-2024)
Semester 1 Code Title No. of Number of Number Continuous End Total
Number Hours Hours of of Internal Semester marks
of teaching credits Assessment Marks
Instruct perweek (CIA)
ions Marks
Theory CA1121 Fundamentals of 42 03 03 40 60 100
Computers
Theory CA1221 Programming in C 42 03 03 40 60 100
Total Number of credits:13+ 13( Total Credit of OE, Languages, CAE, Voc, AECC, SEC)
Total Number of credits:13+13( Total Credit of OE, Languages, CAE, VoC, AECC, SEC)
Semester 3 Code Title No. of Number Number of Continuous End Semester Total
Number Hours of of credits Internal Marks marks
Instructio teaching Assessment
ns hrs /week (CIA)
Marks
Theory 42 03 03 40 60 100
CA3122 Data Base
Management
Systems
Theory 42 03 03 40 60 100
CA3222 C# and DOT NET
Framework
Theory 42 03 03 40 60 100
CA3322 Computer
Communication
and Networks
Practical 52 04 2 25 25 50
CA3P1 DBMS Lab
Practical 52 04 2 25 25 50
CA3P2 C# and DOT NET
Framework Lab
Total Number of credits:13+13( Total Credit of OE, Languages, CAE, Voc, AECC, SEC)
Semester 4 Code Title No. of Number of Number of Continuous End Semester Total
Number Hours of teaching Hrs credits Internal Marks marks
Instructio /Week Assessment
ns (CIA)
Marks
Theory 42 03 03 40 60 100
CA4122 Python
Programming
Theory 42 03 03 40 60 100
CA4222 Computer
Multimedia and
Animation
Theory 42 03 03 40 60 100
CA4322 Operating
System
Concepts
Practical 52 04 2 25 25 50
CA4P1 Python
programming
Lab
Practical 52 04 2 25 25 50
CA4P2 Multimedia and
Animation Lab
Total Number of credits:13+13( Total Credit of OE, Languages, CAE, Voc, AECC, SEC)
Semester 5 Code Title No. of Hours Number Number of Continuous End Total
Number of of teaching credits Internal Semester Marks
Instructions Hrs /week Assessment Marks
(CIA)
Marks
Theory 42 03 03 40 60 100
CADE5423 Cloud Computing
Practical 52 04 2 25 25 50
Internet
CA5P1
Technologies Lab
Practical CA5P2 52 04 2 25 25 50
Cybersecurity Lab
Semester 6 Code Title No. of Hours Number Number of credits Continuous End Total
Number of of Internal Semester marks
Instructions teaching Assessment Marks
Hrs
/week (CIA)
Marks
Theory CA6123 Software 42 03 03 40 60 100
Engineering
Practical 52 04 02 25 25 50
CA6P1 Mobile App Lab
Practical CA6P2 52 04 02 25 25 50
Major Project Lab
EXAMINATION AND ASSESMENTS
THEORY
1. IA Weightage 40 %
2. End Semester Examination Weightage 60%
PRACTICAL/PROJECTS
1. IA Weightage 50 %
2. End Semester Examination Weightage 50%
The question papers of the theory examinations should follow the pattern specified below:
Total Marks : 60
OPEN ELECTIVE
THEORY:
1. First Activity (should be multiple activities): 10 marks
2. Mid Semester Test: 20 marks (Test will be for 30 marks. It will be converted to 20)
3. Second Activity (should be multiple activities): 10 marks
4. Third Activity only for the first semester students who had scored less than 5 out of 10. Will be
conducted after activity 2. Maximum marks shall be 5.
Total 40 marks
30
PRACTICALS:
Every practical class the student should be assessed.
PIA – 25 marks
PROJECT LAB
Presentation / demo must be carried out in all the lab sessions in the whole semester for internal assessment of
the project. In each lab session a student is evaluated for 25 marks.
Presentation /Demo-15
Viva Voce-10
Semester: I
Content Hours
Unit – 1
Unit-2
Introduction to computers: Characteristics of computers, Classification of Digital 10
Computer Systems: Microcomputers, Minicomputers, Mainframes, Super computers.
Anatomy of Computer: Introduction, Functions & Components of a Computer, Central
Processing Unit, Microprocessor, Storage units, Input and output Devices. How CPU and
memory works. Program execution with illustrative examples. Introduction to
microcontrollers.
Unit-3
Unit-4
Unit-5
Internet and Web Basics: Introduction, Features of Internet, Internet application, 10
Services of Internet, Logical and physical addresses, Internet Service Providers, Domain
Name System. Introduction to web, web browsers, http/https, URL, Introduction to
HTML5, Introduction to CSS. Introduction to Emerging technologies: Overview and
features of Augmented Reality, Virtual Reality, Artificial Intelligence, Machine learning,
Data Warehousing, Data Mining, Big data analytics, Internet of Things.
Text Books:
1. Pradeep K. Sinha and Priti Sinha: Computer Fundamentals (Sixth Edition), BPB
Publication
2. David Riley and Kenny Hunt, Computational thinking for modern solver,Chapman &
Hall/CRC,
Reference:
1. J. Glenn Brook shear,” Computer Science: An Overview”, Addision-Wesley,Twelfth
Edition.
2. R.G. Dromey, “How to solve it by Computer”, PHI
BLUE PRINT
Part A: Hardware
7. System Configuration – BIOS Settings, Registry Editor, MS Config, Task Manager, System
Maintenance, Third-party System Maintenance Tools (Similar to Cleaner and Jv16 Power
Tools …)
Part B: Software
Content Hours
Unit – 1
Introduction to C Programming: Overview of C; History and Features of C; Planning
a Computer Program-Algorithm, Flowchart and Pseudo code with Examples. Structure
of a C Program with Examples; Creating and Executing a C Program; Compilation
process in C.
10
C Programming Basic Concepts: C Character Set; C tokens - keywords, identifiers,
constants, and variables; Data types; Declaration & initialization of variables; Symbolic
constants.
Input and output with C: Formatted I/O functions - printf and scanf, control stings and
escape sequences, output specifications with printf functions; Unformatted I/O
functions to read and display single character and a string - getchar, putchar, gets and
puts functions.
Unit – 2
Control Structures: Decision making Statements - Simple if, if_else, nested if_else, else_if
ladder, Switch Case, goto, break & continue statements; Looping
Statements - Entry controlled and exit controlled statements, while, do-while,for
loops, Nested loops.
Unit – 3
Unit – 5
Pointers in C: Understanding pointers - Declaring and initializing pointers,
accessing address and value of variables using pointers; Pointers and Arrays; Pointer
Arithmetic; Advantages and disadvantages of using pointers;
File Operations : File modes, File functions, and File operations, Text and Binary files, 6
Command Line arguments.
Text Books:
1. C: The Complete Reference, By Herbert Schildt.
2. Kernighan & Ritchie: The C Programming Language (PHI)
Reference Books:
1. P. K. Sinha & Priti Sinha: Computer Fundamentals (BPB)
2. E. Balaguruswamy: Programming in ANSI C (TMH)
3. Kamthane: Programming with ANSI and TURBO C (Pearson Education)
4. V. Rajaraman: Programming in C (PHI – EEE)
5. S. Byron Gottfried: Programming with C (TMH)
6. Yashwant Kanitkar: Let us C
7. P.B. Kottur: Programming in C (Sapna Book House)
BLUE PRINT
.
Unit Nos. No. of Total marks for which
Hours questions are to be
asked(including bonus
questions)
Unit 1 10 9
Unit 2 12 10
Unit 3 8 14
Unit 4 6 20
Unit 5 6 23
TOTAL 42 76
Maximum marks for the paper (Excluding bonus
questions) =60
Course Code: CA1P2 Course Title: C Programming Lab
Course Credits: 02 Hours/Week: 04
Total Contact Hours:52 Formative Assessment Marks:25
Exam Marks: 25 Exam Duration: 03
Programming Lab
Part A:
Part B:
8. Program to read a string and to find the number of alphabets, digits, vowels,
consonants, spaces and special characters.
9. Program to Reverse a String using Pointer
10. Program to Swap Two Numbers using Pointers
11. Program to demonstrate student structure to read & display records of n
students.
12. Program to demonstrate the difference between structure & union.
Note: Student has to execute a minimum of 10 programs in each part to complete theLab
course
Course Code: CA1321 Course Title: Mathematical Foundations
Course Credits: 03 Hours/Week: 03
Total Contact Hours: 42 Formative Assessment Marks: 40
Exam Marks: 100 Exam Duration: 3
Unit – 2
Operations on sets: power set- Venn diagram Cartesian product-relations - 10
functions- types of functions - composition of functions.
Unit – 3
Matrix algebra: Introduction-Types of matrices-matrix operations- transpose of a 10
matrix -determinant of matrix - inverse of a matrix- Cramer’s rule
Unit – 4
Matrix: finding rank of a matrix - normal form-echelon form cayley Hamilton 6
theorem-Eigen values
Unit – 5
Differential calculus: Functions and limits - Simple Differentiation ofAlgebraic 10
Functions – Evaluation of First and Second Order Derivatives –
Maxima and Minima
Text Books:
P. R. Vittal-Business Mathematics and Statistics, Margham Publications, Chennai,
Reference Books:
1. B. S. Vatsa-Discrete Mathematics –New Age International Limited Publishers, NewDelhi
Describe how arrays, records, linked structures, stacks, queues, trees, and
graphs are represented in memory and used by algorithms
Describe common applications for arrays, records, linked structures, stacks,
queues, trees, and graphs
Write programs that use arrays, records, linked structures, stacks, queues,
trees,and graphs
Demonstrate different methods for traversing trees
Compare alternative implementations of data structures with respect to
performance
Describe the concept of recursion, give examples of its use
Discuss the computational efficiency of the principal algorithms for sorting,
searching, and hashing
Content Hours
Unit – 1
Introduction to data structures: Definition; Types of data structures - Primitive & Non- 6
primitive, Linear and Non-linear; Operations on data structures.
Dynamic memory allocation: Static & Dynamic memory allocation; Memory allocation and
de-allocation functions - malloc, calloc, realloc and free.
Algorithm Specification, Performance Analysis, Performance Measurement-Asymptotic
notations.
Unit – 2
Unit – 4
Queues: Basic Concepts – Definition and Representation of queues; Types of queues 10
- Simple queues, Circular queues, Double ended queues, Priority queues; Operations on
Simple queues;
Linked list: Basic Concepts – Definition and Representation of linked list, Types of linked
lists - Singly linked list, Doubly liked list, Header liked list, Circular linked list; Representation
of Linked list in Memory;
Operations on Singly linked lists – Traversing, Searching, Insertion, Deletion; Memory
allocation; Garbage collection.
Unit – 5
Trees: Definition; Tree terminologies –node, root node, parent node, ancestors of a node, 8
siblings, terminal & non-terminal nodes, degree of a node, level, edge, path, depth;
Binary tree: Type of binary trees - strict binary tree, complete binary tree, binary search tree
and heap tree; Array and pointer representation of binary tree. Traversal of binary tree;
preorder, inorder and postorder traversal;
Text Books
1. Ellis Horowitz and Sartaj Sahni: Fundamentals of Data Structures
References
1. Tanenbaum: Data structures using C (Pearson Education)
2. Kamathane: Introduction to Data structures (Pearson Education)
3. Y. Kanitkar: Data Structures Using C (BPB)
4. Kottur: Data Structure Using C
5. Padma Reddy: Data Structure Using C
6. Sudipa Mukherjee: Data Structures using C – 1000 Problems and Solutions
(McGraw Hill Education, 2007))
BLUE PRINT
Programming Lab
Part A:
1. Program to find GCD using recursive function
2. Program to display Pascal Triangle using binomial function
3. Program to generate n Fibonacci numbers using recursive function.
4. Program to implement Towers of Hanoi.
5. Program to implement dynamic array, find smallest and largest element ofthe array.
6. Program to create two files to store even and odd numbers.
7. Program to create a file to store student records.
8. Program to read the names of cities and arrange them alphabetically.
9. Program to sort the given list using selection sort technique.
10. Program to sort the given list using bubble sort technique.
Part B:
1. Program to sort the given list using insertion sort technique.
2. Program to sort the given list using quick sort technique.
3. Program to sort the given list using merge sort technique.
4. Program to search an element using linear search technique.
5. Program to search an element using recursive binary search technique.
6. Program to implement Stack.
7. Program to convert an infix expression to postfix.
8. Program to implement simple queue.
9. Program to implement linear linked list.
10. Program to display traversal of a tree.
Course Code: CA2221 Course Title: Object Oriented Programming with
JAVA
Course Credits: 03 Hours/Week: 03
Total Contact Hours: 42 Formative Assessment Marks: 40
Exam Marks: 100 Exam Duration: 03 hrs
Course Content
Content Hours
Unit – 1
6
Introduction to Java: Basics of Java programming, Data types, Variables, Operators,
Control structures including selection, Looping, Java methods, Overloading, Math class,
Arrays in java.
Unit – 2
6
Objects and Classes: Basics of objects and classes in java, Constructors, Finalizer,
Visibility modifiers, Methods and objects, Inbuilt classes like String, Character, String
Buffer, File, this reference.
Unit – 3
8
Inheritance and Polymorphism: Inheritance in java, Super and sub class, Overriding,
Object class, Polymorphism, Dynamic binding, Generic programming, Casting objects,
Instance of operator, Abstract class, Interface in java, Package in java, UTIL package.
Unit – 4
10
Event and GUI programming: Event handling in java, Event types, Mouse and
key events, GUI Basics, Panels, Frames, Layout Managers: Flow Layout, Border Layout,
Grid Layout, GUI components like Buttons, Check Boxes, Radio Buttons, Labels, Text
Fields, Text Areas, Combo Boxes, Lists, Scroll Bars, Sliders, Windows, Menus, Dialog
Box, Applet and its life cycle, Introduction to swing, Exceptional handling mechanism.
Unit – 5
6
I/O programming: Text and Binary I/O, Binary I/O classes, Object I/O, Random Access
Files.
Unit – 6
6
Multithreading and Exception handling in java: Thread life cycle and methods, Runnable
interface, Thread synchronization, Exception handling with try catch-finally, Collections
in java, Introduction to JavaBeans and Network Programming.
Text Books
Reference Books
2. Java - The Complete Reference, 7th Edition, By Herbert Schildt– McGraw Hill
publication.
BLUE PRINT
Practice Lab
Programming Lab
1. Program to assign two integer values to X and Y. Using the ‘if’ statement the output
of the program should display a message whether X is greater than Y.
2. Program to list the factorial of the numbers 1 to 10. To calculate the factorialvalue,
use while loop. (Hint Fact of 4 = 4*3*2*1)
3. Program to add two integers and two float numbers. When no arguments are
supplied, give a default value to calculate the sum. Use function overloading.
4. Program to perform mathematical operations. Create a class called AddSub with
methods to add and subtract. Create another class called MulDiv that extends from
AddSub class to use the member data of the super class. MulDiv should have methods
to multiply and divide A main function should access the methods and perform the
mathematical operations.
5. Program with class variable that is available for all instances of a class. Use static
variable declaration. Observe the changes that occur in the object’s member variable
values.
6. Program
a. To find the area and circumference of the circle by accepting the radius from the
user.
b. To accept a number and find whether the number is Prime or not
7. Program to create a student class with following attributes;
Enrollment No: Name, Mark of sub1, Mark of sub2, mark of sub3, TotalMarks. The
three marks must be calculated only when the student passes in all three subjects.
The pass mark for each subject is 50. If a candidate fails in any one of the subjects,
his total mark must be declared as zero. Using this condition write a constructor for
this class. Write separate functions for accepting and displaying student details. In
the main method create an array of three student objects and display the details.
8. In a college first year class are having the following attributes Name of the class (BCA,
BCom, BSc), Name of the staff No of the students in the class, Array of students in the
class
9. Define a class called first year with above attributes and define a suitable
constructor. Also write a method called best Student () which process a first-year
object and return the student with the highest total mark. In the main method define
a first-year object and find the best student of this class
10. Program to define a class called employee with the name and date of appointment.
Create ten employee objects as an array and sort them as per their date of
appointment. ie, print them as per their seniority.
11. Create a package ‘student. Fulltime. BCA ‘in your current working directory
a. Create a default class student in the above package with the following attributes:
Name, age, sex.
b. Have methods for storing as well as displaying
Content Hours
Unit – 1
10
The Foundations: Logic and proofs: Propositional Logic, Applications of Propositional
Logic, Propositional Equivalences, Predicates and Quantifiers, Nested Quantifiers, Rules
of Inference, Introduction to Proofs, Proof Methods and Strategy.
Unit – 2
12
Counting: Basics of counting, Pigeonhole principle, Permutation and combination,
Binomial Coefficient and Combination, Generating functions-Generating Permutation
and Combination.
Advanced Counting Techniques: Applications of Recurrence Relations, Solving Linear
Recurrence, Relations, Divide and Conquer Algorithms and Recurrence Relations,
Inclusion-Exclusion, Applications ofInclusion-exclusion.
Unit – 3
12
Induction and Recursion: Mathematical Induction, Strong Induction and Well-
Ordering, Recursive Definitions and Structural Induction, Recursive Algorithms,
Program Corrections.
Relation: Properties of relation, Composition of relation, Closer operation on relation,
Equivalence relation and partition. Operation on relation, Representing relation.
Unit – 4
8
Graphs: Graphs and Graph models, Special Types of Graphs, Sub graphs, Walk, Path and
circuit, Fundamental circuit, Euler and Hamilton Paths, Shortest-Path Problems, Planar
Graphs.
Text Book:
BLUE PRINT
Unit Nos. No. of Hours Total marks for which
questions are to be asked
(Including bonus questions)
Unit 1 10 10
Unit 2 12 10
Unit 3 12 33
Unit 4 8 23
TOTAL 42 76
Maximum marks for the paper (Excluding bonus questions) =
60
Semester: III
Content Hours
Unit –1
Unit-2
Data Modeling Using Entity-Relationship Model: Using High-Level Conceptual Data 10
Models for Database Design, An Example Database Application, Entity Types, Entity Sets,
Attributes and Keys, Relationship Types, Relationship Sets, Roles and Structural
Constraints, Weak Entity Types, Refining the ER Design, Naming Conventions and Design.
File organization and storage, secondary storage devices, type of single level ordered
index, multi-level indexes.
Unit-3
Structured Query Language: SQL Data Definition and Data Types, Basic Queries in SQL- 8
CREATE statement, Specifying Constraints in SQL, Basic Retrieval Queries in SQL –
SELECT statement, INSERT, DELETE, and UPDATE Statements in SQL, GRANT and
REVOKE statements, Complex SQL Retrieval Queries - Comparisons Involving NULL and
Three-Valued Logic, Nested Queries, The GROUP BY and HAVING Clauses. Views (Virtual
Tables) in SQL - CREATE VIEW, View Implementation, View Update, and Inline Views.
Schema Change Statements in SQL – DROP and ALTER command.
Unit-5
8
Introduction to Transactions and Database Recovery: Introduction to transaction
processing, transaction and system concepts, desirable properties of transactions.
Concurrency control techniques: types of lock, two-phase locking techniques. Recovery
techniques: recovery concepts, database backup and recovery from catastrophic failures.
Text Books:
1. Elmasri and Navathe: Fundamentals of Database Systems, 7th Edition, Addison -
Wesley, 2016.
2. Silberschatz, Korth and Sudharshan Data base System Concepts, 7th Edition,
TataMcGraw Hill, 2019.
Reference:
1. C.J. Date, A. Kannan, S. Swamynatham: An Introduction to Database
Systems, 8th Edition, Pearson education, 2009
2. 2. Database Management Systems :Raghu Ramakrishnan and
Johannes Gehrke: , 3rd Edition, McGrawHill, 2003
BLUE PRINT
Describe the basics of SQL and construct queries using SQL. Emphasize theimportance
of normalization in databases.
SQL Programming
Design, develop, and implement the specified queries for the following problems using
Oracle, MySQL, MS SQL Server, or any other DBMS under LINUX/Windows environment.
Create Schema and insert at least 5 records for each table. Add appropriate database
constraints.
1. Perform the following:
i) Creating a Database,
ii) Viewing all databases,
iii) Viewing all Tables in a Database,
iv) Creating Tables (With and Without Constraints),
v) Delete Table
vi) Rename Table.
2. Write SQL Queries involving:
1. Date Functions,
2. String Functions and
3. Math Functions.
3. Create a table STATION to store information about weather observation stations with
fields: ID(Primary Key), CITY, STATE, LAT, LONG and populate the table STATION with
a few rows:
i)Write a SQL query to look at table STATION in undefined order
ii)
Write a SQL query to select Northern stations (latitude > 39.7)
iii)
Write a SQL query to select only ID, CITY, and STATE columns
iv)
Write a SQL query to select only ID, CITY, and STATE columns where Longitude
>45.
4. Create a table STATION to store information about weather observation stations with
fields: ID (Primary Key), CITY, STATE, LAT, LONG. Duplicate ID fields are not allowed.
Populate the table STATION with a few rows.
Create another table called STATS to store normalized temperature and
precipitation data:
ID field must match some STATION table ID (so that name and location will be
known).
Allowable ranges will be enforced for other values.
No duplicate ID and MONTH combinations.
Temperature is in degrees Fahrenheit.
Rainfall is in inches.
i) Populate the table STATS with some statistics for January and July.
ii) Write a SQL query to look at table STATS in undefined order.
iii) Write a SQL query to look at table STATS, picking up location information by
joining with table STATION on the ID column.
iv) Write a SQL query to look at the table STATS, ordered by month and greatest
rainfall, with columns rearranged.
5. Create a table STATION to store information about weather observation stations with
fields: ID(Primary Key), CITY, STATE, LAT, LONG. No duplicate ID fields allowed.
Populate the table STATION with a few rows. Create another table called STATS to store
normalized temperature and precipitation data.
ID field must match some STATION table ID (so name and location will be
known).
Allowable ranges will be enforced for other values.
No duplicate ID and MONTH combinations.
Temperature is in degrees Fahrenheit.
Rainfall is in inches.
i) Write a SQL query to look at temperatures for July from table STATS, lowest
temperatures first, picking up city name and latitude by joining with table STATION
on the ID column
ii) Write a SQL query to show MAX and MIN temperatures as well as average rainfall
for each station
iii) Write a SQL query (with sub query) to show stations with year-round average
temperature above 50 degrees.
Rows are selected from the STATION table based on related values in the
STATS table.
6. Create table called STATS to store normalized temperature and precipitation data.
Allowable ranges will be enforced for other values.
No duplicate ID and MONTH combinations.
Temperature is in degrees Fahrenheit.
Rainfall is in inches.
i) Create a view (derived table or persistent query) to convert Fahrenheit to Celsius
and inches to centimeters
ii) Add new column rainfall_centimeter to the table STATS.
iii) Insert values into rainfall_centimeter from the view
iv) Delete Column rainfall from table STATS
7. Create table called STATS to store normalized temperature and precipitation data:
Allowable ranges will be enforced for other values.
No duplicate ID and MONTH combinations.
Temperature is in degrees Fahrenheit.
Rainfall is in inches.
i) Write a SQL query to look at table STATS in a metric light (through the new view).
ii) Write a SQL metric query restricted to January below-freezing (0 Celsius) data,
sorted on rainfall.
8. Create table called STATS to store normalized temperature and precipitation data.
i) Update all rows of table STATS to compensate for faulty rain gauges known to
read 0.01 inches low
ii) Update one row, ID 44’s July temperature reading, to correct a data entry error
iii) Make the above changes permanent
iv) Undo that update
9. Create a table STATION to store information about weather observation stations with
fields: ID(Primary Key), CITY, STATE, LAT, LONG. No duplicate ID fields allowed.
Populate the table STATION with a few rows.
Create another table called STATS to store normalized temperature and precipitation
data.
ID field must match some STATION table ID (so name and location will be
known).
Allowable ranges will be enforced for other values.
No duplicate ID and MONTH combinations.
Temperature is in degrees Fahrenheit.
Rainfall is in inches.
i) Delete data from STATION table where longitude is >90
ii) Delete July data from STATS table where longitude is >90
iii) Increase the size for the column CITY with the following information:-
COLUMNNAME DATATYPE(SIZE)
-------------------- ----------------------
CITY VARCHAR (25)
iv) Modify the column name of LONG to LONGITUDE present in the STATION table
and verify the result.
10. Create Table INSTRUCTOR with the following fields: InstuctID, InstructName,
Department, Salary.
(i) Find instructors whose salary is more than the salary of any employee from
department ‘Physics’.
(ii) Find the instructor name and department name of all instructors working in a
department with any instructor whose name contains the letter “S”.
(iii) Find the name and department name, of instructors whose salary is more than all
their colleagues salaries in the same department.
a. Create table INSTRUCTOR with the following fields: InstuctID, InstructName,
Department, Salary.
Create another table called STUDENT with the following fields: StudentID,
StudentName, Department, InstuctID
(i) Find the names of all instructors whose salary is greater than at least one instructor
in the Finance department.
(ii) Find all instructors whose salary is less than the salary of all instructors in the
Computer Science department and whose department name is not Computer
Science.
(iii) Find the student name and department name of all student who study in a
department with any student whose name contains the letter “S”.
CONTENT Hours
UNIT 1
Introduction: .NET Definition, Characteristics, Application, Difference between c and c#, The, the 8
.NET framework, benefits of the .NET approach, C# and .NET, .NET Architecture-Common Language
Runtime, MSIL, .NET Framework Classes. Advantages of Managed Code, Garbage Collection, Security.
program structure , command line argument, Literals, variables and data types , constant variables,
scope of variables, boxing and unboxing.
UNIT 2
Features of C# and OOP: Operators in C#, expression, Decision making and looping statements in 9
c# Methods in C# -declaring methods, nesting of methods, methods parameters, the output
parameters, Static data members, Static member function, Arrays - variable size arrays, array list
class, String handling . Overview of OOP , Defining a class, Adding Variables and Methods, Member
Access Modifiers, Creating Objects, Accessing Class Members.
UNIT 3
Object Oriented C#: Types of Constructors ,This Reference, , Inheritance and polymorphism : 9
classical inheritance, containment inheritance, defining a subclass, visibility control, defining
subclass constructors, multilevel inheritance, hierarchical inheritance, overriding methods, hiding
methods, abstract classes, abstract methods, sealed classes : Preventing inheritance, sealed methods,
polymorphism. Interfaces : Multiple Inheritance : defining an interface, extending an interface,
implementing interface, interface & inheritance.
UNIT 4
Introduction to Visual Studio and Exceptions-NET- ASP.NET. Difference Between ASP and 8
ASP.NET, Creating A web application using ASP.NET ,Components of an ASP.NET Custom Control,
Deploying ASP.NET application .Errors and Exception Handling, Exceptions Classes User Defined
Exceptions , Delegate- delegate declaration, delegate methods, delegates instantiation, delegate
invocation, using delegates.
UNIT 5
Introduction to Data Access- Comparison between ADO & ADO.NET—The difference between 8
Connection Model & Disconnected Model – difference between the DataSet and RecordSet- The
Dataset Model. Accessing Data using ADO.NET: dataset-DataAdapter DataRelation.
TEXT BOOKS:
1. Simon Robinson, Christian Nagel, Karli Watson, Jay Glynn, Morgan Skinner and Bill
Evjen, Professional C#, Wiley – dreamtech India Pvt. Ltd., 3rd Edition.
2. C# 8.0 and .NET, Core 3.0 is a book written by Mark J 4th Edition.
3. .NET(Core Reference) Microsoft® Visual C#® 2005: The Language by Donis
Marshall
4. Programming in C#, E. Balagurusamy, 2017, McGraw Hill Education
5. C# 4.0 complete reference by Herbert Schildt, from McGraw Hill Education
6. Beginning ASP.NET in C#, Matthew MacDonald.
7. HANDS ON WITH ASP.NET MVC - COVERING MVC 6, Rahul Sahay.
8. Designing Microsoft ASP.NET Application, Jonathan Goodyear, Brain Peek.
BLUE PRINT
Part A
1. Create a project to demonstrate the working of command line arguments for constant
and read only using command prompt.
2. Create a project to demonstrate the working of boxing and unboxing by convert
integer to object and vice versa.
3. Create a project to demonstrate the working of scope of the variables for the following
access modifier.
a) Public
b) Protected
c) Private
d) Internal
e) Protected internal.
4. Create a project to demonstrate the working of different control statement used in c#
with support to a generate shopping bill will contain bill number, name of clerk
preparing the bill, each item with quantity and price and total amount to be paid. Total
items in the bill are varying can be accommodated in a single bill. There is an array
describing each item with a price. The price is to be picked up from that.
6. Given below is a hypothetical table showing rates of Income Tax for male citizens below
the age of 65 years:
Taxable Income (T1) in Income Tax in
Does not exceed 1,60,000 Nil
Is greater than 1,60,000 and less than or (T1-1,60,000) * 10%
equal to 5,00,000
Is greater than 5,00,000 and less than or [(T1 – 5,00,000) * 20%] + 34,000
equal to 8,00,000
Is greater than 8,00,000 [T1-8,00,000) * 30%] + 94,000
Write a program to input the age, gender (male or female) and Taxable Income of a
person.If the age is more than 65 years or the gender is female, display “wrong
category”.If the age is less than or equal to 65 years and the gender is male, compute
and display the Income Tax payable as per the table given above.
using method
b. Write a program to pass 2 integer numbers as parameters. If either of the two
numbers is 0, display invalid entry and the program should end, if it is valid entry, divide
the larger number with the smaller number and display the result.
10. Write a program to read the data using one- dimensional array and determine the
following.
a. Total marks obtained.
b. The highest marks and lowest marks obtained subject wise.
11. Create a project to demonstrate the working multi-dimensional array for matrix
multiplication.
12. Create a project to demonstrate the working of jagged array to input and display elements
in the calendar format.
13 a. Write a program in C# Sharp to read a string through the keyboard and sort it using
bubble sort
b. Create a project to demonstrate the working of immutable string operation and find
the time taken for the immutable string manipulation.
14. Project to implement the access details of the banking information system using the
access modifier.
15. Project to design a calculator with all basic functionality using delegates.
Part B
1. Project to implement achieve following goals using single level inheritance.
a. Name, Price, Processor, Ram and Hard drive should be defined in base class
as constant.
b. You need to inherit these functionalities in your program and Print Details.
c. All the laptop should have different name, price, processor, ram and hard drive.
Have a good understanding of the OSI Reference Model and in particular have a good
knowledge of Layers 1-3.
Analyze the requirements for a given organizational structure and select the most
appropriate networking architecture and technologies .
Content Hours
Unit –1
9
DATA COMMUNICATION: Components of Data Communication – Direction of Data flow,
Networks – Components and Categories – Types of Connections –Protocols and Standards –
ISO / OSI model,: Transmission modes, Transmission Media, Switching- Circuit Switched
Networks, Datagram Networks, Virtual Circuit Networks.
Self-study : Topologies
Unit –2
Unit –3
DATA LINK LAYER: Introduction, Framing, and Error – Detection and Correction – Parity – 9
LRC – CRC Hamming code, detection and correction – Error detection , Two dimensional
parity checks , Internet checksum , Polynomial code; standardized Polynomial codes , Error
detecting capability of a polynomial code Flow and Error Control, Noiseless Channels, Noisy
Channels, FDDI, ALOHA, CSMA/CD, Random access, Controlled access, Channelization .
Unit – 4
Unit –5
TRANSPORT LAYER AND APPLIATION LAYER: Process to Process Delivery, UDP and TCP
protocols, IP, TCP, UDP headers Data Traffic, Congestion, Congestion Control, QoS, Integrated
Services, Differentiated Services, and QoS in Switched Networks. : Domain name space, DNS in 9
internet, electronic mail, SMTP, MIME,FTP,WWW, HTTP, SNMP,NFS protocols.
Self Study: DNS, FTP,HTTP,SNMP
Text Books:
BLUE PRINT
This course focuses on structure and components of Python program. It emphasis on designing
object-oriented program with Python classes. At the end of this course the student will be able to:
Understand the need of Python is various fields.
Get the knowledge in solving the complex problems with optimized solutions.
Integrate and connect various real time projects in achieving multi-disciplinary fields.
Understand the concept of object-oriented programming paradigm and its applications.
Understand the data manipulations and built-in functions.
Content Hours
Unit – 1
Basics of Python program 8
Printing text, printing the result of a calculation, Strings in Python, The Escape
Character, Variables and Types, Numeric Data Types in Python, Numeric Operators,
Expressions, Integer division, Operator Precedence. Programming examples for each
concept. String and Slice:
The String Data Type, Negative Indexing in Strings, Slicing, Slicing with Negative
Numbers, Using a Step in a Slice, Slicing Backwards, String Operators, String
Replacement Fields, String Formatting. Programming examples for each concepts.
Unit – 2
Program Flow Control & Functions 8
Conditional blocks using if, else and elif, for loops in, for loop using ranges, use of while
loops in python, Loop manipulation using pass, continue, break and else. Organizing
python codes using functions, organizing python projects into modules, importing own
module as well as external modules, Understanding Packages.
Unit – 3
9
String, List, Dictionary & File handling:
Unit – 4
OO Programming & Regular Expressions: 9
Concept of class, object and instances, constructor, class attributes and destructors,
Inheritance, overlapping and overloading operators, Adding and retrieving dynamic
attributes of classes. Pattern matching and searching, Power of pattern searching using
regex in python, Pattern finding programs using regular expression.
Unit – 5
Exception Handling & Database Interaction: 8
Avoiding code break using exception handling, Safe guarding file operation using
exception handling, Handling and helping developer with error code. SQL Database
connection using python, Creating and searching tables, Reading, storing and updating
information on database.
REFERENCES:
1. “Python Programming: A Complete Guide for Beginners to Master, Python Programming Language”
by Brian Draper
2. “Python Programming for Beginners: Python Programming Language Tutorial” by Joseph Joyner
BLUE PRINT
Implement the Object Oriented Programming Paradigm in solving real world problems.
Analyze the various features like built-in library and data structure to operate on the various
types of data.
2. Create a Menu Driven Program using Python that takes a string as input and prints the
Following:
a. Reverse the string b. Length of the string c. Number of Vowels in a String d. Number of
Uppercase Letters and Lower Case Letters in a String e. New string that does not have any
duplicate characters
3. Create a Menu Driven Program using Python that takes a List of Numbers from the user and does
the following:
a. Print the Second Largest Number in the List
b. Swap the first and last items of that list and print
c. Remove the duplicate members in that list and print.
d. Print the number Occurring Odd Number of Times in a List e. Print the list which has the
square of the numbers in the given List.
4. Create a Menu Driven Program using Python that takes two lists from the user and
does the following:
a. Print the Union of the Lists
b. Print the Intersection of the Lists
c. Print the Merged and sorted List
d. Print the sum of all the numbers in both the lists
e. Print the average of all numbers in both the lists
5. Create a Menu Driven Program using Python that does the following:
a. Creates and Prints a Dictionary with numbers and their squared values till 10
b. Print the sum of all values in the Dictionary
c. Ask a number from the user and Remove it from the Dictionary and Print
d. Print all items in the dictionary whose values are above 50
6. Create a Menu Driven Program using Python that takes a number from the user does the following
Using Recursion:
a. Print Fibonacci Series
b. Print Factorial of that number
c. Print the Sum of the digits in that number
d. Print if the given number is Prime Number or Not
7. Create a Menu Driven Program using Python that does the following file operations:
a. Create a File named 'zen_of_python.txt and write the data that comes from
import this into the created file (Use Exclusive Creation).
b. Print all the data in that file
c. Print total number of words in that file.
d. Capitalize First Letter of Every word in that file
e. Print the contents of the file in reverse order
8. Create a Menu Driven Program using Python that does the following:
a. Print the current Date and Time (DD-MM-YYYY HH:MM: SS AM/PM)
b. Print all the Sundays of a specified year
c. Print new Date after adding 28 days to the current Date
d. Print the Day of the given Date
e. Calculate Age by taking the Date of Birth
9. Create a Menu Driven Program in Python that takes a string and checks if it follows
the regular expressions given below:
a. Matches a string that has an 'a' followed by anything, ending in 'b'
b. Print only a 4-digit number from a message as string
c. Convert a date of yyyy-mm-dd format to dd-mm-yyyy format
d. Find all five characters long word in a string
e. Split a string with multiple delimiters
10. Create a User Defined Exception for Age, that is raised if the given number is not above 18 and
below 100. Use this exception in a program where it is raised programmatically after accepting a
Number.
11. Create a Menu Driven Program in Python that prints the following pattern for the given
number: (Refer Pattern List in Google Classroom)
a. Pattern #2: Inverted Pyramid of Numbers
12. Create a Menu Driven Program in Python that does the following:
a. Accept a sentence and reverse each word in it
b. Take a string input and sort them based on the number of characters in each word
and mention the count of letters in a word at the end.
c. Take a number as string type and convert it into an integer without using inbuilt functions
d. Take a String and append a digit after every character with total count of that character in that
string (ignore case)
13. You are given input file input_digits_P1.txt and input_words_P1.txt which contains
Comma separated random integers. E.g. 2, 3, 10, 8, 7, 20, 11, 25, 30, 17, 12.
• Read the integers from the input_digits_P1.txt file and calculate the Sum of the Odd
and Even numbers.
• Create a file with the name sum_of_odd_numbers.txt and store the sum of odd
Numbers in that file. E.g. 63 Create a file with the name sum_of_even_numbers.txt and
store the sum of even
numbers in that file.e.g. 82
• In the same program read the words from input_words_P1.txt (E.g.: Apple, Ball,
Cat, Dog, Egg) separated by comma and generate the below output using the digits read in
Output:
2 Apple, 10 Ball, 8 Cat, 20 Dog, 30 Egg, 12 Apple Save the final output in a file final_output.txt.
14. Create a Menu Driven Program using Python that performs the following using the
Database Structure mentioned below: Table Name: Student Fields: student_id, student_name,
student_course, student_email, student_dob
a) Add a new Student and Display the Details
b) Edit a Particular Student Detail and display the details.
c) Show All Student Details
d) Show One Student Detail e) Delete a Student Record.
15. a. Write a Python program that matches a string that has an a followed by zero or more b's.
b. Write a Python program to find the sequences of one upper case letter followed by lower case
letters.
c. Write a Python program to find the substrings within a string.
d. Write a Python program to convert a date of yyyy-mm-dd format to dd-mm-yyyy format.
Course Code: 4222 Course Title: Computer Multimedia and Animation
Course Credits: 03 Hours/Week: 03
Total Contact Hours:42 Formative Assessment Marks: 40
Exam Marks:100 Exam Duration: 3 Hrs.
Course Content
Content Hours
Unit – 1
Introduction to Multimedia: 6
History of Multimedia, its market – Content copyright – Resources for multimedia
developers – Types of produces – Evaluation – Hardware Architecture – OS and
Software – Multimedia Architecture – Software library – Drivers.
Unit – 2
Computer Fonts and Hypertext: 6
Usage of text in Multimedia, Families and faces of fonts, outline fonts, bitmap font
International character sets and hypertext, Digital fonts techniques. Text file formatsand
Compression techniques.
Unit – 3
Image fundamentals and representations 10
Colour Science , Colour, Colour Models, Colour palettes, Dithering, 2D Graphics, Image
Compression and File Formats :GIF, JPEG, JPEG 2000, PNG, TIFF, EXIF, PS, PDF, Basic
Image Processing [ Can Use Photoshop ], Use of image editing software, White balance
correction, Dynamic range correction, Gamma correction, Photo Retouching.
Unit – 4
Audio fundamentals and representations 10
Digital Audio : Audio software and hardware, Characteristics of sound and Digital
audio Digitization of sound, frequency and bandwidth, decibel system, data rate,
audio file format, Sound synthesis, MIDI, wavetable, Digital Audio systems, Audio file
formats – Using Audio in Multimedia Applications – Audio for content.
Compression and transmission of audio on Internet, Adding sound to your
multimedia project.
Unit 5
Video and Animation 10
Video Basics , Video software and hardware, How Video Works, Broadcast Video
Standards, Analog video, Digital video, Video Recording and Tape formats, Shooting
and Editing Video (Use Adobe Premier for editing), Video Compression and File
Formats. Video compression based on motion compensation, MPEG-1, MPEG-2, MPEG-
4, MPEG-7, MPEG-21, Animation: Cell Animation, Computer Animation, Morphing.
Video capture and playback systems.
Text Books:
1. Tay Vaughan, “Multimedia making it work”, Tata McGraw-Hill, 2008.
2. Rajneesh Aggarwal & B. B Tiwari, “Multimedia Systems”, Excel Publication, New Delhi, 2007.
3. Li & Drew, “ Fundamentals of Multimedia” , Pearson Education, 2009.
4. Parekh Ranjan, “Principles of Multimedia”, Tata McGraw-Hill, 2007 2. Anirban Mukhopadhyay and
Arup Chattopadhyay, “Introduction to Computer Graphics and Multimedia”, Second Edition, Vikas
Publishing House
5.The book of Audacity : record, edit, mix, and master with the free audio editor
Schroder, Carla. San Francisco : No Starch Press; c2011
6. Creating DSLR video : from snapshots to great shots
Harrington, Richard, 1972-Berkeley, CA : Peachpit Press; 2012.
BLUE PRINT
Analysis the various tools and techniques and develop various project that can used in the real
world concepts.
CONTENT HOURS
UNIT 1:
INTRODUCTION: 8
Definition, functions, operating system structure, types, Buffering & spooling,
multiprogramming, time - sharing, Real time system, distributed systems, parallel
systems protection, system components, system calls.
UNIT 2:
PROCESS MANAGEMENT: 10
Process concept (program, process and thread), states of a process, process control
block, functions, Cooperating process, Inter-process communication, Scheduling
Criteria, schedulers-types, (pre-emptive and non-preemptive) FCFS, SJF, Round
Robin, priority scheduling, multilevel, multilevel feedback algorithms
UNIT 3:
PROCESS SYNCHRONIZATION AND DEADLOCK: 8
process synchronization – semaphores, critical section problems, classic problems
of synchronization, Deadlock ,deadlock characterization, methods for handling
deadlock, deadlock prevention, avoidance and detection using resource allocation
graph and wait for graph, Recovery from deadlock.
UNIT 4:
MEMORY MANAGEMENT: 8
Functions, Different Schemes-Single Continuous-Partitioned -Multiple Relocatable-
Paging-Demand Paging-Segmentation-Paged segmentation. Virtual Memory
management: Demand paging, Page replacement and page replacement algorithm
(FIFO, LRU), Segmentation and thrashing.
UNIT 5:
DEVICE AND FILE SYSTEM: 8
Disk structure, allocation methods, free space management, need for disk
scheduling, scheduling algorithm-FCFS (First Come, First Served), SSTF (Shortest
Seek Time First), SCAN, C-SCAN (circular scan), file system – definition, access
methods, directory structure, organization, file protections.
Text Books:
References:
2. Operating Systems: Internals and Design Principles, by William Stallings, seventh edition
BLUE PRINT
Course Objectives
1. Define the major types and themes of e-commerce and to understand the evolution of e-
commerce with implication in academic disciplines.
2. Identify the key components of e-commerce business models, to describe major B2C and B2B
Models and to understand business key concepts and strategies.
3. Discover E commerce presence and relate SWOT analysis to analyze security threats and
management policies for online payment systems.
4. Understand the key features of the Internet audience and the basic concepts of consumer
behaviour and to Identify and describe the basic digital commerce marketing and advertising
strategies and tools, understand the costs and benefits of online marketing communications.
5. Infer and articulate the Supply chain Management and collaborative commerce.
Content Hours
Unit – 1
Introduction to E Commerce 8
Unique features of E Commerce technology, Types of E Commerce, Historical Evolution of E
Commerce, Understanding E Commerce: Organizing themes. Academic disciplines concerned
with E Commerce.
Case study: Pinterest: A Picture is worth of Thousand words.
Unit-2
Unit-4
Unit-5
Text Book:
Kenneth C. Laudon and Carol Guercio Traver:” E-Commerce: Business, Technology, and Society”,
Pearson,2017.
Reference Books
BLUEPRINT
Chapter No. of hours Total marks for which questions are to be asked
(Including bonus questions)
Unit 1 8 10
Unit 2 8 10
Unit 3 10 22
Unit 4 10 22
Unit 5 6 14
TOTAL 42 78
Maximum marks for the paper (Excluding bonus questions) =60
Course Code: CA 5223 Course Title: Internet Technologies.
Course Objectives:
1. Students will be able to design an interactive web page using Scripting languages.
2. Students will be able to distinguish Single Page React application and traditional web
development frameworks.
3. Students will be able to differentiate between static web pages and dynamic webpages.
4. Students will be able develop an application from scratch using React JS.
5. Students will be able to create, build, and deploy react applications with server-side
programming.
Course Outcomes:
Content Hours
Unit – 1
HTML: 9
Introduction to HTML, HTML Syntax, Semantic Markup, Structure of HTML Documents,
Quick Tour of HTML Elements, HTML5 Semantic Structure Elements, formatting tags,
Header elements, font tag, List tags, Image & anchor tags.
HTML Tables and Forms:
Introducing Tables, Styling Tables, Introducing Forms, Form Control Elements, Table
and Form Accessibility
CSS:
Introduction to CSS, CSS Syntax, Location of Styles, Selectors, The Cascade: How Styles
Interact, The Box Model, CSS Text Styling.
Unit-2
JavaScript: 8
Client-Side Scripting, Introduction to JavaScript- Design Principles, Syntax, JavaScript
Objects, Syntax-Variables and Data Types-Statements-Operators-Literals-Functions-
Objects-Arrays-Built-in Objects -The Document Object Model (DOM), JavaScript
Events, Forms.
Unit-3
ReactJS : 8
ES6 Overview
Introduction to ES6, ES6 lable, Block scope, let & const, Template literals, Arrow
functions, Spread and Rest operators, Destructuring
Classes - Inheritance, Static properties and methods, Inheritance. Promises, Modules
Introduction to React:
Introduction to React-React version history-React 16 vs React 15-Just React - Hello
World- Using create-react-app-Anatomy of react project- Running the app- Debugging
first react app.
Unit-4
Unit-5
References:
1. MASTERING HTML, CSS & Java Script Web Publishing Paperback – 15 July 2016.
2. Web Design with HTML, CSS, JavaScript and Jquery Set Paperback – 15 August 2014.
3. HTML To React: The Ultimate Guide.
BLUEPRINT
Chapter No. of Hours Total marks for which questions are to be asked
(Including bonus questions)
Unit 1 9 10
Unit 2 8 10
Unit 3 8 22
Unit 4 8 22
Unit 5 9 14
TOTAL 42 78
Maximum marks for the paper (Excluding bonus questions) =60
Course Code: CA5P1 Course Title: Internet Technologies Lab
Course Objectives:
1. Students will be able to design an interactive web page using HTML5, Java script.
2. Students will be able to distinguish Single Page React application and traditional web
development frameworks.
3. Students will be able develop an application using React 16.
4. Students will be able to create react applications with server-side programming.
Course Outcomes:
Students can acquire the following skills after completing the course:
1. To able to develop interactive web pages.
2. To Demonstrate various open sources in managing data.
3. Importing and exporting data across the web pages.
4. Perform thorough Form Validation.
5. Able to connect the Front-end with back-end.
PROGRAM LIST
1. Create your profile page i.e., educational details, Hobbies, Achievement, My Ideals etc. using
HTML lists.
2. Use table tag to format web page. Also create the Time Table of your class using table tag.
3. Write HTML code to build a Reservation form.
4. Write HTML code to build an application form.
5. Create a home page using CSS concepts to add a menu and various text, image and colour
properties.
6. Create Style sheet to set formatting for text tags and embed that style sheet on web pages
created for your site.
7. Develop and demonstrate the usage of inline, internal and external style sheet using CSS.
8. Write a JavaScript program to determine whether a given year is a leap year in the Gregorian
calendar.
9. Write a JavaScript program to convert temperatures to and from Celsius, Fahrenheit.
10. Write JavaScript to validate the following fields of the Registration
page.
1. First Name (Name should contains alphabets and the length should
not be less than 6 characters).
2. Password (Password should not be less than 6 characters length).
Project Development Using React JS.
11. Prepare Project for Weather Finder App using React Js
12. Prepare Project for Bill and Discount Calculator using React JS.
Evaluation Scheme for Lab Examination
Assessment Criteria Marks
Writing 8
Execution 10
Viva Voice 7
Total 25
Course Code: CA5323 Course Title: Cyber Law & Cyber Security
Course Objectives:
1. To provide an understanding of the main issues related to security in modern networked
computer systems.
2. To understand concepts and foundations of computer security.
3. Basic knowledge about security-relevant decisions in designing IT infrastructures like
personal laptop to large-scale infrastructures.
Course Outcomes:
Here the students will be able to understand
1. An extensive, detailed, and critical understanding of the concepts, issues, principles and
theories of computer network security.
2. Theoretical and detailed practical knowledge of a range of computer.
3. Network security technologies as well as network security tools and services.
4. Gain experience of analysing, designing, implementing and validating solutions to computer
network security challenges using common network security tools and formal methods.
5. Demonstrate knowledge of reasoning and knowledge representation for solving cybercrime
problems.
CONTENT Hours
UNIT-1
Cyber Laws 7
Network Sniffing, packet analysis, display and capture filters, Ettercap, DNS Poisoning,
ARP Poisoning, Denial of services, Vulnerability scanning, Setup network, IDS/IPS,
Router attacks, Man-in-the-middle Attack, MAC Filtering, Packet Encryption, Packet
Sniffing, Types of authentication, Attacks on WEP, WPA Encryption.
UNIT-5
Network Security 10
Text Books:
1. Sunit Belapure and Nina Godbole, “Cyber Security : Understanding Cyber-crimes and Legal
perspectives”, Wiley India Pvt Ltd,2020.
2. Atul Kahate, “Cryptography and Network Security,” Tata McGraw-Hills (Reprinted 2021).
References:
1. William Stallings; “Cryptography and Network Security: Principles and Practices”, Fifth Edition,
Prentice Hall Publication Inc., 2007.
2. Nina Godbole and Sunit Belapore; “Cyber Security: Understanding Cyber Crimes, Computer
Forensics and Legal Perspectives”, Wiley Publications, 2011.
3. Matt Bishop, “Computer Security Art and Science”, Pearson/PHI, 2002.
4. Michael E Whiteman and Herbert J Mattord; “Principles of Information Security”, Vikas
Publishing House, New Delhi, 2003.
5. Alfred J. Menezes, Paul. C. Van Oorschot, and Scott A. Vanstone “Handbook of Applied
Cryptography”, CRC press, Lib of Congress -2006
BLUEPRINT
Chapter No. of hours Total marks for which questions are to be asked
(Including bonus questions)
Unit 1 7 10
Unit 2 8 10
Unit 3 10 22
Unit 4 7 22
Unit 5 10 14
TOTAL 42 78
Maximum marks for the paper (Excluding bonus questions) =60
Course Code: CA5P2 Course Title: Cyber Security Lab
Course Objectives:
The student should be made
1. Exposed to different Cipher techniques
2. Learn to implement the algorithms DES, RSA, MD5,SHA-1
3. Learn to use security tools Cryptool, GnuPG, KF sensor, VI Strumbler.
Course Outcomes:
Here the students will be able to understand
1. An extensive, detailed and critical understanding of the concepts, issues, principles and
theories of computer network security.
2. Theoretical and detailed practical knowledge of a range of computer.
3. Network security technologies as well as network security tools and services.
4. Gain experience of analysing, designing, implementing and validating solutions to computer
network security challenges using common network security tools and formal methods.
5. Demonstrate knowledge of reasoning and knowledge representation for solving cybercrime
problems.
LIST OF EXPERIMENTS
Course Objectives
1. To recognise how the cloud has developed from the earlier technologies.
4. To recognise the rise of the cloud as the newest paradigm for computing.
1. Articulate the main concepts, key technologies, strengths and limitations of cloud computing.
2. Learn the key and enabling technologies that help in the development of cloud.
3. Develop the ability to understand and use the architecture of compute and storage cloud,
service and delivery models.
4. Explain the core issues of cloud computing such as resource management and security.
5. Be able to install and use current cloud technologies.
Content Hours
Unit – 1
Unit-2
Unit-3
Virtualization 12
Unit-4
Define the System Goals and Requirements, Protect Your Existing Data, Use
an Experienced Cloud Consultant, Know Your Application's Current
Characteristics, Remember Vendor Lock-In, Define Your Training
Requirements, Establish a Realistic Deployment Schedule, Review the Budget
Factors, Identify IT Governance Issues, Understanding Cloud Bursting.
Text Book
Cloud Computing, Kris Jamsa, Second Edition, 2022, Jones & Bartlett Publishers.
Reference Books
1. Cloud Computing: A Practical Approach, Anthony T Velte, Toby J Velte, Robert Elsenpeter,
2017, McGraw Hill Education.
2. Mastering Cloud Computing, Foundations and Application Programming, Raj Kumar Buyya,
Christen vecctiola, S Tammaraiselvi, First Edition, McGraw Hill Education
3. George Reese, "Cloud Application Architectures: Building Applications and Infrastructure in
the Cloud: Transactional Systems for EC2 and Beyond (Theory in Practice)”, O'Reilly, 2009.
4. Rittinghouse, John W., and James F. Ransome, “Cloud Computing: Implementation,
Management and Security”, CRC Press, 2017.
5. Distributed and Cloud Computing, Kai Hwang, Geoffry C. Fox, Jack J. Dongarra MK , 2012,
Elsevier.
6. Cloud Computing, Theory and Practice, Dan C Marinescu, 2013 Elsevier Inc.
BLUEPRINT
Chapter No. of hours Total marks for which questions are to be asked
(Including bonus questions)
Unit 1 10 12
Unit 2 6 10
Unit 3 12 22
Unit 4 6 14
Unit 5 8 20
TOTAL 42 78
Maximum marks for the paper (Excluding bonus questions) =60
Course Code: CAVO1 Course Title: AWS - Cloud Practitioner Essentials
Course Objectives
1. To describe what a cloud service provider (CSP) is and the value they bring to computing.
2. To identify basic security and compliance aspects of the AWS platform and the shared
security model.
3. To understand the billing, account management, and pricing models.
4. Evaluate basic or core characteristics of deploying and operating in the AWS Cloud
5. Analyse and differentiate between on-premises and cloud infrastructure
Content Hours
Unit – 1
Unit-3 8
Unit-4 8
Storage
AWS EBS, Demo: Amazon Elastic Block Store Console, Lab: Working with EBS, AWS S3,
Demo: AWS S3 Console, AWS EFS, Demo: AWS EFS Console, AWS S3 Glacier, Demo: AWS
S3 Glacier Console, Activity: Storage Technology Selection
Databases
Amazon RDS, Demo: Amazon RDS Console, Lab: Build a Database Server, Amazon
DynamoDB, Demo: Amazon DynamoDB, Amazon Redshift, Amazon Aurora, Activity:
Database case study.
UNIT 5 8
Cloud Architecture
AWS Well-Architected Framework design principles, Activity: AWS Well-Architected
Framework Design Principles, Operational excellence, Security, Reliability, Performance
efficiency, Cost optimization, Reliability & high availability, AWS Trusted Advisor,
Activity: Interpret AWS Trusted Advisor Recommendations
Automatic Scaling and Monitoring
Elastic Load Balancing, Activity: Elastic Load Balancing, Amazon CloudWatch, Activity:
Amazon CloudWatch, Amazon EC2 auto scaling, Lab: Scale & Load Balance your
Architecture
Reference Books
1. AWS Certified Cloud Practitioner Study Guide: CLF-C01 Exam, Ben Piper, David Clinton,
Sybex Publishers
2. AWS Basics: Beginner's Guides, Gordon Wong, CreateSpace Independent Publishing
3. AWS: The Beginners Guide to Amazon Web Services, Dennis Hutten, CreateSpace
Independent Publishing
4. Amazon Web Services for Dummies, Bernard Golden, John Wiley & Sons
5. Learning Amazon Web Services (AWS): A Hands-On Guide to the Fundamentals of AWS
Cloud, Mark Wilkins, Pearson Education
6. AWS Certified Cloud Practitioner (CLF-C01) Cert Guide, Anthony Sequeira, Pearson
Education
BLUEPRINT
Chapter No. of hours Total marks for which questions are to be asked
(Including bonus questions)
Unit 1 8 8
Unit 2 10 10
Unit 3 8 20
Unit 4 8 20
Unit 5 8 20
TOTAL 42 78
Maximum marks for the paper (Excluding bonus questions) =60
Course Content for VI Sem BCA
Course Objectives:
1. To inculcate in student’s different concepts of software engineering principles
2. To analyse the different categories of requirements in a software project, develop the skills
necessary to design, develop and execute software projects.
3. To comprehend the aspects of software Quality, software maintenance and various testing
strategies
4. To get an overview of the total management spectrum from the perspective of a software
project.
Course outcomes:
On completion of the course the student will be able to:
1. Understand the importance of the stages in the software life cycle and various process
models.
2. Get an in depth knowledge of the Agile framework with an emphasis on Scrum and XP.
3. Implement the design and developmental aspects using software engineering principles.
4. Will comprehend the important principles of quality and various aspects of quality
assurance and different maintenance techniques.
5. Realise the importance of software project management concepts
CONTENT HOURS
UNIT 1:
08
SOFTWARE PROCESS AND SOFTWARE PROCESS MODELS
Introduction: Software process, concepts of project and product, process, Life
cycle models: Waterfall model, spiral model, Prototyping Model, Agile frame
work: values and principles of Agile, Agile manifesto, Extreme programming,
Scrum Framework.
UNIT 2:
SOFTWARE REQUIREMENTS AND DESIGN 10
Software requirements: Functional- non-functional requirements, User
requirement, Software Requirement engineering, Feasibility studies,
Requirements elicitation and analysis, requirement validation, software
requirement specification (SRS document).
Software Design: Design Process, Design strategies, Design characteristics,
architectural design: System Structuring, control modelling, Modular
decomposition,
Software cost estimation techniques: top down, bottom-up approach,
estimation by analogy, COCOMO model.
Self-Study: Data Flow Diagrams, introduction to function oriented and object-
oriented design.
UNIT 3:
UNIT 4:
SOFTWARE QUALITY AND SOFTWARE MAINTENANCE 08
Software quality: Introduction, quality metrics, quality assurance: tasks, goals,
quality planning, quality control, software reliability and software reuse.
Software maintenance: Introduction, corrective maintenance, adaptive
maintenance, perfective maintenance.
UNIT 5:
SOFTWARE PROJECT MANAGEMENT 08
The management spectrum: The people- stake holders, team leaders, software
teams, agile teams, the product- software scope, problem decomposition, the
process- melding the product and process, process decomposition, The project,
W5HH principle, critical practices.
Text books:
1. Roger S. Pressman, “Software Engineering: A Practitioner’s Approach”, Alternate Edition,
7th Edition, McGraw Hill.
2. Ian Somerville, “Software Engineering”, 8th Edition, Pearson Publication Ltd 2012.
Reference books:
1. Software Engineering, an Engineering approach- James F. Peters.
BLUEPRINT
Chapter No. of hours Total marks for which questions are to be asked
(Including bonus questions)
Unit 1 8 12
Unit 2 10 12
Unit 3 8 22
Unit 4 8 22
Unit 5 8 10
TOTAL 42 78
Maximum marks for the paper (Excluding bonus questions) =60
Course Code: CA6223 Course Title: Artificial Intelligence and Applications.
Course Objectives
2. To assess the applicability, strengths, and weaknesses of the basic knowledge representation,
problem solving, and learning methods in solving real world problems.
2. Analyze and illustrate how search algorithms play vital role in problem solving.
3. Demonstrate knowledge of reasoning and knowledge representation for solving real world
problems.
4. Having analytical ability to apply learning techniques in solving real world problems.
Unit – 1
Unit-2
Problem Solving 10
Problem solving by Search, Well defined problems and solutions, Real
world problems, Problem space - State space, Uninformed Search
Strategies-BFS, DFS, Informed (Heuristic) Search Strategies-A* Search,
Heuristic Functions, Local Search algorithms and Optimization
Problems-Hill climbing Search, Constraint Satisfaction Problems, Means
-ends Analysis, Game playing -The mini-max algorithm, Alpha-Beta
Pruning.
Unit-3
Learning Systems 6
Unit-5
Expert Systems 8
1. Russell, S. and Norvig, P. 2015. Artificial Intelligence - A Modern Approach, 3rd edition, Prentice
Hall.
Reference Books
1. Rich ,E., Knight K and Shankar, B. Artificial Intelligence, 3rd edition, Tata Mc Graw Hill.
2. Luger, G.F. Artificial Intelligence -Structures and Strategies for Complex Problem Solving, 6th
edition, Pearson.
3. Brachman, R. and Levesque, H. Knowledge Representation and Reasoning, Morgan Kaufmann.
4. Alpaydin, E. Introduction to Machine Learning. 2nd edition, MIT Press.
5. Sutton R.S. and Barto, A.G. Reinforcement Learning: An Introduction, MIT Press.
6. Padhy, N.P.. Artificial Intelligence and Intelligent Systems, Oxford University Press.
BLUEPRINT
Chapter No. of hours Total marks for which questions are to be asked
(Including bonus questions)
Unit 1 8 8
Unit 2 10 10
Unit 3 10 22
Unit 4 6 18
Unit 5 8 20
TOTAL 42 78
Maximum marks for the paper (Excluding bonus questions) = 60
Course Code: CA6323 Course Title: Internet Of Things
Course Objectives
1. Assess the genesis and impact of IoT applications, architectures in real world.
2. Illustrate diverse methods of deploying smart objects and connect them to network and compare
different protocols for IoT.
3. Implement the tools, Arduino and Raspberry Pi in the IoT environment.
4. Infer the role of Data Analytics in IoT
1. Interpret the impact and challenges posed by IoT networks leading to new architectural models.
2. Compare and contrast the deployment of smart objects and the sensor-based technologies to
connect them to network and appraise the role of IoT protocols for efficient network
communication.
3. Solve real time IoT problems using Arduino.
4. Articulate IoT solutions using raspberry pi
5. Understand the need for Data Analytics in IoT.
Content Hours
Unit – 1
Unit-4
Introduction IoT Analytics: IoT Data and Big Data - Challenges of IoT Analytics
Applications – IoT Analytics Lifecycle and Techniques, IoT, Cloud and Big Data
Integration for IoT Analytics: Cloud-based IoT Platform, Data Analytics for IoT ,
Development Tools for IoT Analytics Applications: VITAL Architecture for IoT Analytics
Applications
Text Books:
1. David Hanes, Gonzalo Salgueiro, Patrick Grossetete, Robert Barton, Jerome Henry, “IoT
Fundamentals: Networking Technologies, Protocols, and Use Cases for the Internet of Things”,
1stEdition, Pearson Education (Cisco Press Indian Reprint).2017 (Unit 1 and Unit 2)
2. Srinivasa K G, “Internet of Things”, CENGAGE Leaning India, 2017 (Unit 3 and Unit 4)
3. John Soldatos “Building Blocks for IoT Analytics Internet-of-Things Analytics”, River
Publishers, 2017.(Unit 5)
Reference Books
BLUEPRINT
Chapter No. of hours Total marks for which questions are to be asked
(Including bonus questions)
Unit 1 8 14
Unit 2 9 10
Unit 3 10 22
Unit 4 9 22
Unit 5 6 10
TOTAL 42 78
Maximum marks for the paper (Excluding bonus questions) = 60
Course Code: CADE6423 Course Title: Mobile Application
Course Credits: 03 Hours/Week: 03
Total Contact Hours: 42 Formative Assessment Marks: 40
Exam Marks: 60 Exam Duration: 3 Hrs
Course Objectives:
1. To create robust mobile applications and learn how to integrate them with other services.
2. To design intuitive, reliable mobile apps using the android services and components.
3. Develop user interface and multimedia that works with different mobile screens.
4. Implementing SQLite for the back end data storage.
Course Outcomes:
Content Hours
Unit – 1
6
Introduction to Android
Introduction to Android, Application in Android, Android Operating System, Android
versions, Features of Android, Android Architecture, Android Devices and History of
Android.
Android Apps, In-Built Applications, Prerequisites, Android Environment Setup,
Downloading JDK, Setting Path of JDK, Installation of Android Studio in Mac, Linux
and Windows, setting up ADT Plug In, Creating First Android Application,
Introduction Android Studio Vs Eclipse.
Unit-2
10
Fundamentals of Android Studio and Layouts
Android Studio Fundamentals and Android Studio IDE, Viewing and adding Java,
Compilation and Runtime, Creating basic first Project, Android Components, Android
Intent, Types of Intent, Android Services, Types of Android Services, Broadcast
Receivers, Android Content Provider, Notification, Types of Views, Overview of
Android Widgets. Layout, Understanding of Constraint and Linear Layout,
Understanding of Frame and Relative Layout, Image View, Demonstration of
Animation (any 5)
Unit-3
6
Classifying the Activities and UI Elements
Starting and setting Activity, Android Lifecycle, Intent and its types, implementing
the Intent.
Passing data to Multiple Activity, Introduction to Themes and Colors, Working with
Themes and Colors - Creating Project, Changing values of defined colors, Theme
Colors, Styles, Menu, Fragments, Working with Fragments Activity, Introduction to
Classes, Long Running Task, the Long Running Tasks.
Unit-4
10
Shared Preference and Internal Storage
Introduction to Shared Preference, Overview of Operating Mode, Introduction to
Editor, Methods, Storing Data, Retrieving Data, Clear and Delete Working with
Shared Preference - xml File, Main Activity
Internal Storage, Difference between Shared Preference and Internal Storage, Read
and Write data to Internal Storage, Syntax to Write a text file and Reading a text file,
example of Internal Storage
Unit-5
Advanced Android Features and Media Functions 10
Controlling Audio, Audio Volume Seeking, Custom Action Bar, Customizing Action
Bar, Alert Dialog, Adding Alert Dialog, List View, Timer, Showing and Hiding UI
Element, Try and Catch Block.
Implementing Map Activity, SQLite Database, Implementing and working with SQLite
Database
SQLite Advance, Basics of Kotlin, Difference between Kotlin and Java, Exploring
Kotlin Language.
Text Books:
1. Learn Java for Android Development (2nd edition), Author: Jeff Friesen, Publisher: Apress,
Published Date: February 20th 2013.
2. Android Programming: The Big Nerd Ranch Guide, Author: Bill Phillips, Brian Hardy,
Publisher: Big Nerd Ranch Guides, Published Date: April 07th 2013
3. Programming Android: Java Programming for the New Generation of Mobile , Devices (2nd
Edition), Author: Zigurd Mednieks, Laird Dornin, G. Blake Meike, Masumi Nakamura,
Publisher: O'Reilly Media, Published Date: October 19th 2012.
References:
1. Android Programming THE BIG NERD RANCH GUIDE BILL PHILLIPS & BRIAN HARDY
https://ptgmedia.pearsoncmg.com/images/9780321804334/samplepages/0321804333.pdf
Chapter No. of hours Total marks for which questions are to be asked
(Including bonus questions)
Unit 1 6 10
Unit 2 10 12
Unit 3 6 12
Unit 4 10 22
Unit 5 10 22
TOTAL 42 78
Maximum marks for the paper (Excluding bonus questions) = 60
Course Code: CA6P1 Course Title: Mobile Applications Lab
Course Objectives:
Course Outcomes:
Students can acquire the following skills after completing the course:
Program List:
1. Create an android app to display various android life cycle phases’ use both log cat
and toast to display the state of an Activity. Let the Activity contain Text views and
image view.
2. Create a login application to verify user name and password. On successful login,
redirect to another activity that has a textview to display "welcome user" with logout
button. On click of logout button, a dialog should appear with ok and cancel buttons.
On click of oK button, navigate back to the login activity and on click of cancel button,
stay on the same activity.
3. Create an android app with first activity having edit-text and send button. On click of
send button, use explicit intent to send the text within edit-text to a second activity
and displayed within text-view. Also include a validation where the edit-text can
accept only the text.
6. Create an app that uses radio button group which calculates discount on shopping
bill amount. Use ediitext to enter bill amount and select one of three radio buttons to
determine a discount for 20, 25, or 30 percent. The discount is calculated upon
selection of one of the buttons and displayed in a textview control.
7. Use linear layout to create a simple application that will take the contents of a
predefined textview and use a button to cause the application to take that text,
convert it to uppercase, colour, font family and size and display it in an edittext field.
8. When working with edittext controls on the screen, create an application to respond
to a particular keystroke rather than requiring the user to touch a button using key
event. Use the Keystroke that can print a profile.
9. Create an application that uses table layout with textview, edittext and buttons. Also
implement customized styles.xml file within res/values directory, to style text of
textview control.
10. Create an application to perform the operations of create, insert, delete, view and
update using SQlite database. The front end should include registration details.
12. Implement 3 buttons to start, pause and stop the audio and
Video player. Use the raw folder to include the sources.
13. Develop an app that can show the connectivity status and boot
Status as soon the app starts. Implement broad cast receiver and
Set the manifest file.
Course Objective:
1. Identify real world problems and challenges that need IT based solutions.
2. Demonstrate an ability to work in teams.
3. Improve the team building, communication and management skills of the students.
4. Use all concepts of IT in creating a solution for a problem.
5. Report and present the findings of the study conducted in the preferred domain.
Course Outcomes:
Outcomes of the Major Project:
Course Description
This course introduces Power BI, a business analytics service by Microsoft that enables users to
visualize and analyse data from various sources. The course covers basic concepts of data analysis,
data visualization, and data modeling in Power BI. Students will learn to create interactive reports,
dashboards, and visualizations using Power BI Desktop.
Learning Outcomes
Understand the basic concepts of data analysis, data visualization, and data modeling
Navigate the Power BI Desktop interface.
Import data from various sources into Power BI
Create basic data models and relationships between tables.
Use DAX (Data Analysis Expressions) to create calculated columns and measures.
Create interactive reports and visualizations using various chart types, tables, and other
visualization tools.
Design and publish dashboards for stakeholders.
Use Power BI service to share dashboards and reports with others.
Understand the security and governance considerations in using Power BI.
Course Outcome
CO4: Understanding and applying data modelling and visualisation techniques using the
advanced features of Power BI
Introduction to dashboards
Designing and creating dashboards in Power BI
Sharing and collaborating on dashboards
REFERENCE BOOKS: