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 …
Gate Question State True or False with reason: Logical data independence is easier to achieve than physical data independence. Answer and Explanation Answer: False Logical data independence is actually more difficult to achieve than physical data independence. Let’s explore why …
