How to get the last element of a list in Python? Part II
In the previous article we discussed all the methods which used indexing implemented in a more manual way. In this
Function Overloading in Python
Function Overloading: If a class has multiple functions with same names but different parameters, then they are said to be
Generalized Projection Operation, Aggregation Operation in Python
Let’s consider the following table and understand these operations with examples. R1 : FACULTY-1FNo FName DNo Qual Salary22 Riya 21 Ph.D 5500024 Priya 22 M. Tech 5000025 Zayn 22 M. Tech 4200027 Harry 23 M. Tech 2800030 Sia 23 M. Tech 3200033 Max 24 Ph.D 5300035 Fred 24 Ph.D 5200037 Diva 25 M.
Renames Operation ( ρ ) in Python
Consider the following expression. ρx (E) Here, this operator gives the name ‘x’ to the result of the relational algebra expression E. Consider
Natural Join Operation, Assignment Operation in Python
Natural Join Operation ( |X| ):This operation combines one tuple from relation-1 with another tuple from relation-2, only when the
Set Difference, Set Intersection, Cartesian Product Operations in Python
Lets us understand these operations with some examples: Consider the following table: R1 : FACULTY-1FNo FName DNo Qual Salary22 Riya 21 Ph.D 5500024 Priya 22 M. Tech 5000025 Zayn 22 M. Tech 4200027 Harry 23 M. Tech 2800030 Sia 23 M. Tech 3200033 Max 24 Ph.D 5300035 Fred 24 Ph.D 5200037 Diva 25 M.
Union Operation ( U ) in Python
The ‘Union’ operation combines two relations without having duplicates. Let us understand the UNION operation better using some examples.Consider the following
Project Operation ( P ) in Python
The Project operation selects columns that are given as input. Let us understand the PROJECT operation better using some examples.Consider the
Select Operation (s) in Python
The Select operation selects tuples that satisfy a given predicate. Let’s understand this operation with few examples:Consider the following relation (R1)
The Relational Algebra in Python
The relational algebra is a ‘procedural query language’. It consists of a set of operations that accept one or two