State & City Management
States
| Id | State Name | Remove |
|---|
Add State
Cities
| Id | City Name | State Name | Is Capital | Info | Remove |
|---|
Add City
Find City Details
Business requirement — Database Operation 11
Let users view all cities, only capitals, or only non-capitals.
- Add All, Capital, and Non-capital choices.
- Apply the selected Boolean condition to the query.
- Combine it with the state and city-name filters.
- Update the results immediately when the value changes.