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. Relational data model
4. Concept of key
5. Relational integrity
6. Relational algebra operations
7. Advantages and limitations of relational algebra 
8. 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
6. Determining number of possible super keys of a sub relation.
7. Checking additional functional dependencies 
8. Equivalence of two sets of functional dependencies
9. Minimal cover of relation 
10. Relational decomposition 
11. First Normal Form (1NF)
12. Second Normal Form(2NF)
13. Third Normal Form(3NF)
14. Boycod normal form (BCNF)
15. Higher normal forms 

V. Structured Query Language (SQL)