Skip to content


DBMS/U3 Topic 3 PL/SQL: Introduction

PL/SQL is a block structured language that enables developers to combine the power of SQL with procedural statements.All the statements of a block are passed to oracle engine all at […]

DBMS/U2 Topic 10 SQL: Derived Relations

SQL-92 allows a subquery expression to be used in the from clause. If such an expression is used, the result relation must be given a name, and the attributes can be renamed. […]

DBMS/U2 Topic 8 SQL: Aggregate functions

Aggregate Functions are all about Performing  calculations on multiple rows Of a single column of a table And returning a single value. The ISO standard defines five (5) aggregate functions […]

DBMS/U2 Topic 7 SQL: Set Operations

SQL supports few Set operations which can be performed on the table data. These are used to get meaningful results from data stored in the table, under different special conditions. […]

DBMS/U2 Topic 3 ER-Model: ER Diagram

Entity Relationship Diagram, also known as ERD, ER Diagram or ER model, is a type of structural diagram for use in database design. An ERD contains different symbols and connectors […]