DBMS Tutorial


I. Overview of Database Management System
  1. File System: Introduction, Drawbacks
  2. History and Development of DBMS
  3. Objectives of DBMS
  4. Classification of DBMS
  5. Advantages and Disadvantages of DBMS
  6. ANSI / SPARK Model (Levels of abstraction)
  7. Component and Interfaces of DBMS
  8. DBMS Architectures 
  9. Data Models 
  10. Situations where DBMS is not necessary
  11. DBMS Vendors and their productions
II. Entity Relational Model
  1. The Building Blocks of ER-Model
  2. Steps to construct an ER Diagram 
  3. Types of Entities
  4.  Different types of attributes
  5. Different types of relationships and relationship degree
  6. Reducing ER Diagram to Tables
  7. Enhanced ER Modeling
  8. Generalization and specialization
  9. IS-A Relationships and attribute relationship
  10. Attribute and Multiple inheritance
  11. Aggregation and composition
  12. constraints on Generalization and specialization
  13. Entity clustering 
  14. Connection traps

III. Relational Model in DBMS 

  1. Introduction to Relational Model
  2. CODD Rules
  3. Concept of key
  4. Relational integrity
  5. Relational algebra operations
  6. Advantages and limitations of relational algebra 
  7. Relational Calculus (TRC and DRC)

IV. Normalization 

  1. Anomalies in DBMS
  2. Functional dependencies 
  3. Inference rules
  4. Closure of an attribute set
  5. Determining candidate key of a relation
  6. Finding the Candidate Key of a sub relation using FD's
  7. Determining number of possible super keys of a sub relation.
  8. Checking additional functional dependencies 
  9. Equivalence of two sets of functional dependencies
  10. Minimal cover of relation 
  11. Relational decomposition and Dependency preserving 
  12. Introduction  to normalization
  13. First Normal Form (1NF)
  14. Second Normal Form(2NF)
  15. Third Normal Form(3NF)
  16. Boycod normal form (BCNF)
  17. Higher normal forms 
  18. Multi valued Dependencies

V. Structured Query Language (SQL)

  1. Introduction to SQL
  2. SQL commands 
  3. SQL Data types
  4. Selection and projection operation
  5. Aggregate function in SQL
  6. Integrity constraints 
  7. Complex Integrity Constraints in SQL
  8. Enforcing integrity constraints 
  9. Sub-Query and correlated Sub-Query 
  10. Embedded Queries
  11. SQL Joins
  13. NULL Values and It's importance in SQL Query 

VI. Programming with PL/SQL

  1. Need of PL/SQL programming in database
  2. Structure of PL/SQL Program
  3. PL/SQL Language elements
  4. Data types in PL/SQL
  5. Control statements in PL/SQL
  6. Iterative controls in PL/SQL
  7. Creating and Running cursors in PL/SQL
  8. Creating functions, procedures, and package in PL/SQL
  9. Exception Handling in PL/SQL
  10. Database Triggers in PL/SQL

VII. Transaction Management and Concurrency Control

  1. Transaction Concept
  2. Transaction States
  3. Implementation of Atomicity and Durability
  4. Concurrent Executions
  5. Serializability
  6. Recoverability
  7. Implementation of Isolation
  8. Lock-based protocols
  9. Timestamp-based protocols

VIII. Storage Management (Overview of Storage and Indexing)

  1. Data on external storage 
  2. File Organization and Indexing
  3. Index structures
  4. Indexed Sequential Access Methods (ISAM),
  5.  B+ Trees: A Dynamic index Structure.

DBMS GATE Questions


Post a Comment

Note: only a member of this blog may post a comment.

Find Us On Facebook

python tutorial


C Programming


Java Tutorial


Data Structures


MS Office


Database Management