State & City Management

States

IdState NameRemove

Add State


Cities

IdCity NameState NameIs CapitalInfoRemove

Add City


Find City Details


Business requirement — Database Operation 11

Let users view all cities, only capitals, or only non-capitals.

  1. Add All, Capital, and Non-capital choices.
  2. Apply the selected Boolean condition to the query.
  3. Combine it with the state and city-name filters.
  4. Update the results immediately when the value changes.