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.