Relational Algebra Relational algebra is a procedural query language. It gives a step by step process to obtain the result of the…
sql introduction
-
-
SQL SQL stands for Structured Query Language. It is used for storing and managing data in relational database management system (RDMS). It…
-
Transaction The transaction is a set of logically related operation. It contains a group of tasks. A transaction is an action or…
-
File Organization Storage There are different ways of storing data in the database. Storing data in files is one of them. A…
-
Merge Join Algorithm The merge joins are used for performing natural joins and equi-joins for given relations r and s. We use…
-
Multiple Granularity Let’s start by understanding the meaning of granularity. Granularity: It is the size of data item allowed to lock. Multiple…
-
Relational Calculus There is an alternate way of formulating queries known as Relational Calculus. Relational calculus is a non-procedural query language. In…
-
SQL JOIN As the name shows, JOIN means to combine something. In case of SQL, JOIN means “to combine two or more…
-
Transaction property The transaction has the four properties. These are used to maintain consistency in a database, before and after the transaction.…
-
Foreign Key in DBMS A foreign key is different from a super key, candidate key or primary key because a foreign key…