Bachelor of Science – Computer Science

BOS in Computer Science Committee Members

Dr. Kusuma Kumari B.M
MCA Coordinator & Assistant Professor
1. Chairperson
Department of Studies and Research in Computer Applications
Tumkur University, Tumakuru
Dr. Ramani. R
Assistant Professor and HOD
2.
Department of Computer Science Member
University College of Science, Tumkur University, Tumakuru
Dr. Chandrali Baishya
Associate Professor
3. Member
Department of Studies and Research in Mathematics
Tumkur University, Tumakuru
Dr. Prakash B.R
Assistant Professor and HOD
4. Member
Department of Computer Science
Government First Grade College, Tipatur.
Sri. Mohan Kumar N
Assistant Professor and HOD
5. Member
Department of Computer Science
Y.E.R Government First Grade College, Pavagada.
Capt. Ramalinga Reddy S
6. Assistant Professor, Department of Computer Science Member
Sri Siddaganga Arts and Commerce Evening College Tumkur.

Dr. Manjunath S
7 Assistant Professor, Department of Computer Science Member
Y.E.R Government First Grade College, Pavagada.
Dr. Nagamani H.S
8 Associate Professor,Department of Computer Science Member
Maharani Claster University, Bengaluru.
Dr. Asha Gowda Karegowda
9 Associate Professor, Department of MCA Member
Siddaganga Institute of Technology, Tumkur.

Dr. Sumathi R Gowda

10 Assistant Professor , Department of Computer Science, Member
Karnataka State Open University, Muktha Gangotri, Mysore.

Dr. Haridas S.
11. Associate Professor, Department of Computer Science Member
Government First Grade College, Tumkur.

BOS in Computer Science Page 1

 Bachelor of Science – Computer Science

SEMESTER – III

Instruction Duration Marks

Sl. No. of
Paper Title of the Paper Hrs. per of the Internal Semester
No Credits
Week Exam. Assessment End Exam. Total

Java
1 BSCT 301 4 4 3 Hrs. 20 80 100
Programming
Java Programming
2 BSCP 302 4 2 3 Hrs. 10 40 50
Lab
TOTAL 6 150
If student select Elective-1 Paper in Computer Science:
Elective – 1 (Choose any one)
BSCT 303 A System Software
BSCT 303 B Computer
Architecture
3 BSCT 303 C Mobile App 3 3 3 Hrs. 20 80 100
Development
BSCT 303 D Probability and
Statistics
TOTAL 9 250

NOTE: Theory: 1 Hr. = 1 Credit. Practical: 2 Hrs. = 1 Credit

BSCT: BSc Core Paper Theory

BSCP: BSc Core Paper Practical

BOS in Computer Science Page 2

 Bachelor of Science – Computer Science
SEMESTER – IV

Instruction Duration Marks

Sl. No. of
Paper Title of the Paper Hrs. per of the Internal Semester
No Credits
Week Exam. Assessment End Exam. Total
Database
1 BSCT 401 Management 4 4 3 Hrs. 20 80 100
System
Database
2 BSCP 402 Management 4 2 3 Hrs. 10 40 50
System Lab
Total 6 150
If student select Elective-1 Paper in Computer Science:

Elective – 2 (Choose any one)

BSCT 403 A Cloud Computing

BSCT 403 B Cyber Security

3 Mobile 3 3 3 Hrs. 20 80 100
BSCT 403 C
Computing
BSCT 403 D Internet of Things
TOTAL 9 250

NOTE: Theory: 1 Hr. = 1 Credit. Practical: 2 Hrs. = 1 Credit

BSCT: BSc Core Paper Theory
BSCP: BSc Core Paper Practical

BOS in Computer Science Page 3

 Bachelor of Science – Computer Science
Third Semester BSc
Subject Name: Java Programming
Subject Code BSCT 301 CIE Marks 20
No of Hours/Week: 4 SEE Marks 80

Total Hours: 60 Credits 4

COURSE OBJECTIVES:
1. To introduce the object-oriented programming concepts.
2. To understand object-oriented programming concepts, and apply them in solving problems.
3. To introduce the principles of inheritance and polymorphism; and demonstrate how they
relate to the design of abstract classes
4. To introduce the implementation of packages and interfaces
5. To introduce the concepts of exception handling and multithreading.
6. To introduce the design of Graphical User Interface using applets and swing controls.

COURSE OUTCOMES:
After completing this course satisfactorily, a student will be able to:
1. Understand the features of Java and the architecture of JVM
2. Write, compile, and execute Java programs that may include basic data types and control
flow constructs and how type casting is done
3. Identify classes, objects, members of a class and relationships among them needed for a
specific problem and demonstrate the concepts of polymorphism and inheritance
4. The students will be able to demonstrate programs based on interfaces and threads and
explain the benefits of JAVA’s Exceptional handling mechanism compared to other
Programming Language
5. Write, compile, execute Java programs that include GUIs and event driven programming
and also programs based on files

Introduction to Java Hours 10

History of java, Features of java, JDK Environment & tools like (java, javac,
appletviewer, javadoc, jdb) OOPs Concepts Class, Abstraction, Encapsulation,
Unit 1 Inheritance, Polymorphism, Difference between C and JAVA, Structure of java
program, Data types, Variables, Operators, Instance of operator, Keywords. Input
and output statements-scanner class.
Objects and Classes Hours 16
Control Statements: if conditions, switch-case; looping-while, for, do-while, jumping
statements-break, continue and exit. Array-Single and Multi-dimensional array.
Unit 2 Basics of objects and classes in java, Visibility modifiers, Methods and objects,
Constructors, Finalizer, Inbuilt classes like String, Character, String Buffer, this
reference, garbage collection, Function Overloading
BOS in Computer Science Page 4
 Bachelor of Science – Computer Science
Inheritance and Polymorphism Hours 10
Inheritance: Definition, types, final, super and static keyword, Interfaces in java.
Unit 3 Overriding function. Polymorphism, Dynamic binding, Casting objects, Abstract
class, Exception handling: Exception handling in Java.

