DBMS Tutorial

 PART-I

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
12. Views
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