State true or false for the following statement:

, holds for both sets and bags.

Assuming set semantics, State true or false for the following statement:

The grouping operator 𝛾 (gamma) can do duplicate elimination.

Consider the following university database schema:

Student (SID, Name, Age, Major, GPA)

Course (CID, Title, Department, Credits)

Enrollment (SID, CID, Semester, Grade)

Professor (PID, Name, Department, Salary)

Teaches (PID, CID, Semester)

Which of the following relational algebra expression(s) will retrieve the titles of all courses offered by the 'Mathematics' department. (Note: there can be more than expressions)

What is the primary key in an ER model?

Consider the following university database schema:

Student (SID, Name, Age, Major, GPA)

Course (CID, Title, Department, Credits)

Enrollment (SID, CID, Semester, Grade)

Professor (PID, Name, Department, Salary)

Teaches (PID, CID, Semester)

Which of the following relational algebra expression(s) will Retrieve the names of students with an 'A' grade in at least one course? (Note: there can be more than expressions)

In an ER diagram, a double rectangle is used to represent?

State true or false for the following statement:

holds for both sets and bags.

Consider the following university database schema:

Student (SID, Name, Age, Major, GPA)

Course (CID, Title, Department, Credits)

Enrollment (SID, CID, Semester, Grade)

Professor (PID, Name, Department, Salary)

Teaches (PID, CID, Semester)

Which of the following relational algebra expression(s) will Retrieve the names of professors who teach at least one course? (Note: there can be more than expressions)

Assuming set semantics, State true or false for the following statement:

The operator ⋈ is a combination of (σ, Π, x).

Consider the following university database schema:

Student (SID, Name, Age, Major, GPA)

Course (CID, Title, Department, Credits)

Enrollment (SID, CID, Semester, Grade)

Professor (PID, Name, Department, Salary)

Teaches (PID, CID, Semester)

Which of the following relational algebra expression(s) will Find students who have taken both Course C1 and Course C2? (Note: there can be more than expressions)