Packages and Mulit-threading Hours 09

Packages, Access Protection, Importing Packages.
Unit 4
Multi-Threaded Programming: the classes threadable; Extending threads;
Implementing runnable; Synchronization; Changing state of the thread;
Applet & IO Hours 15
Introduction, Applet Life cycle - Creating applet - Applet tag; Applet Classes - Color
- Graphics - Font;
Unit 5 AWT -Components and container used in AWT; Layout managers; Listeners and
Adapter classes; Event Delegation model;
I/O programming: Text and Binary I/O, Binary I/O classes, Object I/O, Random
Access Files.

TEXT BOOKS:
1. Programming with Java, By E Balagurusamy – A Primer, Fourth Edition, Tata McGraw
Hill Education Private Limited.
2. Core Java Volume I – Fundamentals, By Cay S. Horstmann, Prentice Hall
3. Object Oriented Programming with Java: Somashekara, M.T., Guru, D.S., Manjunatha, K.S

REFERENCE BOOKS:
1. Java 2 - The Complete Reference – McGraw Hill publication.
2. Java - The Complete Reference, 7th Edition, By Herbert Schildt– McGraw Hill
publication.

BOS in Computer Science Page 5

 Bachelor of Science – Computer Science

Third Semester BSc

Subject Name: Java Programming Lab
Subject Code BSCP 302 CIE Marks 10
No of Hours/Week: 4 SEE Marks 40

Total Hours: 60 Credits 2

LIST OF PRACTICAL PROGRAMS

PART A:
1. Write a java program that displays roots of a quadratic equation ax2+bx+c=0 , calculate the
discriminate D and based on the value of D, Describe the nature of root (use nested if
statement).
2. Write a program to find GCD of two integers.
3. Write a Java program for sorting a given list of names in ascending order.
4. Write a java program to demonstrate creation and accessing of objects and methods.
5. Write a java program to illustrate use of constructors overloading.
6. Write a java program to illustrate use of super keyword.
7. Write a java program to illustrate use of static member and static function,
8. Write a Java program to demonstrate all the concepts of inheritance
9. rite a java program to differentiate Abstract class and interface class.
10. Write a Java Program to demonstrate String Methods.

PART B:
1. Write a Java Program for creation of Java Built-in Exceptions.
2. Write a Java Program for creation of User Defined Exceptions.
3. Write a java program for creation of multi-threading concept.
4. Write a java program to create user defined package.
5. Program which creates and displays a message on the window
6. Program to draw several shapes in the created window
7. Create a simple applet which reveals the personal information of yours.
8. Create a frame which displays your personal details with respect to a button click
9. Develop an Applet that receives an integer in one text field & compute its factorial value &
returns it in another text filed when the button “Compute” is clicked.
10. Write a java program to connect to database using JDBC to perform CRUD operations

BOS in Computer Science Page 6

 Bachelor of Science – Computer Science
Third Semester
Elective - 1
Subject Name: System Software
Subject code BSCT 303 A CIE Marks 20

No of Hours/Week: 3 SEE Marks 80

Total Hours: 45 Credits 3

COURSE OBJECTIVES:
1. Understand the role and structure of system software and differentiate it from application software.
2. Explore language processors, their functions, and development tools used in language processing.
3. Gain knowledge of internal data structures like search and allocation data structures used in
language processing.
4. Identify various software tools such as editors, debug monitors, and user interface tools that assist
in software development.
5. Comprehend the concepts and design of assemblers, including single-pass and two-pass assembler
mechanisms.

COURSE OUTCOMES:
At the end of the course students will be able to:
1. Explain the fundamental concepts of system software including language processing activities and
language processor tools.
2. Describe and apply various data structures used in language processing, such as search and
allocation structures.
3. Demonstrate the use of software tools like editors, debuggers, and programming environments in
software development.
4. Understand the elements and structure of assemblers, including design and implementation of
single-pass and two-pass assemblers.
5. Analyze macro definitions and expansions, and design a macro processor with advanced features.

Introduction to System Software and

8 Hours
software tools
Language Processors: Introduction, Language Processing Activities,
Fundamentals of Language Processing & Language, Specification, Language
Unit 1 Processor Development Tools.
Data Structures for Language Processing: Search Data structures, Allocation Data
Structures, Software Tools: Software Tools for Program Development, Editors,
Debug Monitors, Programming Environments, User Interfaces.

BOS in Computer Science Page 7

 Bachelor of Science – Computer Science
Assemblers 8 Hours
Elements of Assembly Language Programming, A Simple Assembly Scheme,
Unit 2
Pass Structure of Assemblers, Design of a Two Pass Assembler, A single pass
Assembler for IBM PC.

Macros and Macro Processors 9 Hours

Unit 3 Macro Definition and Call, Macro Expansion, Nested Macro Calls, Advanced
Macro Facilities, Design of a Macro Preprocessor.
Interpreters and Introduction of Compilers 8 Hours
Interpreters: Use and overview of interpreters, Pure and impure interpreters,
Unit 4
Phases of the Compiler, Introduction of scanning and parsing, Aspects of
compilation.
Linkers and Loaders 8 Hours
Introduction to linkers, Relocation and Linking Concepts, Design of a Linker,
Unit 5
Self-Relocating Programs, A Linker for MS-DOS, Linking for Overlays and
Loaders.

TEXT BOOK:

1. D. M. Dhamdhere, “Systems Programming and Operating Systems”, Second Revised Edition,

Tata McGraw-Hill, 1999.

REFERENCE BOOKS:
1. Leland L. Beck, “System Software – An Introduction to Systems Programming”, 3rd Edition,
Pearson Education Asia, 2000.
2. Santanu Chattopadhyay, “System Software”, Prentice-Hall India, 2007

BOS in Computer Science Page 8

 Bachelor of Science – Computer Science
