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. 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)


Post a Comment

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

Find Us On Facebook

Computer Basics


C Programming


Java Tutorial


Data Structures


MS Office


Database Management