Relational Operations (Relational Algebra)

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

Tutor description

The first four operations are taken from mathematical set theory and are largely the same as the operations found there. The next four are new operations that apply specifically to the relational data model.

Word Count: 1401
Showing Page: 1/6
Relational Operations (Relational Algebra)1. Union 2. Intersection 3. Difference 4. Product 5. Select 6. Project 7. Join The first four operations are taken from mathematical set theory and are largely the same as the operations found there. The next four are new operations that apply specifically to the relational data model. The "Assignment" operation is the standard computer language operation of giving a name to a value.Interestingly enough the "Data Management" text refers to restrict as a relational algebra operation. The operation "Select" does what restrict does. So for the purposes of this class the nine operations listed above are what we will recognize as relational algebra operations.Union - The union of two relations is formed by adding the tuples from one relation to those of a second relation, to create a third relation. Example:Table 1SnumNameMajor123JonesHistory158ParksMath271SmithHistoryTable 2NumberNameInterest105AndersonManagement123JonesHistoryResult of Table 1 + Table 2Snum or NumberNameMajor or Interest123JonesHistory158ParksMath271SmithHistory105AndersonManagementNote that tuple [123, Jones, History] which occurs in both Table 1 and Table 2 is not duplicated in the union. Relations must have the same number of attributes and those attributes must have like domains.The union operation in relation algebra is accomplished using the union operator ?. Union is a binary operator it oper

Review from student

Studypool Student
" Outstanding Job!!!! "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1831 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