University:
College
Course:
College Mathematics
Academic year:

2023
Views:

360

Pages:

3
Author:

Avaiya P.

Relational AlgebraPAGE NO.10/8/21DATEBasic Operator:-I: Projectorion2)r : Selection3)X : Cross Product4) U : Union5)a : Intessation6)(-): Except / set Difference7) P : Renamea) / : Division9) x : Join PAGE NO.DATE:Union :-(u) :- To we set operatorrelation must be unioncompatibleEg:-R(A, A2, A3 An)RSCB, , B2, Bm)R $ S union compatible iffArity Coo. of columns) of R $ 2 mustbe same(n=m)RA B CSC.D.F2452453467.16 28.4IRUS =ABC24534638476 2Representing Union 8-RUS ={x/ x ER VX ES}OR(if both theCardinality:-Colum elementsare same)min :- max(n,m)max :- mtn-xif both thecolumn elementsare diff") DATE:2)Intersection (n) :-RABC6,cDE245245B 4 63653 8 4RDS =ABC245Cardinality :min:- O.- (if there isnocommon elein bothmax :- min(m,n.)colm)-