relational algebra

Knowledge: Which of the following is a basic operation in Relational Algebra?

• a. Union
• b. Intersection
• c. Difference
• d. All of the above

Knowledge: Which of the following is a binary operation in Relational Algebra?

• a. Selection
• b. Projection
• c. Cartesian Product
• d. Division

Comprehension: What does the Cartesian Product operation do in Relational Algebra?

• a. Combines two relations into a single relation
• b. Filters a relation based on a given condition
• c. Projects a relation onto a subset of its attributes
• d. Combines every tuple in one relation with every tuple in another relation

Comprehension: What does the Projection operation do in Relational Algebra?

• a. Combines two relations into a single relation
• b. Filters a relation based on a given condition
• c. Projects a relation onto a subset of its attributes
• d. Combines every tuple in one relation with every tuple in another relation

Application: Given two relations R(A,B) and S(B,C), what would be the resulting relation of the Cartesian Product R x S?

• a. R(A,B,C)
• b. R(A,C)
• c. R(B,C)
• d. None of the above

Application: Given the relation R(A,B,C), what would be the resulting relation after applying Projection to include only attributes A and B?

• a. R(A,B)
• b. R(A,C)
• c. R(B,C)
• d. None of the above

Analysis: Which operation would you use to combine two relations that have the same attributes into a single relation?

• a. Union
• b. Intersection
• c. Cartesian Product
• d. Join

Analysis: What is the difference between Union and Intersection in Relational Algebra?

• a. Union combines tuples from two relations while Intersection finds tuples that are common to both relations
• b. Intersection combines tuples from two relations while Union finds tuples that are common to both relations
• c. Union combines two relations into a single relation while Intersection filters a relation based on a given condition
• d. Intersection combines two relations into a single relation while Union filters a relation based on a given condition

Remembering: Which of the following operators in relational algebra is used to retrieve only specific columns from a table?

• Projection
• Selection
• Join
• Cartesian Product

Remembering: Which of the following operators in relational algebra is used to retrieve specific rows from a table?

• Projection
• Selection
• Join
• Cartesian Product