Join Operations

 Joint Operations:A join operation combines related tuples from different relations, if and only if a given join condition is satisfied. It is denoted by ⋈.Example:EMPLOYEEEMP_CODEEMP_NAME101Stephan102Jack103HarrySALARYEMP_CODESALARY101500001023000010325000Operation: (EMPLOYEE ⋈ SALARY)   Result:EMP_CODEEMP_NAMESALARY101Stephan50000102Jack30000103Harry25000Types...

Read More

Relational Algebra

Relational AlgebraRelational algebra is a procedural query language. It gives a step-by-step process to obtain the result of the query. It uses operators to perform queries.Types of Relational operation1. Select Operation:The select operation...

Read More