BCCA Part 3 DBMS and OracleUniversity 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.
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
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,