Question 1
Consider the following five database-like records with unique fields (ID, Name, City, Score). Using the clues, determine relationships and answer:
- The record with ID 395 has a higher score than the record from Bengaluru.
- Fatima's score is not the lowest.
- The person from Delhi has an ID greater than 920.
Question: Which city corresponds to the highest score?
Relational Reasoning (DB-style)
Think in terms of unique-key constraints across fields (ID, Name, City, Score).
ID | Name | City | Score
--- | --- | --- | ---
505 | Ira | Hyderabad | 77
245 | Gaurav | Bengaluru | 85
423 | Fatima | Chennai | 75
395 | Mira | Delhi | 87
920 | Xavier | Mumbai | 81
Use comparative score clues and ID inequalities to identify maxima/minima.
Verification:
- The record with ID 395 has a higher score than the record from Bengaluru.
- Fatima's score is not the lowest.
- The person from Delhi has an ID greater than 920.
Think in terms of unique-key constraints across fields (ID, Name, City, Score).
ID | Name | City | Score
--- | --- | --- | ---
505 | Ira | Hyderabad | 77
245 | Gaurav | Bengaluru | 85
423 | Fatima | Chennai | 75
395 | Mira | Delhi | 87
920 | Xavier | Mumbai | 81
Use comparative score clues and ID inequalities to identify maxima/minima.
Verification:
- The record with ID 395 has a higher score than the record from Bengaluru.
- Fatima's score is not the lowest.
- The person from Delhi has an ID greater than 920.