BCA Part 2 ( Second Year )
A ) COMPUTER SCIENCE( COMPUTER SOFTWARE ) ---- BCA Second Year
PAPER - I
OPERATING SYSTEM CONCEPTS
System : Introducing, Purpose
Types of OS
: Concept of Batch Multi Programmed, Times Sharing, Parallel, Real Time and
distributed, Computer system structures : computer system operation, I/O
Structure. I/O Structure, I/O
Interrupts,, DMA Structure, storage
structure and storage Hierarchy. Hardware Protection : Dual Mode Operation, I/O Memory And CPU
Protection, General System architecture.
UNIT -2 :
OPERATING SYSTEM STRUCTURES:
Components : Process, Main Memory, File, I/O System Secondary Storage Management,
Networking, Protection System, Command Interpreter System Operating System
Services, system, command interpreter system, operating system services, system
calls. Process and job control: File
Manipulation, device Management, information Maintenance, and
communication. System structure :
Simple, Layered Approach.
UNIT – 3: UNIX
Concepts, Linus, File System, Commands and Editors:
Unix OS, Structure of Unix Os, Role and functions of Kernal and Shell.
: Features of Unix file system, types of files, physical file structure of
commands: Directory and file manipulation commands, pipeline and filters, shell
Meta characters. Editor : Vi
Introduction to Linux : Features of Linux & its applications.
UNIT – 4:
Unix Communication Facilities, system Administration and security:
sending mails, mailing tools, secret Mail.
Direct Communication Utilities : Write talk and wall. System Administration : Role of System
Administrator, system administration commands, Backing up a Unix System.
Security : Security and protection commands, symbolic and octal file
UNIT : 5
Shell variables, Commands : If then –else-if, test case and switch for and for
each while and switch, for and for each, while and Until, Other Looping Command
xargs, catching Interrupts – trap, Updating data awk Utility.
PAPER – 2 ORACLE
UNIT – 1:
To Oracle – introduction to Oracle as RDBMS, Oracle as a multi-user system,
logging in and Logging out of Oracle, Database Administrator (DBA) and its
Role, creating of user and password.
Query language SQL – history and Standardization of SQL benefits of SQL element
of SQL Languages – Database objects, Reserve words, Key words Literals,
variables, Data types Number Date Long, raw and long raw, var varchar data
UNIT – 2
1. Create table, drop table, modify, alter table
2. Data manipulations – Insert ,update, delete,
3. Aggregate functions – Max, Min, Sum Avg, Count
4. Other Clauses – Group by, order by having union
5. Predicates – comparison like Between null in,
UNIT – 3:
1. Sub queries
4. Simple reports command
5. PI/SQL Programming : Introduction to PL/SQL,
Variables, initializing variables, and dynamic data types, control and loop
statements, loops and labels, PL/SQL cursors.
UNIT – 4:
Management : User defined, Predefined exception, subprogram and packages –
procedures, functions, package specification, body, calling sub programs,
advantages of packages, cursors in packages.
UNIT – 5:
Triggers & Built in Packages : Database triggers – Syntax, parts,
statement, body, restriction, types.
Build-in packages DBMS standard.
DBMS Output –
Collection, member functions and procedures, Pl/SQL table and records,
declaration, referring, maintaining row count, insertion deletion nested
tables, varying, arrays, initializing, declaration, varrays, member functions
PAPER – 3 SYSTEM ANALYSIS & DESIGN
UNIT – 1
concept – System concept, Elements of the system, types of System. The system Development lifecycle –
introduction, Consideration for Candidate systems, Prototyping, The Role of the
Analyst – Introduction, Multi Face role of the Analyst, The Analyst/User
interface, Rising position in system development.
UNIT - 2:
Planning & the Initial Investigation – Introduction , Base for Planning in
System Analysis, Initial Investigation.
Gathering – Introduction, Information
The Tools of
structured Analysis – Introduction, the tools of structured analysis, Pros
& Cons of each tool.
Study – Introduction, system performance definition, Feasibility study.
UNIT – 3:
Analysis – Introduction, Data analysis, Cost benefit analysis, Procedure for
cost benefit determination.
Design – Introduction, the process of design, design methodology, Major
development activities, Audit Consideration, Input /Output and Form Design –
Introduction, Input design, Output design, Form design.
UNIT – 4:
Organization & data base design – Introduction, File structure, File
organization, Database design, Data structure, Normalization and the role of
System Implementation (System testing & quality
Assurance) – Introduction, the test Plan quality assurance, level of quality
assurance, roles of data processing auditor.
& software Maintenance – Introduction, conversion, Post implementation
review, Software maintenance.
UNIT – 5
software selection & the computer contract – Introduction, the computer
industry, A procedure for Hardware / software selection, financial
considerations in selection, The computer contracts.
Scheduling & Software – Introduction, Project Management.
Disaster / Recovery – Introduction, System security, Disaster /Recovery
planning, Ethics in system development.
BCA Part 2 Syllabus
BCA Part 2 Group A Computer Science ( COMPUTER SOFTWARE )
BCA Part 2 Group B Electronics ( Computer Hardware )
BCA Part 2 Group COMPUTATIONAL METHODOLOGY
Bachelor Of Computer Application, BCCA,
Bachelor of Commerce & Computer Application BE
IT/CS, Information technology/Computer Science MCA,
Master of Computer Application MCM,
Master of Computer Management Diploma
, Polytechnic Others,
Basic Programming C / C++ ,
Hardware & Networking CCNA, MCSE, Hardware,