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 840 has a higher score than the record from Hyderabad.
- Hina's score is not the lowest.
- The person from Chennai has an ID greater than 519.
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
--- | --- | --- | ---
149 | Rhea | Bengaluru | 86
840 | Gaurav | Hyderabad | 96
101 | Hina | Delhi | 94
794 | Bhavya | Chennai | 92
519 | Fatima | Mumbai | 83
Use comparative score clues and ID inequalities to identify maxima/minima.
Verification:
- The record with ID 840 has a higher score than the record from Hyderabad.
- Hina's score is not the lowest.
- The person from Chennai has an ID greater than 519.
Think in terms of unique-key constraints across fields (ID, Name, City, Score).
ID | Name | City | Score
--- | --- | --- | ---
149 | Rhea | Bengaluru | 86
840 | Gaurav | Hyderabad | 96
101 | Hina | Delhi | 94
794 | Bhavya | Chennai | 92
519 | Fatima | Mumbai | 83
Use comparative score clues and ID inequalities to identify maxima/minima.
Verification:
- The record with ID 840 has a higher score than the record from Hyderabad.
- Hina's score is not the lowest.
- The person from Chennai has an ID greater than 519.