Third Semester
Elective – 1
Subject Name: Computer Architecture
Subject code BSCT 303 B CIE Marks 20

No of Hours/Week: 3 SEE Marks 80

Total Hours: 45 Credits 3

COURSE OBJECTIVES:

1. This course introduces the students to the fundamental concepts of digital computer
organization, design and architecture.
2. It aims to develop a basic understanding of the building blocks of the computer system and
highlights how these blocks are organized together to architect a digital computer system.

COURSE OUTCOMES:
On successful completion of the course, students will be able to:

1. Design and Simplify Combinational and sequential circuits using basic building blocks.
2. Represent data in binary form, convert numeric data between different number systems and
perform arithmetic operations in binary.
3. Explain instruction cycle, pipelining and interrupts.
4. Explain data communication between CPU, memory and I/O devices.
5. Simulate the design of a basic computer using a software tool.

Digital Logic Circuits 8 Hours

Logic Gates, Truth Tables, Boolean Algebra, Digital Circuits, Combinational

Unit 1 Circuits, Introduction to Sequential Circuits, Circuit Simplification using

Karnaugh Map, Don’t Care Conditions, Flip-Flops, Characteristic Tables,
Excitation Table.
Unit 2 Digital Components (Fundamental building blocks) 10 Hours
Designing of combinational circuits- Half Adder, Full Adder, Decoders,
Encoders, Multiplexers, Registers and Memory (RAM, ROM and their types),
Arithmetic Microoperations, Binary Adder, Binary Adder-Subtractor.

Unit 3 Data Representation and Basic Computer Arithmetic 8 Hours

BOS in Computer Science Page 9

 Bachelor of Science – Computer Science
Number System, r and (r-1)’s Complements, data representation and arithmetic
operations.
Basic Computer Organization and Design 8 Hours
Bus organization, Micro programmed vs Hardwired Control, Instruction Codes,
Unit 4 Instruction Format, Instruction Cycle, Instruction pipelining, Memory Reference,
Register Reference and Input Output Instructions, Program Interrupt and Interrupt
Cycle.
Processors 11 Hours
General register organization, Stack Organization, Addressing Modes, Overview of
Reduced Instruction Set Computer (RISC), Complex Instruction Set Computer (CISC),
Unit 5 Multicore processor and Graphics Processing Unit (GPU)
Memory hierarchy (main, cache and auxiliary memory), Input-Output Interface,
Modes of Transfer: Programmed I/O, Interrupt initiated I/O, Direct memory
access.

TEXT BOOKS:
1. David A. Patterson and John L. Hennessy. “Computer Organization and Design: The
Hardware/Software interface”, 5 th edition, Elsevier, 2012.
2. Mano, M. Computer System Architecture, 3 rd edition, Pearson Education, 1993.

REFERENCE BOOKS:
1. Mano, M. Digital Design, Pearson Education Asia, 1995.
th
2. Null, L., & Lobur, J. The Essentials of Computer Organization and Architecture. 5 edition.
(Reprint) Jones and Bartlett Learning, 2018.

3. Stallings, W. Computer Organization and Architecture Designing for Performance 8 th edition,

Prentice Hall of India, 2010.

BOS in Computer Science Page 10

 Bachelor of Science – Computer Science

Third Semester
Subject Name: Mobile Application Development
Subject code BSCT 303 C CIE Marks 20

No of Hours/Week: 3 SEE Marks 80

Total Hours: 45 Credits 3

COURSE OBJECTIVES:

1. To provide foundational understanding of the Android development environment, including

the setup of Android Studio, AVDs, and essential tools for building applications.
2. To teach the structure and core components of Android applications, such as activities, services,
intents, and permissions, with emphasis on Android app design principles.
3. To enable hands-on experience with Android APIs, UI/UX components, and data handling
techniques using SQLite, Content Providers, and Web APIs for real-world deployment.

COURSE OUTCOMES:

On successful completion of the course, students will be able to:

1. Develop and deploy basic Android applications using Android Studio with proper setup of
layouts, permissions, and manifest settings.
2. Design responsive and user-friendly Android user interfaces, implement animations, and
manage multiple device configurations and resources.
3. Integrate core Android APIs, including database management, data sharing, and networking
features, to create fully functional mobile applications for real-world use.

BOS in Computer Science Page 11

 Bachelor of Science – Computer Science

Android OS Design and Features

8 Hours
Introduction to Android development framework:
Unit 1 Key SDK features, Installing and running applications using Android Studio
,Creating Android Virtual Devices (AVDs),Types of Android applications,
Best practices in Android programming, Common Android tools, Building
your first Android application
Introduction to Android development
Unit 2 10 Hours
framework
Important Android terms , Understanding Application Context ,Core
components: Activities, Services, and Intents , Receiving and broadcasting
intents, Android Manifest File and its main settings, Using Intents and Filters
,Working with Permissions.

Android User Interface (UI) Design

10 Hours
Essentials
Unit 3 UI screen elements overview, Designing layouts for different screen sizes
,Working with various UI components, Using drawing tools and animations
in UI, Managing Android application resources, Testing and publishing
Android apps, Using preferences and handling multiple resource types
Using Common Android APIs 10 Hours
Unit 4 Data and storage APIs in Android, Using SQLite database, Sharing data
between apps with Content Providers, Basics of Android Networking APIs,
Using Web APIs in Android apps ,Deploying applications to the real world
Consuming Web Services 7 Hours
Unit 5 Consuming Web Services Using HTTP-Consuming JSON Services- Creating
Your Own Services - Binding Activities to Services -Understanding
Threading.

TEXT BOOKS:
1. Lauren Darcey & Shane Conder, Android Wireless Application Development, Pearson
Education, 2nd Ed. (2011).
2. Reto Meier, Professional Android 2 Application Development, Wiley India Pvt. Ltd.

REFERENCE BOOKS:
1. Barry Burd, Android Application Development All-in-One for Dummies, Edition I.
2. Wei-Meng Lee, Beginning Android 4 Application Development, Wiley India (Wrox), 2013.

