BCCA Part 3 DBMS and Oracle

University Syllabus and Classes of BCCA Part 3 DBMS and Oracle

Atlanta Computer Institute Conducts Tuition Classes for BCCA Part 3. We also provide final year Projects of BCCA Students and guidance for Final Year Projects with Certificates.

Unit –I: Database environment, Data processing, Traditional and DBMS environment, Database system, Types of databases - Centralize, distributed, Database management system, Components of DBMS, DBMS elements, Database Approach - Objectives, benefits, characteristics, Advantages of DBMS, The three tire architecture, Three level architecture, Database administration – Roles, Functions and responsibilities of DBA.

Unit-II: The E-R Model – Data models, Entities, attributes and relationship, Logical and Physical database design, Mapping Cardinalities, Database development process, Database development life cycle. Integrity constrains. Transforming ERR diagrams into relations, tree structure and hierarchical. Normalization, Codd’s 12 rules, hierarchical database structure, Network database structure, Relational database structure.RDBMS.

Unit-III: Introduction to ORACLE as RDBMS, History& standardization of SQL, Elements of SQL : Database objects, reserved words, Keywords, Variables, Data Types, Operators.
Types of SQL : DDL, DML, DCL, Create table, Alter table, Crate view, Drop table, grant, revoke, commit, delete, insert, lock table, rollback, save point, Update, Select statement, Where clause. Functions : Arithmetic & Characters comparison, Logical set, Like function, Group function, Date Functions.

Unit-IV: PL/SQL : Introduction to PL/SQL, Variables, Initialization of variables, Dynamic data types, Control loop statements, PL/SQL Cursor : Declare cursor, Fetch, Open cursor, Close cursor. Triggers :Concepts, Trigger definition, Trigger type, Enabling, Disabling & Dropping triggers.

BOOKS RECOMMENDED:
1. DBMS : Korth and Sudarshan
2. DBMS : Desai
3. Database management system : R. Panneerselvam (PHI)
4. Oracle : I.T. Today (Encyclopedia)
5. Oracle : Oracle Press
6. Oracle Pl/SQL : PL/SQL in 21 days (Techmedia) SAMS

 

 BCCA PART 3 or Final Year

 

PAPER 1 BUSINESS LAW

PAPER 2 Computerised Accounting ( TALLY )

PAPER 3 SOFTWARE PRODUCT AND PROJECT MANAGEMENT

PAPER 4 FRONT END DEVELOPMENT ( VISUAL BASIC )

PAPER 5 DBMS AND ORACLE

PAPER 6 PROJECT


    

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,

Basic Programming

C / C++ ,

Testing

Software Testing,

Hardware & Networking

CCNA, MCSE, Hardware, Networking

Courses at Atlanta

New Batches start Every week On Mondays and Wednesdays.

New Batch Starting Date & Timing

Copyright © 2010-2017 All Right Reserved - Atlanta Computer Institute, Nagpur. Site Map