MCA-301 Database Systems

MCA-301 Database Systems !

Basic Concepts: A Historical perspective, File Systems vs. DBMS, Characteristics of the Data Base Approach, Abstraction and Data Integration, Database users, Advantages and Disadvantages of a DBMS, Implication of Data Base approach.

Data Base Systems Concepts and Architecture: Data Models, Schemas and Instances, DBMS architecture and Data Independence, Data base languages & Interfaces, DBMS functions and component modules.

Entity Relationship Model : Entity Types, Entity Sets, Attributes & Keys, Relationships, Relationship Types, Roles and Structural Constraints, Design issues, weak entity types, E-R Diagrams. Design of an E-R Database Schema, Reduction of an E-R Schema to Tables, The Unified Modeling Language (UML).

Relational Data Model: Relational model concepts, Integrity constraints over Relations, Relational Algebra – Basic Operations.

SQL: Data Definition, Constraints, & Schema Changes in SQL, Insert, Delete & update statements in SQL, view in SQL, Specifying Constraints and Indexes in SQL, Queries in SQL.

A Relational Data Base Management System: ORACLE – A Historical perspective, Basic structure, Data base Structure and its manipulation in ORACLE, Storage Organization in ORACLE Programming ORACLE Applications.

Conventional Data Models: An overview of Network and Hierarchical Data Models.

Relational Data Base Design: Functional Dependencies, Decomposition, Desirable properties of decomposition, Normal forms based on primary keys (1 NF, 2 NF, 3 NF and BC NF).

Practical Data Base Design: Role of Information systems in Organizations, Database design process, physical database design in Relational Databases.

Transaction Processing Concepts: Introduction to Transaction Processing, Transaction & System Concepts, Properties of Transaction, Schedules and Recoverability, Serializability of Schedules.

Concurrency Control Techniques: Locking Techniques, Time stamp ordering, Multiversion Techniques, Optimistic Techniques, Granularity of Data Items.

Recovery Techniques: Recovery concepts, Recovery Techniques in centralized DBMS.

Data Base Security: Introduction to Database Security issues.

Leave a Reply

Your email address will not be published. Required fields are marked *