Question: Given the following database schema: Products ( ProductID , ProductName, CategoryID ) Categories ( CategoryID , CategoryName ) Sales ( SaleID , ProductID, SaleDate, Quantity,
Given the following database schema:
Products ProductID ProductName, CategoryID
Categories CategoryID CategoryName
Sales SaleID ProductID, SaleDate, Quantity, SaleAmount
Customers CustomerID CustomerName
Orders OrderID CustomerID, OrderDate
which relational algebra expression returns the names of
customers who have placed orders in
c CustomerName YEAROrderDateOrdersuCustomersCustomerIDOrders.CustomerID Customers
d none of these
e CustomerNameoYEAROrderDateOrderstimes Customers.CustomerIDOrders.CustomerID Customers
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
