Relational Algebra Features

May 29th, 2015
Studypool Tutor
Price: $10 USD

Tutor description

What is Relational Algebra?• It defines basic set of operations for manipulating relational data• It enables users for basic retrieval operations. • Result of any retrieval always gives another relation to manipulate

Word Count: 2214
Showing Page: 1/15
Relational Algebrais a set of relations closed under operators. Operators operate on one or more relations to yield a relation. Relational algebra is a part of computer science.Algebra > a formal structure consisting of sets and operations on those sets. Relational algebra is a formal system for manipulating relations. Operands of this algebra are relations. Operations of this algebra include the usual set operations (since relations are sets of tuples), and special operations defined for relations selection projection join Set Operations on RelationsFor the set operations on relations, both operands must have the same scheme, and the result has that same scheme. R1 U R2 (union) is the relation containing all tuples that appear in R1, R2, or both. R1 n R2 (intersection) is the relation containing all tuples that appear in both R1 and R2. R1 - R2 (set difference) is the relation containing all tuples of R1 that do not appear in R2. SelectionSelects tuples from a relation whose attributes meet the selection criteria, which is normally expressed as a predicate. R2 = select(R1,P) That is, from R1 we create a new relation R2 containing those tuples from R1 that satisfy (make true) the predicate P. A predicate is a boolean expression whose operators are the logical connectives (and, or, not) and arithmetic comparisons (LT, LE, GT, GE, EQ, NE), and whose operands are either domain names or domain constants. select(Workstation,Room=633) =

Review from student

Studypool Student
" Top quality work from this guy! I'll be back! "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1825 tutors are online

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors