Relational Algebra

Based on the figure above, identify the number of tuples that will be returned by the following relational algebra query :  $\sigma\$ Type = 'Saving' (Account)

• 2

• 3

• 6

• 0

Tags

CCSS.HSA.SSE.A.1

Choose the CORRECT symbol of SELECT in the Relational Algebra

• x

• $\pi$

• $\cap$

• $\sigma$

Identify the CORRECT output for table (Student Difference Lecturer) or (Student - Lecturer) in table above

• 
• 
• 
• 

Tags

CCSS.HSA.CED.A.2

CCSS.HSA.CED.A.3

CCSS.HSA.REI.D.11

Write the CORRECT relational algebra expression base on the figure above

• $\pi$ managerID, managerName ( $\sigma$ workExprience = 5) (MANAGER)

• $\sigma$ managerID, managerName ( $\pi$ workExprience = 5) (MANAGER)

• $\sigma$ managerID, managerName ( $\pi$ workExprience > 5) (MANAGER)

• $\pi$ managerID, managerName ( $\sigma$ workExprience > 5) (MANAGER)

Tags

CCSS.HSA.CED.A.2

Write the relational algebra to list student's number and student'a name whose age is 20 years old or state in Terengganu.

• $\pi$ StudentID, Name ( $\sigma$ Age=20 AND State = "Terengganu" (STUDENT)

• $\pi$ StudentID, Name ( $\sigma$ Age=20 OR State = "Terengganu" (STUDENT)

• $\sigma$ StudentID, Name ( $\pi$ Age=20 AND State = "Terengganu" (STUDENT)

• $\sigma$ StudentID, Name ( $\pi$ Age=20 OR State = "Terengganu" (STUDENT)

Tags

CCSS.HSA.CED.A.4

Base on the table given, identify output that will be produced when, σ _{Salary > 3000 ˅ City = ‘Batu Pahat’} (WORKER).

• 
• 
• 
• 

Tags

CCSS.HSA.CED.A.1

CCSS.HSA.CED.A.3

CCSS.HSA.REI.B.3

CCSS.HSA.SSE.A.1