Given the relations:
Orders (OrderID, CustomerID, OrderDate)
Customers (CustomerID, Name, Address)
Choose the correct relational algebra expression to retrieve the names of customers who placed orders in 2022.

Question

Given the relations: 
 Orders (OrderID, CustomerID, OrderDate) 
 Customers (CustomerID, Name, Address) 
 Choose the correct relational algebra expression to retrieve the names of customers who placed orders in 2022.

Accepted Answer

π (Name) (σ (OrderDate >= '2022-01-01' ∧ OrderDate <= '2022-12-31') (Orders ∞ Customers))

Answer

π (Name) (Customers ∩ Orders)

Answer

π (Name) (σ OrderDate >= '2022 (Orders ∞ Customers)

Answer

σ (OrderDate >= '2022-01-01' ∧ OrderDate <= '2022-12-31') (Customers)

Crowdly

Given the relations: Orders (OrderID, CustomerID, OrderDate) Customers (Cust...

Want instant access to all verified answers on moovit.vit.ac.in?