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 6
Create a city listing that also displays the related state name.
- Add an Add City button above the table.
- List Id, City Name, State Name, Is Capital, and Remove.
- Join City with State to display StateName.
- Show a friendly empty state when no cities exist.