Skip to content


DBMS/U4 Topic 9 Concurrency, ACID Properties

Concurrency Control deals with interleaved execution of more than one transaction. In the next article, we will see what serializability is and how to find whether a schedule is serializable or not. What […]

DBMS/U4 Topic 5 Normal Forms NF3

Requirements for Third Normal Form For a table to be in the third normal form, It should be in the Second Normal form. And it should not have Transitive Dependency. […]

DBMS/U4 Topic 4 Normal Forms NF2

For a table to be in the Second Normal Form, it must satisfy two conditions: The table should be in the First Normal Form. There should be no Partial Dependency. […]

DBMS/U4 Topic 3 Normal Forms NF1

If tables in a database are not even in the 1st Normal Form, it is considered as bad database design. Rules for First Normal Form The first normal form expects you […]

DBMS/U4 Topic 2 Functional Dependencies

In relational database theory, a functional dependency is a constraint between two sets of attributes in a relation from a database. In other words, functional dependency is a constraint that […]

DBMS/U4 Topic 1 Relational Algebra

Relational algebra is a procedural query language, which takes instances of relations as input and yields instances of relations as output. It uses operators to perform queries. An operator can […]

DBMS/U3 Topic 11 PL/SQL: LOB’S

Large Objects (LOBs) are a set of datatypes that are designed to hold large amounts of data. A LOB can hold up to a maximum size ranging from 8 terabytes to […]

DBMS/U3 Topic 10 PL/SQL: Cursors

Oracle creates a memory area, known as the context area, for processing an SQL statement, which contains all the information needed for processing the statement; for example, the number of […]

DBMS/U3 Topic 9 PL/SQL: Functions

A function is same as a procedure except that it returns a value. Therefore, all the discussions of the previous chapter are true for functions too. Creating a Function A […]

DBMS/U3 Topic 8 PL/SQL: Procedures

A subprogram is a program unit/module that performs a particular task. These subprograms are combined to form larger programs. This is basically called the ‘Modular design’. A subprogram can be invoked by […]

DBMS/U3 Topic 7 PL/SQL: Triggers

Triggers are stored programs, which are automatically executed or fired when some events occur. Triggers are, in fact, written to be executed in response to any of the following events […]

DBMS/U3 Topic 6 PL/SQL: Exceptional Handling

An exception is an error condition during a program execution. PL/SQL supports programmers to catch such conditions using EXCEPTION block in the program and an appropriate action is taken against the error […]