BOS in Computer Science Page 12

 Bachelor of Science – Computer Science

Third Semester
Elective – 1
Subject Name: Probability and Statistics
Subject code BSCT 303 D CIE Marks 20

No of Hours/Week: 3 SEE Marks 80

Total Hours: 45 Credits 3

COURSE OBJECTIVES:
1. This course is designed to introduce the historical development of statistics- presentation of
data descriptive measures and fitting mathematical curves to the data.
2. This course also introduces measurement of the relationship of quantitative and qualitative
data and the concept of probability.
3. This course will enable students to understand and summarize the data, understand and apply
the descriptive measures and probability for data analysis, implement theoretical concepts of
descriptive measures and probability, study the relationship between variables.

COURSE OUTCOMES:
After completing this course satisfactorily, a student will be able to:
1. Demonstrate the history of statistics Identify the type of data and present the data in various
forms and summarize it using descriptive statistics.
2. Understand and apply the statistical concept of correlation, association, regression analysis
and infer its results.
3. Understand and apply the concept of theory and its applications.

Introduction and Analysis of Univariate data Hours 10

Basic statistical concepts: Origin and development of Statistics- Scope-
limitations and misuse of statistics. Types of data: primary and secondary data-
quantitative and qualitative data. Scales of Measurement: nominal ordinal-ratio
and interval. Discrete and continuous data variables. Construction of frequency
distribution, stem and leaf display.
Unit 1 Presentation of data by tables: construction of frequency distributions for
discrete and continuous data.
Graphical presentation of data -histograms and cumulative frequency curves.
Measure of central tendency—Arithmetic mean, median and mode—their
properties
Partition values—quartiles, deciles and percentiles.
Measures of dispersion—Range, quartile deviation and standard deviation and
their relative measures. Skewness—concept and measures, Kurtosis—concept.
Unit 2 Correlation and Regression Hours 13
Correlation: Scatter plot- Karl Pearson coefficient of correlation- Spearman's rank

BOS in Computer Science Page 13

 Bachelor of Science – Computer Science
correlation
coefficient- multiple and partial correlations (for 3 variates only).
Regression: Concept of errors Principles of Least Square- Simple linear regression
and its properties.
Basics of Probability Hours 8
Basic terminology-random experiment, sample space, event, mutually exclusive
Unit 3 events, equally likely events.
Definition of probability –Classical, empirical and axiomatic approaches.
properties of probability.
Theorems on probability- conditional probability and independent events- Laws
of total probability- Baye’s theorem and its applications.
Random variables and Probability distributions Hours 15
Definition of a random variable—discrete and continuous random variables—
probability mass function and probability density function. Distribution function
and its properties.
Unit 4
Mean and variance of a random variable.
Definition of a bivariate probability distribution and marginal probability
functions. Discrete probability distributions—Binomial and Poisson
distributions Continuous distributions—Normal distribution—computation of
probabilities.
Applied Statistics Hours 14
Formation of Hypothesis, Test of significance: Large sample test for single
proportion, Difference of proportions, Single mean, Difference of means,
Unit 5 and Difference of standard deviations.
Test of significance for small samples:
t- Test for single mean, difference of means, t-test for correlation
coefficients, F- test for ratio of variances, Chi-square test for goodness of
fit and independence of attributes.

TEXT BOOKS:

1. S.C. Gupta and V.K. Kapoor - Fundamentals of Mathematical Statistics- 12th ed.- Sultan
Chand & Sons- New Delhi- 2020.
2. P. Mukhopadhyay.- Mathematical Statistics-3rd ed.- Books and Allied (P) Ltd- Kolkata2018.

REFERENCE BOOKS:
1. S. Ross, A First Course in Probability, 6th Ed., Pearson Education India.
2. W. Feller, An Introduction to Probability Theory and its Applications, Vol. 1, Wiley.
3. D. C. Montgomery and G. C. Runger, Applied Statistics and Probability for Engineers,
Wiley.
4. J. L. Devore, Probability and Statistics for Engineering and the Sciences, Cengage
Learning.

BOS in Computer Science Page 14

 Bachelor of Science – Computer Science
Fourth Semester
Subject Name: Database Management System
Subject code BSCT 401 CIE Marks 20

No of Hours/Week: 4 SEE Marks 80

Total Hours: 60 Credits 4

COURSE OBJECTIVES:
1. To understand the basic concepts and the applications of database systems.
2. To understand the design of database.
3. To understand the relational database design principles
4. To Master the basics of SQL and construct queries using SQL
5. To become familiar with the basic issues of transaction processing and concurrency
control

COURSE OUTCOMES:
At the end of the course students will be able to:
1. Explain the various database concepts and the need for database systems.
2. Identify and define database objects, enforce integrity constraints on a database using
DBMS.
3. Demonstrate a Data model and Schemas in RDBMS.
4. Identify entities and relationships and draw ER diagram for a given real-world problem.
5. Convert an ER diagram to a database schema and deduce it to the desired normal form.
6. Formulate queries in Relational Algebra, Structured Query Language (SQL) for database
manipulation.
7. Explain the transaction processing and concurrency control techniques.

Database Architecture Hours 10

Introduction to Database system applications. Characteristics and Purpose of
Unit 1 database approach. People associated with Database system. Data models.
Database schema. Database architecture. Data independence. Database
languages, interfaces, and classification of DBMS.
Unit 2 E-R Model Hours 12
Entity-Relationship modeling: E – R Model Concepts: Entity, Entity types, Entity
sets, Attributes, Types of attributes, key attribute, and domain of an attribute.
Relationships between the entities. Relationship types, roles and structural
constraints, degree and cardinality ratio of a relationship. Weak entity types, E -R
diagram.
Relational Data Model Hours 16
Relational model concepts. Characteristics of relations. Relational model
constraints: Domain constrains, key constraints, primary & foreign key
Unit 3
constraints, integrity constraints and null values.
Relational Algebra: Selection, projection, set operations, renaming, Joins
,Division, Relational calculus: Tuple relational Calculus, Domain relational
calculus.

