Lecture Note

Relational Algebra PAGE NO. 10/8/21 DATE Basic Operator:- I: Projectorion 2) r : Selection 3) X : Cross Product 4) U : Union 5) a : Intessation 6) (-) : Except / set Difference 7) P : Rename a) / : Division 9) x : Join

PAGE NO. DATE: Union :-(u) :- To we set operator relation must be union compatible Eg:- R(A, A2, A3 An) RSCB, , B2, Bm) R $ S union compatible iff Arity Coo. of columns) of R $ 2 must be same(n=m) R A B C S C.D.F 245 245 346 7.16 2 8.4 I RUS = A BC 245 346 384 76 2 Representing Union 8- RUS ={x/ x ER V X ES} OR (if both the Cardinality:- Colum elements are same) min :- max(n,m) max :- mtn-xif both the column elements are diff")

DATE: 2) Intersection (n) :- R A B C 6, c D E 2 45 245 B 4 6 365 3 8 4 RDS = A B C 2 45 Cardinality : min:- O.- (if there is no common ele in both max :- min(m,n.) colm) -

- Chapter 9.1 The Pythagorean theorem
- Chapter 12.1 Sample Spaces and Probability
- 2.3 - Continuity
- 2.2 - Infinite Limits
- 2.1 - Introduction to Limits
- Tabular Integrations
- Rules of Differentiation
- Linear Function
- General Form Function
- Define Integrals
- Algebraic Expressions
- General Prime Numbers
- Primality Test
- Imaginary Numbers
- The Matrix (Mathematics)

Introduction to Relational Algebra Operators and Set Operations

Please or to post comments