Rel algebra set theory girija

50 %
50 %
Information about Rel algebra set theory girija
Education

Published on March 10, 2014

Author: nbgirija

Source: slideshare.net

Description

set theory, relational algebra, union, intersection, difference, sql, database

Relational Algebra Operations Set theory Unary relational operation Binary relational operation

Symbolic Notation use symbolic notation to represent the operators. UNION -> ∪ (cup) SELECT ->σ (sigma) INTERSECTION -> ∩(cap) PROJECT -> π(pi) DIFFERENCE -> - (minus) PRODUCT -> ×(times) RENAME ->ρ (rho) JOIN -> |×| (bow-tie) (AND) -> ^ Not -> (OR) -> v

S2-S1

EXERCISE 1 R∪S R∩S R–S S-R

EXERCISE 1 -RESULT

EXERCISE 1 -RESULT

EXERCISE 1 -RESULT

EXERCISE 1 -RESULT

Exercise 2 R∪S

Exercise 2 - PRODUCT

Exercise 3

Exercise 3 - SOLUTION

Exercise 4 Graduates U managers Graduates – managers Managers - graduates Graduates ∩ managers

Exercise 4 - Solution

Exercise 4 - Solution

Exercise 4 - Solution

Exercise 5

Exercise 5 solution

Exercise 6

Exercise 7

Exercise 7 - solution

Add a comment

Related presentations

Related pages

rel algebra projection - YouTube

relational algebra projection, selection, database, set theory. ... database, set theory. Category ... rel algebra using product ...
Read more

rel algebra using product - YouTube

... http://www.slideshare.net/nbgirija/rel ... set theory, database, relational algebra,this video content is available ... rel algebra using ...
Read more

Set theory - Wikipedia, the free encyclopedia

Although any type of object can be collected into a set, set theory is applied ... and real numbers can be derived within set theory, ... algebra, and ...
Read more

Real algebraic geometry - Wikipedia, the free encyclopedia

... of semialgebraic sets. Real algebraic ... real algebra to real algebraic geometry is similar ... theory. Timeline of real algebra and ...
Read more

Set Theory, laws Of Set Theory | MathCaptain.com

Set theory deal with the properties of the set. ... Algebra; Algebra 2; Set Theory; ... Solution Sets: Probability Theory:
Read more

AN INTRODUCTION TO SET THEORY - Home » Department of ...

AN INTRODUCTION TO SET THEORY ... function from the set of real numbers ... written in the language of set theory stating that for each set x and each ...
Read more

Projection Relational Algebra - World News

... RELATIONAL ALGEBRA- SELECT OPERATION (DBMS-9), rel algebra projection, FRAI: ... Projection (relational Algebra) remove the playlist. Latest Videos;
Read more

Introduction to Sets - Math is Fun - Maths Resources

Introduction to Sets. ... Graph Theory, Abstract Algebra, Real Analysis, Complex Analysis, Linear Algebra, Number Theory, and the list goes on.
Read more

Sets and Set Theory - Math Goodies

Sets and Set Theory: ... Connections to other disciplines and to the real world are made throughout. Lessons on Sets: Description: Introduction:
Read more