BOS in Computer Science Page 15

 Bachelor of Science – Computer Science
Introduction to SQL: Overview of SQL, Data types, DDL, DML, DCL, TCL,
Structure of SQL queries, Nested Sub queries, Joins, Views, Index and Triggers..
Introduction to PL/SQL & programming of above operations in PL/SQL.
Data Normalization Hours 12
Anomalies in relational database design. Decomposition. Functional dependencies.
Unit 4 Normalization. First normal form, Second normal form, Third normal form. Boyce-
Codd normal form.
Higher Normal Forms - Introduction, Multi-valued dependencies and Fourth
normal form, Join dependencies and Fifth normal form
Query Processing Transaction Management Hours 10
Introduction Transaction Processing. Single user & multiuser systems.
Unit 5 Transactions: read & write operations. Need of concurrency control: The lost
update problem, Dirty read problem. Types of failures. Transaction states.
Desirable propeties (ACID properties) of Transactions. Concurrency Control
Techniques: Locks and Time stamp Ordering.

TEXT BOOKS:
1. Fundamentals of Database Systems, Ramez Elamassri, Shankant B. Navathe, 7th Edition,
Pearson, 2015.
2. Database Systems Concepts, Abraham Silberschatz, Henry Korth, [Link], 6th Edition,
McGraw Hill, 2010.

REFERENCE BOOKS:
1. An Introduction to Database Systems, Bipin Desai, Galgotia Publications, 2010.
2. Introduction to Database System, C J Date, Pearson, 1999.
3. Database Management Systems, Raghu Rama Krishnan and Johannes Gehrke, 3rd Edition,
McGraw Hill, 2002

BOS in Computer Science Page 16

 Bachelor of Science – Computer Science

Fourth Semester
Subject Name: Database Management System Lab
Subject code BSCP 402 CIE Marks 10

No of Hours/Week: 4 SEE Marks 40

Total Hours: 60 Credits 2

LIST OF LAB PROGRAMS

PART A
1. Execute DDL Commands
Consider the table:
STUDENT (regno number, name varchar2, dob date, marks number)
a) Create the above table with suitable constraints.
b) Remove the existing attribute marks from the table.
c) Change the data type of regno from number to varchar2.
d) Add a new attribute phno to the existing table.
e) Insert 5 tuples into the table.
f) Display the tuples in table

2. Execute DML Commands

Consider the table:
LIBRARY(bid number, title varchar2, author varchar2, publisher varchar2, yearof_pub number, price
number)
a) create the above table.
b) Enter 5 tuples into the table.
c) Display all the tuples from the table.
d) Display different publishers from table.
e) Update price of all books with 5% GST amount.
f) Delete the details of book published by a specific Author.
e) Arrange the tuples in the alphabetical order of book title.
f) List the details of all books whose price range between 100 rs and 300 rs.

3. Execute DQL and group functions

Consider the table EMPLOYEE (EmpNo, EmpName, Dept, Salary, DOJ, Branch)
Perform the following operations:
a) Create the table
b) Insert 5 tuples into the table
c) Retrieve average salary of all employee

BOS in Computer Science Page 17

 Bachelor of Science – Computer Science
d) Retrieve number of employees
e) Retrieve distinct number of employee
f) Retrieve total salary of employee group by employee name and count similar names
g) Display details of employees whose salary is greater than 50000.

4. Demonstrate the use of TCL and DCL Commands:

TCL:
1. Create a table accounts ( account_id, account_holder_name, balance)
2. Insert some sample data into the accounts table.
3. Start a transaction and perform the following operations:
- Debit 1000 from account_id 1.
- Credit 1000 to account_id 2.
4. Use the COMMIT command to save the changes.
5. Start a new transaction and perform the following operations:
- Debit 500 from account_id 1.
- Credit 500 to account_id 3.
6. Use the ROLLBACK command to undo the changes.
7. Create the save point and execute ROLLBACK TO previously created save point.

DCL:
1. Create a new user called user1 with a password.
2. Grant SELECT, INSERT, and UPDATE privileges on the accounts table to user1.
3. Login as user1 and perform the following operations:
- Select data from the accounts table.
- Insert a new row into the accounts table.
- Update an existing row in the accounts table.
4. Revoke the INSERT privilege from user1.
5. Login as user1 and try to insert a new row into the accounts table.

5. Implement the Nested Queries.

An INVENTORY database has the following table.
ITEMS(itemcode number, name varchar2, price number)
PURCHASE(itemcode number, qty number)
a) Create the tables with the above attributes.
b) Enter 5 tuples into the tables.
c) List the items purchased.
d) List the items which are not purchased by anyone.

6. Implement Join operations in SQL

The COMPANY database consists of the tables:
EMPLOYEE (SSN, Name, Address, Sex, Salary, SuperSSN, DNo)
DEPARTMENT (DNo, DName, MgrSSN, MgrStartDate)
Create tables, Insert 5 tuples each and perform the following

BOS in Computer Science Page 18

 Bachelor of Science – Computer Science
a) Give a 10 percent raise in salary for all employees working in the ‘Research’ Department.
b) Retrieve the name of each employee Controlled by department number 5 (use EXISTS
operator).
c) Retrieve the name of each dept and number of employees working in each department
which has at least 2 employees
d) Retrieve the name of employees and their department name (using NATURAL JOIN)
e) Perform EQUI join operation on the given tables.
f) Perform NON-EQUI join operation on the given tables.
g) Perform OUTER join operations on the given tables.

7. Create the following tables:

Passenger(PassportID, Name, Age, Sex, Address) and
Reservation(PNRno, JourneyDate, Noofseats, Address, ContactNo.)
Query the tables using ANY, ALL, IN, Exists, NOT EXISTS, UNION, INTERSECT etc.,

1. Display unique PNR_NO of all passengers

