MCM -Master of Computer Management Part 2University Syllabus Course MCM PART 2
Atlanta Computer Institute Nagpur Conducts MCM Tuition Classes for MCM Part 1 ( First Year ) and MCM Part 2 ( Second Year ). Projects are also provided with guidance.
MCM Part 2
PAPER – III DATABASE SYSTEM CONCEPT & ORACLE
UNIT – I
Relational data base management system (RDBMS) introduction to DBMS, data abstraction, data models,, logical model physical models, E-R relationship model, relational model network, model, heirachical model, DBMS language Database administrator, structure of relational database, relational algebra taple relational calculus, domain relational calculus. Relational database design: normalization using functions dependencies.
Relational commercial languages : SQL query by example QUEL
Introduction to oracle or RDBMS, Oracle as a multi- user system, logging in and logging out of Oracle, database administrator (DBA) and its role, creation of user and passwords.
SQL STRUCTURED QUERY LANGUAGE
History and standardization of SQL elements of SQL languages : Database objects, reserve words, key word, literals, variables, data types : number date, long, raw and long raw, var, varchar data types.
COMMAND TO BE COVERED
1. Create table, drop table, modify alter table
2. Data manipulating commands – insert, update delete, select
3. Aggregate function - Max, min, sum, acg, count
4. Other clauses – Group by, order by, having union intersect, minus
5. Predicates – Comparison like, Between – null in exists
UNIT – III:
1. Sub queries
4. Simple reports commands
5. PS/SQL programming: introduction to PL/SQL, variable, initializing variables dynamic data types, control and loop statements, loops and labels, PL/SQL cursors
UNIT – IV:
User designed predefined exceptions; subprograms and packages – procedures, functions, package specification body, calling sub programs, advantages of packages, and cursers in packages.
UNIT – V:
DATABASE TRIGGERS & BUILT IN PACKAGES
Database triggers syntax, parts statement, body, restriction, type built in packages – DBMS standard, DBMS – output Collection, member functions and procedure, PL/SQL table and records, declaration, referring, maintaining row count, insertions, deletions, nested tables, varying, arrays, initialization declaration, varrays, member functiosn and procedures.
Paper - 5 Electives
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,