Q1. Define the term relational completeness? List all the five fundamental relational algebra operations. describe why are they termed as the basic operations? Deduce natural join between the two relations R1(A, B, C) and R2(B,C, D) in terms of fundamental relational algebra operations.
Q2. Let consider the given relational database schema:
ITEM (Item_No, Item_Name, Item_Type, Item_Price, Item_Stock)
CUSTOMER(Customer_No, Customer_Name, Customer_Job, Customer_Address)
BILL(Bill_No, Bill_Date, Customer_No, Item_No, Quantity)
Express the given queries in the Relational Algebra:
a) Find out the customer names that have the same job as the customer named John.
b) Find out the customer names who have bought at least two items.
c) Find out the item names bought by the customer whose job is Engineer.
d) Find out the customer names who have bought all the toy type items.