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 12
Prevent accidental removal of a state that is referenced by City records.
- Before deleting a state, count its related cities.
- If the count is greater than zero, do not delete.
- Show a clear message explaining that its cities must be removed first.
- Allow deletion when no city references the state.