Search Header Logo

Relational Algebra Concepts Worksheet

Authored by Latoya Walker-Holness

Computers

University

Used 1+ times

Relational Algebra Concepts Worksheet
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

12 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A company stores employee details in relation EMPLOYEE(name, dept, salary). To display only names and departments, which operation is used?

Selection

Projection

Join

Cartesian Product

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

To find all employees earning more than $50,000, which relational algebra operation should be applied?

Selection

Division

Union

Renaming

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

You have two relations: FULL_TIME_EMP and PART_TIME_EMP. To retrieve employees who are full-time but not part-time, which operation should be used?

Union

Difference

Cartesian Product

Selection

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

An analyst wants to rename the attribute "emp_name" in EMPLOYEE to "name" to standardize queries. Which operation should be applied?

Projection

Join

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

To merge student data from two distinct relations STUDENT_A and STUDENT_B with the same structure, you would use:

Join

Union

Division

Cartesian Product

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Two relations contain students enrolled in “Database” and “Networking.” You want a list of students enrolled in both. Which operation gives the common result set?

Difference

Projection

Intersection

Selection

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A professor wants to retrieve all students who registered for every available course. Which relational algebra operation is best suited for this scenario?

Cartesian Product

Division

Projection

Union

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?