Consider the relational algebra expression:

Assume that the join is based on the department identifier and that the condition Dept='CSE' refers only to attributes of DEPARTMENT. Which transformation is generally beneficial for reducing the number of tuples participating in the join?

Consider the SQL query:

SELECT Name
FROM STUDENT
WHERE Department = 'CSE';

Which relational algebra expression correctly represents this query?

Which of the following statement(s) about BCNF is/are true?

Which of the following best describes a lossless-join decomposition?