Give the relational algebra ( not SQL ) expressions for the following queries Show the Customer(s) who
Fantastic news! We've Found the answer you've been seeking!
Question:
Give the relational algebra (not SQL) expressions for the following queries
- Show the Customer(s) who did not purchase any item (*Show the Customer_No only)
- Show the name of items purchased by "VIP" Customers
- Show the "Wholesale" Customers who have purchased any item on 01-01-2022 (*Show the Customer_No only)
- Examine the following relational algebra, and answer the following questions:
Customer_No, L_Name (Customer)
L_Name, Employee_No (Employee)
- Why is the relational algebra statement above incorrect?
- Rewrite the statement to correct the error. (* you may make an assumption here)
Related Book For
Accounting for Decision Making and Control
ISBN: 978-0078025747
8th edition
Authors: Jerold Zimmerman
Posted Date: