Question
Relational Algebra ; Use the following two relation to answer the questions bellow: Your answers should the row/tuples that will placed in the result set
Relational Algebra ;
Use the following two relation to answer the questions bellow:
Your answers should the row/tuples that will placed in the result set of the operation being performed on both tables.
TableA
CustNum
CustName
148
Ai's Appliance and Sport
282
Brookings Direct
356
Fegusons
408
The Everything Shop
463
Bargains Galore
524
Klines
725
Deerfields Water
842
Allseason's travel
701
Peter's Construction
TableB
CustNum
CustName
148
Ai's Appliance and Sport
300
Brookings Direct
356
Fegusons
400
The Everything Shop
463
Bargains Galore
524
Klines
Write the return relations for the following Set Operators:
TableA UNION TableB
TableA INTERSECT TableB
First list the relation for the TableA DIFFERENCE TableB
Then list the relation for the TableB DIFFERENCE TableA
Write the return relations to represent the result sets for the following JOIN (Equi-Join) operations;
TableA INNER JOIN TableB ON TableA.CustNum = TableB.CustNum
TableA LEFT OUTER JOIN TableB ON TableA.CustNum = TableB.CustNum
TableA RIGHT OUTER JOIN TableB ON TableA.CustNum = TableB.CustNum
TableA FULL OUTER JOIN TableB ON TableA.CustNum = TableB.CustNum
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Databases Illuminated
Authors: Catherine M. Ricardo, Susan D. Urban, Karen C. Davis
4th Edition
1284231585, 978-1284231588
