MCA

Type: Compulsory
Contact Hours: 4 hours/week
Examination Duration: 3 Hours
Mode: Lecture
External Maximum Marks: 75
External Pass Marks: 30(i.e. 40%)
Internal Maximum Marks: 25
Total Maximum Marks: 100
Total Pass Marks: 40(i.e. 40%)

Instructions to paper setter for End semester examination:
Total number of questions shall be nine. Question number one will be compulsory and will be consisting of short/objective type questions from complete syllabus. In addition to compulsory first question there shall be four units in the question paper each consisting of two questions. Student will attempt one question from each unit in addition to compulsory question. All questions will carry equal marks.

Course Objectives: The aim of this course is to provide an in-depth exposure of SQL and PL/SQL to implement database management system in an organization. The course covers the variety of databases to meet real life problem scenario.
Course Outcomes (COs)   At the end of this course, the student will be able to:
MCA-20-23.1                          understand database architecture, designing of databases using ER and EER model;
MCA-20-23.2                         to write complex queries in SQL and can design PL/SQL blocks for database implementation;
MCA-20-23.3                         learn query optimization and concurrency control techniques;
MCA-20-23.4                         gain knowledge of variety of databases to meet real life problem scenario.

                                                                                     UNIT – I
Database Systems Concepts and Architecture: Schema and Instances, DBMS architecture and Data Independence, Database languages and Interfaces, DBMS Functions and Component Modules. Entity Relationship Model: Entity Types, Entity Sets, Attributes & keys, Relationships Types & Instances, Roles and Structural Constraints, E-R Diagrams, Design of an E-R Database Schema.
The Enhanced Entity-Relationship (EER) Model: Subclasses, Super classes, Inheritance, Specialization and Generalization.
                                                                                    UNIT – II
SQL: Data Definition and Data Types, DDL, DML, and DCL, Views & Queries in SQL, Specifying Constraints & Indexes in SQL. PL/SQL: Architecture of PL/SQL, Basic Elements of PL/SQL, PL/SQL Transactions, Cursors and Triggers.
Relational Database Design: Functional Dependencies, Decomposition, Normal Forms Based on Primary Keys- (1NF, 2NF, 3NF, BCNF), Multi-valued Dependencies, 4 NF, Join dependencies, 5 NF, Domain Key Normal Form.
                                                                                   UNIT – III
Query Processing and Optimization, Transaction Processing: Introduction to Transaction Processing, Transaction and System Concepts, Desirable Properties of Transactions, Concurrency Control Techniques: Two-Phase Locking Techniques, Timestamp Ordering, Serializability. Database Backup and Recovery: Recovery facilities, Recovery Techniques.

                                                                                    UNIT – IV
Databases for Advance Applications: Architecture for Parallel Database and Distributed Database, Active Database Concept and Triggers, Temporal Databases Concepts, Spatial and Multimedia Databases, Deductive Databases, Geographical Information System, Mobile Databases, Web Databases, XML Schema, Object- Based Databases, OLTP Vs OLAP.
Text Books:
⦁ Elmasri & Navathe: Fundamentals of Database systems, Pearson Education.
⦁ Ivan Bayross: SQL, PL/SQL- The Program Language of ORACLE, BPB Publication.
⦁ Alexis Leon & Mathews Leon: Database Management System, Leon Vikas Publication.
Reference Books:
⦁ Korth&Silberschatz: Database System Concept, McGraw Hill International Edition.
⦁ Raghu Ramakrishnan& Johannes Gehrke: Database Management Systems, Mcgraw Hill.
⦁ Peter Rob, Carlos Colonel: Database system Design, Implementation, and Measurement, Cengage Learning.
⦁ Abbey, Abramson & Corey: Oracle 8i-A Beginner’s Guide, Tata McGraw Hill.