Well the University of Mumbai is one of the first three state universities of India and the oldest in Maharashtra.

BCA 3rd year DBMS syllabus

Syllabus

UNIT I

Decomposition: Functional dependency, Lossless-Join decomposition, Multi valued dependency and fourth normal form, Join dependency, Fifth normal form.
Concurrency Control: Concept of a transaction, ACID properties, Serial and serializable schedules, Conflict and View serializabilty, Precedence graphs and test for conflict seralizability.
Enforcing serializability by locks: Concept of locks, the locking scheduler, Two phase Locking, upgrading and down grading locks, Concept of dead locks, Concurrency control by time stamps, The Thomos Write rule.
Crash Recovery: ARIES algorithm. The log based recovery, recovery related structures like transaction and dirty page table, Write-ahead log protocol, check points, recovery from a system crash, Redo and Undo phases.

UNIT II

Sequences: creating sequences, referencing, altering and dropping a sequence.
Fundamentals of PL/SQL: Defining variables and constants, PL/SQL expressions and comparisons: Logical Operators, Boolean Expressions, CASE Expressions Handling, Null Values in Comparisons and Conditional Statements, PL/SQL Datatypes: Number Types, Character Types, Boolean Type, Datetime and Interval Types.
Overview of PL/SQL Control Structures: Conditional Control: IF and CASE Statements, IF-THEN Statement, IF-THEN-ELSE Statement, IF-THEN-ELSIF Statement, CASE Statement, Iterative Control: LOOP and EXIT Statements, WHILE-LOOP, FOR-LOOP, Sequential Control: GOTO and NULL Statements, Concept of nested tables.
Query evaluation: System Catalog, Evaluation of relational operators like selection, projection, join and set, introduction to query optimization.
Cursors: Concept of a cursor, types of cursors: implicit cursors; explicit cursor, Cursor for loops, Cursor variables, parameterized cursors,
Transactions in SQL: Defining a transaction, Making Changes Permanent with COMMIT, Undoing Changes with ROLLBACK, Undoing Partial Changes with SAVEPOINT and ROLLBACK, Defining read only transactions, explicit locks: transaction and system level, Choosing a Locking Strategy: ROW SHARE and ROW EXCLUSIVE Mode.

Unit III

Project management: Revision of Project Management Process, Role of Project Manager,
Project Management Knowledge Areas, Managing Changes in requirements, Role of software
Metrics
Size & Effort Estimation –Concepts of LOC & Estimation, Function Point, COCOMO Model,
Concept of Effort Estimation & Uncertainty
Project Scheduling Building WBS, Use of Gantt & PERT/CPM chart, Staffing
Configuration Management Process & Functionality & Mechanism, Process Management,
CMM & its levels, Risk Management & activities
Management of OO software Projects -Object oriented metrics, Use-Case Estimation Selecting
development tools, Introduction to CASE
Changing Trends In Software Development -Unified Process, Its phases & disciplines, Agile
Development – Principles & Practices, Extreme programming-Core values & Practices
Frameworks, Components, Services, Introduction to Design Patterns, Open Source


Unit IV

Software Testing: Introduction to Quality Assurance, Six Sigma Testing Fundamentals,
Common Terms(like Error, Fault, Failure, Bug, Crash) Objectives of testing, Challenges in
Testing, Principles of Testing
Static Testing – Introduction & Principles
Types of Testing – Levels of testing such as Unit testing, Integration testing, System testing,
Validation Testing, Acceptance testing,
Types of testing such as Black box, White Box, Functional, Performance, Regression,
Acceptance, Volume, Stress, Alpha, Beta testing
Black Box Testing: Introduction, Equivalence partitioning, Boundary-value analysis,
Robustness testing, Cause Effect Graph,
White Box Testing: Statement Coverage, Branch/Decision Coverage, Condition Coverage,
Graph Matrix, Cyclomatic complexity, Mutation Testing
Object Oriented Testing & Web site testing – Object Oriented Testing Strategies, Testing
methods, Overview of web site testing
Planning Software Testing – Test Plan, Test Plan Specification, Test Case Execution and
Analysis, Defect logging and tracking

Address:

University of Mumbai

Kalina, Santacruz East,

Mumbai, Maharashtra 400098

Phone: 022 2654 3000