Hindi Vidya Prachar Samiti’s
Ramniranjan Jhunjhunwala College
of Arts, Science & Commerce
(Empowered Autonomous College)
Affiliated to
UNIVERSITY OF MUMBAI
Syllabus for the S.Y.B.Sc. (under NEP)
Program: B.Sc. COMPUTER-SCIENCE
Program Code: RJSUCS
Course Code: RJVSCCSP231
National Education Policy (NEP 2020)
Level 4.5
(REVISED in 2024-25 in alignment with the NEP2020 facilitating the inter-
and multidisciplinary learning and multiple entry and exit of students)
(CBCS 2024-2025)
THE PREAMBLE
Why Computer Science?
Computer Science(CS) has been evolving as an important branch of science and engineering
throughout the world in last couple of decades and it has carved out a space for itself like any other
disciplines of basic science and engineering. Computer Science is a discipline that spans theory and
practice and it requires thinking both in abstract terms and in concrete terms. Nowadays, practically
everyone is a computer user, and many people are even computer programmers. Computer Science
can be seen on a higher level, as a science of problem solving and problem solving requires
precision, creativity, and careful reasoning. The ever-evolving discipline of computer science also
has strong connections to other disciplines. Many problems in science, engineering, healthcare,
business, and other areas can be solved effectively with computers, but finding a solution requires
both computer science expertise and knowledge of the particular application domain. The B.Sc.
Computer Science course structure therefore needed a fresh outlook and complete overhaul.
Why Computer Science at R J College?
The Computer Science department was established in the year 1999 with strength of 60 Students and
M.Sc CS with strength of 40 Seats was introduced in the year 2001. Today the strength has reached to
120 at UG level and 48 at PG level. The department offers both UG and PG programs in the subject
of CS and is affiliated to, and recognized by the University of Mumbai. College facilitate departmental
library with near about 1200+ books. There are 3 dedicated well-upgraded laborites for CS
department. With the management extensive support, department believes in "1 Student 1 PC policy"
which helps students to rigorous practice and focus. Projects, hands on training sessions, guest lectures,
laboratory experimentation, lecture-based learning, industry visits etc. motivate students to explore
more in terms of applications of the subject. Under autonomy, the department has made curriculum
more robust by incorporating skill-based learning and value added course that imparts practical
knowledge of the subject to the students. Department of CS (DBT), New Delhi has identified CS
Department of R J College as DBT Star College Department which has further strengthened our hands
in being able to provide hands on training to the students to satisfy their curiosity.
Our Curriculum, Your Strength
The syllabus of CS (Under NEP 2020) for total eight semesters is meticulously designed so as to
make students understand the various programming languages and other many subjects of Indian
Knowledge, Communication, Ethics etc. SY level syllabus have great potential to serve the need of
students for being strong basic foundation in computer science. Then gradually stepping ahead the
students at higher complexities at every subsequent semester, till semester 8. All subjects that are
covered in these 8 semesters gives adequate knowledge in the fields of Computer Science as well as
other streams. Practical’s of all semesters and Project at Final year boost high level of confidence of
students to crack immense career opportunities.
Hindi Vidya Prachar Samiti’s, Ramniranjan Jhunjhunwala College of Arts, Science &Commerce
(Empowered Autonomous College)
S.Y.B.Sc Computer-Science Syllabus Semester III & IV
S.Y.BSc Semester III Practical
Course Objectives:
RJVSCCSP231 • To develop understanding of concepts and techniques for data
management and learn about widely used systems for
implementation and usage.
DATABASE
• To develop understanding of Transaction management and crash
MANAGEMENT
recovery.
SYSTEM
• To develop concepts of programming concepts of database.
PRACTICAL
Learning outcome :
• After successful completion of this course, students would be able
to
• Master concepts of stored procedure, functions, cursors and
triggers and its use.
• Learn about using PL/SQL for data management Know common
security attacks, tools, methods & social media security
• Understand concepts and implementations of transaction
management
SEMESTER III (PRACTICALS) L Cr
DATABASE MANAGEMENT Paper Code: RJVSCCSP231 30 2
SYSTEM PRACTICAL
1 Writing PL/SQL Blocks with basic programming constructs by
including following:
a. Sequential Statements
b. unconstrained loop
2 Sequences:
a. Creating simple Sequences with clauses like START WITH,
INCREMENT
BY, MAXVALUE, MINVALUE, CYCLE | NOCYCLE, CACHE |
NOCACHE, ORDER | NOORECER.
b. Creating and using Sequences for tables.
Hindi Vidya Prachar Samiti’s, Ramniranjan Jhunjhunwala College of Arts, Science &Commerce
(Empowered Autonomous College)
S.Y.B.Sc Computer-Science Syllabus Semester III & IV
3 Writing PL/SQL Blocks with basic programming constructs by
including following:
a. If...then...Else, IF...ELSIF...ELSE... END IF
b. Case statement
4 Writing PL/SQL Blocks with basic programming constructs for
following Iterative
Structure:
a. While-loop Statements
b. For-loop Statements.
5 Writing PL/SQL Blocks with basic programming constructs by
including a GoTO to jump out of a loop and NULL as a statement
inside IF.
6 Writing Procedures in PL/SQL Block
a. Create an empty procedure, replace a procedure and call
procedure
b. Create a stored procedure and call it
c. Define procedure to insert data
d. A forward declaration of procedure
7 Writing Functions in PL/SQL Block.
a. Define and call a function
b. Define and use function in select clause
8 Creating and working with Insert/Update/Delete Trigger using
Before/After clause.
9 Write an Implicit and explicit cursor to complete the task.
10 Write a SQL block to handle exception by writing:
a. Predefined Exceptions,
b. User-Defined Exceptions
11 Study of Transaction Management: ACID Properties
12 Study of Serializability, Two-phase Commit Protocol, Concurrency
Control
Hindi Vidya Prachar Samiti’s, Ramniranjan Jhunjhunwala College of Arts, Science &Commerce
(Empowered Autonomous College)
S.Y.B.Sc Computer-Science Syllabus Semester III & IV
References:
1. 1. Mastering PL/SQL Through Illustrations: From Learning Fundamentals to Developing
Efficient PL/SQL Blocks, Dr. B. Chandra, BPB Publication, 2020
2. Oracle Pl/Sql Training Guide., Training guide, BPB Publications, 2016
3. Raghu Ramakrishnam, Gehrke, Database Management Systems, McGraw‐ Hill,3rd Edition,
2014
4. Abraham Silberschatz, Henry F. Korth,S.Sudarshan , Database System Concepts, 6th Edition
2019