2. Display all the names of male passengers.
3. Display the ticket numbers and names of all the passengers.
4. Find the ticket numbers of the passengers whose name start with ‘r’ and ends with ‘h’.
5. Find the names of Passengers whose age is between 30 and 45.
6. Display all the passengers names beginning with ‘A’.
7. Display the sorted list of Passengers names
8. Create views for a particular table
The RAILWAY RESERVATION SYSTEM database consists of the tables:
TRAIN(TrainNo, TrainName, StartPlace, Destination)
AVAILABILITY(TrainNo, Class,StartPlace,Destination,No_of_seats)
a) Create view sleeper to display train no, start place, destination which have sleeper class and perform
the following
• insert new record
• update destination=’Manglore’ where train no=’RJD16’
• delete a record which have train no=’KKE55’
b) Create view details to display train no, train name, class
c) Create view total_seats to display train number, start place, use count function to no of seats , group
by start place and perform the following
• insert new record
• update start place=’Hubli’ where train no=’JNS8’
• delete last row of the view
d) Rename view sleeper to class
e) Delete view details

BOS in Computer Science Page 19

 Bachelor of Science – Computer Science

PART B
1. Write PL/SQL program to enter any two numbers and find out their sum, difference,
product, quotient and remainder.
2. Write PL/SQL procedure to compute factorial of a number using recursion
3. Given the table EMPLOYEE (EmpNo, Name, Salary, Designation, DeptID) write a cursor
in PL/SQL to select the five highest paid employees from the table.
4. Write PL/SQL program to increase the salary for the employees of a particular department
and enter the no of records updated, date, time, deptno and name of the person who
increased the salary into another table called cursor_ret.
5. Create a row level trigger for the customers table that would fire for INSERT or UPDATE
or DELETE operations performed on the CUSTOMERS table. This trigger will display
the salary difference between the old & new Salary on UPDATE operation and display the
new or old salary for INSERT and DELETE operations, respectively.
CUSTOMERS(ID,NAME,AGE,ADDRESS,SALARY)
6. Given the table MOVIE(MID,MTitle, Language,Director,Year) write a function in
PL/SQL to find the total number of Movies in the table.
7. Given the Table CUSTOMERS(CID,CName, Address) write a PL/SQL program which
asks for customer ID, if the user enters invalid ID then the exception invalid_id is raised.
8. Write a PL/SQL program to demonstrate Packages.

BOS in Computer Science Page 20

 Bachelor of Science – Computer Science

Fourth Semester
Elective – 2
Subject Name: Cloud Computing
Subject code BSCT 403 A CIE Marks 20

No of Hours/Week: 3 SEE Marks 80

Total Hours: 3 Credits 3

COURSE OBJECTIVES:
1. Understand the fundamentals of cloud computing including cloud models (public, private, hybrid)
and key building blocks.
2. Gain insight into virtualization concepts, types, benefits, and how virtualization supports cloud
infrastructure.
3. Learn how to set up a private cloud using open-source tools and plugins, including cloud
provisioning and tool integrations.
4. Understand the relationship between IoT and Cloud Computing, and how they integrate in real-
world applications.

COURSE OUTCOMES:
At the end of the course students will be able to:
1. Explain the fundamentals of cloud computing, virtualization concepts, and different types of cloud
environments (public, private, hybrid).
2. Set up and configure a private cloud using open-source tools, and integrate tools like Docker and
Nagios.
3. Differentiate between Cloud Computing, IoT, and Fog Computing, and describe their roles in
modern IT infrastructures.
4. Demonstrate how to connect IoT devices to the cloud, manage cloud storage, and handle data
communication protocols and APIs.
5. Analyze real-time IoT-cloud applications including device-to-cloud communication, data
normalization, and infrastructure management.

Introduction to Cloud 8 Hours

Virtualization concepts, Types of Virtualization & its benefits, Introduction to
Various Virtualization OS, HA/DR using Virtualization, Moving VMs, Cloud
Unit 1 Fundamentals, Cloud Building Blocks, Understanding Public & Private cloud
environments, Private Cloud Environment, Public Cloud Environment, Managing
Hybrid Cloud environment.
Unit 2 The Cloud Setup 8 Hours

BOS in Computer Science Page 21

 Bachelor of Science – Computer Science
Setting up your own Cloud: Build private cloud using open source tools,
Understanding various cloud plugins, Setting up your own cloud environment,
Auto-provisioning, Custom images, Integrating tools like Nagios, Integration of
Public and Private cloud. Micro services using Docker
IoT and the Cloud 8 Hours
Introduction to cloud computing, Difference between Cloud Computing and IoT,
Unit 3 Fog Computing: The Next Evolution of Cloud Computing, Role of Cloud
Computing in IoT. Living on the Edge, An Abstract Edge Architecture Model,
Connecting devices at the edge and to the cloud
Connecting Things to Cloud 8 Hours
Various Real time applications of IoT, Connecting IoT to cloud, Cloud Storage for
Unit 4
Iot. Cloud-to-Device Connectivity, Device Ingress/Egress, Data Normalization and
Protocol Translation, Infrastructure, APIs, The Topology of the Cloud.
Challenge in Integration of Things with
10 Hours
Cloud
Security, Scalability, Reliability, Performance, Mobility, Resource Optimization &
Unit 5
cost efficiency, Cloud data management, cloud data monitoring, Cloud data
Exchange, Infrastructure Configuration & reconfiguration, IoT Overarching
Challenges.

TEXT BOOKS:
1. Biron, J., & Follett, J. (2016). Foundational elements of an iot solution. O'Reilly Media,
Incorporated
2. Buyya, R., Broberg, J., &Goscinski, A. M. (Eds.). (2010). Cloud computing: Principles and
paradigms (Vol. 87). John Wiley & Sons.

REFERENCE BOOK:

1. Hwang, K., Dongarra, J., & Fox, G. C. (2013). Distributed and cloud computing: from parallel
processing to the internet of things. Morgan kaufmann.

