Introduction of DBMS

Introduction,Characterstics of DBMS, Advantages and Disadvantages

Components of DBMS

handwritten notes of Components of DBMS

Three level Architecture of DBMS

handwritten notes of Three level Architecture

Introduction to Data Models,

Hierarchical Model ,Operations of Hierarchical Model Advantages and Disadvantages of Hierarchical Model

Network Model in dbms

Network Model ,Operations of Network Model Advantages and Disadvantages of Network Model

Relational Model in dbms

Relational Model terminology ,Operations of Relational Model Advantages and Disadvantages of Relational Model

Comparison of Network, Hierarchical and Relational Model

Difference Between Network, Hierarchical and Relational Model

Entity Relationship Model

Entity Types, Entity Sets, Attributes & Keys, Relationships, Relationship Types,cardinality ,connectivity of relationship

Relational Algebra

Set Operations (Union, Intersect, Minus), Special Operations (Selection,Projection,join,division)

Functional Dependency: Dependencies

types of functional dependencies

Logical implications

Logical implications in rdbms

Closure set

Closure set, Testing if FD is in closure

Covers with example

Covers, Non redundant and Minimum cover, Canonical cover

Normalization in dbms

First, Second, Third Normal Forms, Boyce-Codd Normal Form, Multi-valued Dependencies and Fourth Normal Form, Join Dependencies and Fifth Normal Form,

DKNF in dbms

Domain key Normal form

Cursors in PL/SQL dbms

Implicit Cursor,Explicit Cursor,Difference between IMPlicit Cursor and Explicit Cursor

Difference between SQL and PL/SQL

Difference between SQL and PL/SQL

SQL Fundamentals

DDL, DML, DCL,TCL

Stored Procedures

Stored Procedures in DBMS

Stored Functions

Stored Functions in DBMS

DBMS TRIGGERS

TRIGGERS in DBMS