BCA Bachelor of Computer Applications Part 2University Syllabus Course For BCA Part 2 ( Second Year )
Atlanta Computer Institute Nagpur conducts Tuition Classes for BCA First Year ( Part 1 ) , BCA Second Year ( Part 2 ) and BCA Final Year ( Part 3 ) for all universities in India . The Following syllabus is of Nagpur University. Final Year Projects Training is also given to BCA Students. The Tuition Classes are also conducted for syllabus of BCA of all universities in India.
BCA Part 2 ( Second Year )
A ) COMPUTER SCIENCE( COMPUTER SOFTWARE ) ---- BCA Second Year
PAPER - I
OPERATING SYSTEM CONCEPTS
Operating system introduction
Operating 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:
System 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:
Features of Unix OS, Structure of Unix Os, Role and functions of Kernal and Shell.
File System : Features of Unix file system, types of files, physical file structure of Unix.
Unix 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:
Invoking and 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.
Unix Security : Security and protection commands, symbolic and octal file permission.
UNIT : 5 SHELL SCRIPTS:
Creating 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:
Introduction 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.
Structured 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 types.
UNIT – 2 commands
1. Create table, drop table, modify, alter table
2. Data manipulations – Insert ,update, delete, select
3. Aggregate functions – Max, Min, Sum Avg, Count
4. Other Clauses – Group by, order by having union interselect, minus
5. Predicates – comparison like Between null in, Exits.
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:
Exception Management : User defined, Predefined exception, subprogram and packages – procedures, functions, package specification, body, calling sub programs, advantages of packages, cursors in packages.
UNIT – 5:
Database 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 and procedures.
PAPER – 3 SYSTEM ANALYSIS & DESIGN
UNIT – 1
System 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:
System Planning & the Initial Investigation – Introduction , Base for Planning in System Analysis, Initial Investigation.
Information Gathering – Introduction, Information Gathering Tools.
The Tools of structured Analysis – Introduction, the tools of structured analysis, Pros & Cons of each tool.
Feasibility Study – Introduction, system performance definition, Feasibility study.
UNIT – 3:
Cost Benefit Analysis – Introduction, Data analysis, Cost benefit analysis, Procedure for cost benefit determination.
System 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:
File Organization & data base design – Introduction, File structure, File organization, Database design, Data structure, Normalization and the role of Database administrator.
System Implementation (System testing & quality Assurance) – Introduction, the test Plan quality assurance, level of quality assurance, roles of data processing auditor.
Implement & software Maintenance – Introduction, conversion, Post implementation review, Software maintenance.
UNIT – 5
Hardware/ software selection & the computer contract – Introduction, the computer industry, A procedure for Hardware / software selection, financial considerations in selection, The computer contracts.
Project Scheduling & Software – Introduction, Project Management.
Security, Disaster / Recovery – Introduction, System security, Disaster /Recovery planning, Ethics in system development.
BCA 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,