BOS in Computer Science Page 22

 Bachelor of Science – Computer Science

Fourth Semester
Elective - 2
Subject Name: Cyber Security
Subject code BSCT 403 B CIE Marks 20

No of Hours/Week: 3 SEE Marks 80

Total Hours: 45 Credits 3

COURSE OBJECTIVES:

1. This course introduces the students to the fundamental concept of Cyber security and issues and
challenges associated with it.
2. It aims to develop a basic understanding of the basic security aspects related to Computer and
Mobiles. They will be able to use basic tools and technologies to protect their devices.

COURSE OUTCOMES:
On successful completion of the course, students will be able to:

1. After completion of this course, students would be able to understand the concept of Cyber
security and issues and challenges associated with it.
2. After completion of this course, students would be able to understand the concept of Cyber
security and issues and challenges associated with it.
3. On completion of this course, students should be able to appreciate various privacy and security
concerns on online Social media and understand the reporting procedure of inappropriate content,
underlying legal aspects and best practices for the use of Social media platforms.
4. After the completion of this module, students would be able to understand the basic concepts
related to E-Commerce and digital payments. They will become familiar with various digital
payment modes and related cyber security aspects, RBI guidelines and preventive measures
against digital payment frauds.
Students, after completion of this module will be able to understand the basic security aspects
related to Computer and Mobiles. They will be able to use basic tools and technologies to protect
their devices.

Introduction to Cyber security 10 Hours

Defining Cyberspace and Overview of Computer and Web-technology,
Architecture of cyberspace, Communication and web technology, Internet,
Unit 1
World wide web, Advent of internet, Internet infrastructure for data transfer
and governance, Internet society, Regulation of cyberspace, Concept of cyber
security, Issues and challenges of cyber security.
Unit 2 Cyber-crime and Cyber law 10 Hours

BOS in Computer Science Page 23

 Bachelor of Science – Computer Science
Classification of cybercrimes, Common cybercrimes- cyber-crime targeting
computers and mobiles, cyber crime against women and children, financial
frauds, social engineering attacks, malware and ransomware attacks, zero day
and zero click attacks, Cybercriminals modus-operandi, Reporting of cyber
crimes, Remedial and mitigation measures, Legal perspective of cyber crime,
IT Act 2000 and its amendments,
Social Media Overview and Security 10 Hours
Introduction to Social networks Types of Social media, Social media
platforms, Social media monitoring, Hashtag, Viral content, Social media
Unit 3
marketing, Social media privacy, Challenges, opportunities and pitfalls in
online social network, Security issues related to social media, Flagging and
reporting of inappropriate content, Laws regarding posting of inappropriate
content.
E- Commerce and Digital Payments 8 Hours
Definition of E- Commerce, Main components of E-Commerce, Elements of
E-Commerce security, E-Commerce threats, E-Commerce security best
practices, Advantage of e-commerce, Survey of popular e-commerce sites.
Unit 4
Introduction to digital payments, Components of digital payment and stake
holders, Modes of digital payments- Banking Cards, Unified Payment
Interface (UPI), e-Wallets, Unstructured Supplementary Service Data
(USSD), Aadhar enabled payments, Digital payments related common frauds
and preventive measures.
Security 7 Hours
End Point device and Mobile phone security, Password policy, Security
patch management, Data backup, Downloading and management of third-
Unit 5
party software, Device security policy, Cyber Security best practices,
Significance of host firewall and Ant-virus, Management of host firewall
and Anti-virus, Wi-Fi security, Configuration of basic security policy and
permissions.
TEXT BOOKS:
1. Cyber Crime Impact in the New Millennium, by R. C Mishra, Auther Press. Edition 2010.
2. Cyber Security Understanding Cyber Crimes, Computer Forensics and Legal Perspectives by
SumitBelapure and Nina Godbole, Wiley India Pvt. Ltd. (First Edition, 2011).
3. Security in the Digital Age: Social Media Security Threats and Vulnerabilities by Henry A.
Oliver, Create Space Independent Publishing Platform. (Pearson , 13th November, 2001)

REFERENCE BOOKS:
1. Cyber Laws: Intellectual Property & E-Commerce Security by Kumar K, Dominant Publishers.
2. Fundamentals of Network Security by E. Maiwald, McGraw Hill.
3. Network Security Bible, Eric Cole, Ronald Krutz, James W. Conley, 2nd Edition, Wiley India
Pvt. Ltd.

BOS in Computer Science Page 24

 Bachelor of Science – Computer Science
Fourth Semester
Elective - 2
Subject Name: Mobile Computing
Subject code BSCT 403 C CIE Marks 20

No of Hours/Week: 3 SEE Marks 80

Total Hours: 45 Credits 3

COURSE OBJECTIVES:
1. To introduce the field of mobile communication and focuses on digital data transfer.
2. To address how mobile phone system works.
3. To understand the technology in wireless local area networks.
4. To focuses on mobility influencing applications, security, or IP networks

COURSE OUTCOMES:
1. An ability to understand the field of mobile communication.
2. An ability to understand how mobile phone system works
3. This course aims to understand the technology in wireless local area networks and its latest trends.

Introduction 09 Hours
Unit 1 Introduction to Mobile Computing – Applications of Mobile Computing-
Generations of Mobile Communication Technologies- Multiplexing – Spread
spectrum -MAC Protocols – SDMA- TDMA- FDMA- CDMA-
Different Generations of Wireless Networks- 1G, 2G, 3G, 4G,5G.
Unit 2 Mobile Telecommunication System 09 Hours
Introduction to Cellular Systems – GSM – Services & Architecture – Protocols
– Connection Establishment – Frequency Allocation – Routing – Mobility
Management – Security – GPRS- UMTS – Architecture – Handover –
Security.

Mobile Network Layer 09 Hours

