GATE Question (GATE CSE 1992 | Question: 13b) Suppose we have a database consisting of the following three relations: FREQUENTS(Customer, Hotel): Indicates the hotels each customer visits. SERVES(Hotel, Snack): Tells which snacks each hotel serves. LIKES(Customer, Snack): Indicates which …
Original Question GATE CSE 1990 Question 2(iv): Consider the following relational algebra expression: πA(R ⋈ (S ⋈ T)) where R, S, and T are relations, and A is a set of attributes. Suggest how this expression can be optimized. Detailed …
