Introduction,Characterstics of DBMS,
Advantages and Disadvantages
handwritten notes of
Components of DBMS
handwritten notes of
Three level
Architecture
Hierarchical Model ,Operations of Hierarchical Model
Advantages and Disadvantages of Hierarchical Model
Network Model ,Operations of Network Model
Advantages and Disadvantages of Network Model
Relational Model terminology ,Operations of Relational Model
Advantages and Disadvantages of Relational Model
Difference Between Network, Hierarchical and Relational Model
Entity Types, Entity Sets, Attributes & Keys, Relationships, Relationship Types,cardinality ,connectivity of relationship
Set Operations (Union, Intersect, Minus),
Special Operations
(Selection,Projection,join,division)
types of functional dependencies
Logical implications in rdbms
Closure set, Testing if FD is in closure
Covers with example
First, Second, Third Normal Forms, Boyce-Codd Normal Form, Multi-valued Dependencies and Fourth Normal Form, Join Dependencies and Fifth Normal Form,
Domain key Normal form
Implicit Cursor,Explicit Cursor,Difference between IMPlicit Cursor and Explicit Cursor
Difference between SQL and PL/SQL
DDL, DML, DCL,TCL
Stored Procedures in DBMS
Stored Functions in DBMS
TRIGGERS in DBMS