Unit 3 Mobile IP – DHCP – AdHoc– Proactive protocol-DSDV, Reactive Routing
Protocols – DSR, AODV, Hybrid routing –ZRP, Multicast Routing- ODMRP,
Vehicular Ad Hoc networks ( VANET) –MANET Vs VANET – Security
Mobile Transport and Application Layer 10 Hours
Unit 4 Traditional TCP, Classical TCP Improvements: Indirect TCP-Snooping TCP,
Mobile TCP-Fast retransmit/fast recovery- Transmission /time-out freezing-
Selective retransmission-Transaction oriented TCP-Wireless Application
Protocol (WAP) –Architecture – XML – WML Script – Applications
Mobile Platforms And Applications 08 Hours
Mobile Device Operating Systems – Special Constraints & Requirements –
Unit 5 Commercial Mobile Operating Systems – Software Development Kit: iOS,
Android, BlackBerry, Windows Phone – MCommerce – Structure – Pros &
Cons – Mobile Payment System – Security Issues

BOS in Computer Science Page 25

 Bachelor of Science – Computer Science
TEXT BOOKS:
1. Jochen Schiller, ―Mobile Communications‖, PHI, Second Edition, 2003.

2. Prasant Kumar Pattnaik, Rajib Mall, ―Fundamentals of Mobile Computing‖, PHI Learning [Link],
New Delhi – 2012

REFERENCE BOOKS:
1. Dharma Prakash Agarval, Qing and An Zeng, ―Introduction to Wireless and Mobile systems‖,
Thomson Asia Pvt Ltd, 2005.

2. Android Developers: [Link]

3. Apple Developer: [Link]

4. Uwe Hansmann, Lothar Merk, Martin S. Nicklons and Thomas Stober, ―Principles of Mobile
Computing‖, Springer, 2003.

5. William. [Link] ―Mobile Cellular Telecommunications-Analog and Digital Systems, Second

Edition, Tata McGraw Hill Edition ,2006.

BOS in Computer Science Page 26

 Bachelor of Science – Computer Science
Fourth Semester
Elective - 2
Subject Name: Internet of Things
Subject code BSCT 407 D CIE Marks 20

No of Hours/Week: 3 SEE Marks 80

Total Hours: 45 Credits 3

COURSE OBJECTIVES:
1. To understand the concepts of Internet of Things and the application of IoT.
2. To Determine the Market perspective of IoT.
3. To Understand the vision of IoT from a global context

COURSE OUTCOME:
On successful completion of the course, students will be able to:
1. Use of Devices, Gateways and Data Management in IoT.
2. Design IoT applications in different domain and be able to analyze their performance
3. Implement basic IoT applications on embedded platform.

IoT & Web Technology 10 Hours

The Internet of Things Today, Time for Convergence, Towards the IoT
Universe, Internet of Things Vision, IoT Strategic Research and

Unit 1 Innovation Directions, IoT Applications, Future Internet Technologies,

Infrastructure, Networks and Communication, Processes, Data
Management, Security, Privacy & Trust, Device Level Energy Issues, IoT
Related Standardization, Recommendations on Research Topics.
M2M to IoT 10 Hours
A Basic Perspective– Introduction, Some Definitions, M2M Value
Unit 2
Chains, IoT Value Chains, an emerging industrial structure for IoT, The
international driven global value chain and global information
monopolies.M2M to IoT-An Architectural Overview– Building an
architecture, Main design principles and needed capabilities, An IoT
architecture outline, standards considerations.
IoT Architecture 8 Hours
Introduction, State of the art, Architecture. Reference Model-
Unit 3
Introduction, Reference Model and architecture, IoT reference Model, IoT
Reference Architecture- Introduction, Functional View, Information

BOS in Computer Science Page 27

 Bachelor of Science – Computer Science
View, Deployment and Operational View, Other Relevant architectural
views.
IoT Applications for Value Creations 10 Hours
Introduction, IoT applications for industry: Future Factory Concepts,
Brownfield IoT, Smart Objects, Smart Applications, Four Aspects in your
Unit 4
Business to Master IoT, Value Creation from Big Data and Serialization, IoT
for Retailing Industry, IoT For Oil and Gas Industry, Opinions on IoT
Application and Value for Industry, Home Management, eHealth.
IoT Privacy, Security and Governance 7 Hours
Introduction, Overview of Governance, Privacy and Security Issues,
Unit 5
Contribution from FP7 Projects, Security, Privacy and Trust in IoT-Data-
Platforms for Smart Cities, First Steps Towards a Secure Platform, Smartie
Approach. Data Aggregation for the IoT in Smart Cities, Security.

TEXT BOOK:

1. Vijay Madisetti and ArshdeepBahga, “Internet of Things: (A Hands-on Approach)”, Universities Press
(INDIA) Private Limited 2014, 1st Edition.

REFERENCE BOOKS:

1. Michael Miller, “The Internet of Things: How Smart TVs, Smart Cars, Smart Homes, and Smart
Cities Are Changing the World”, Pearson Education 2015.
2. Francis da Costa, “Rethinking the Internet of Things: A Scalable Approach to Connecting
Everything”, Apress Publications 2013, 1st Edition.
3. Waltenegus Dargie, Christian Poellabauer, "Fundamentals of Wireless Sensor Networks:
Theory and Practice”, Wiley 2014.
4. CunoPfister, “Getting Started with the Internet of Things”, O‟Reilly Media 2011.

BOS in Computer Science Page 28

 Bachelor of Science – Computer Science

Question Paper Pattern for Semester End Examination (SEE)

(Common for III and IV Semester)
SUBJECT NAME

Time: 3 Hrs. Max. Marks: 80

Instruction to Candidate: Answer all the Sections

SECTION A

I. Answer any ten of the following questions (10X2 = 20)

1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
SECTION B

II. Answer any five of the following questions (5X5 = 25)

13.
14.
15.
16.
17.
18.
19.
SECTION C

III. Answer any five of the following questions (5X7 = 35)

20.
21.
22.
23.
24.
25.
26.

BOS in Computer Science Page 29