Denormalize the following three tables, into one table called tbl location tbl state contains (state id,state name) tbl county contains (conty id,county name) tbl city contains (city id,city name) Discuss the steps you took to create the new tbl location table and if the new table design increased ...

The Answer is in the image, click to view ...

Denormalize the following three tables, into one table called tbl_location: tbl_state contains (state_id,state_name) tbl_county contains (conty_id,county_name) tbl_city

Fantastic news! We've Found the answer you've been seeking!

Denormalize the following three tables, into one table called tbl_location:
- tbl_state contains (state_id,state_name)
- tbl_county contains (conty_id,county_name)
- tbl_city contains (city_id,city_name).
Discuss the steps you took to create the new tbl_location table and if the new table design increased or decreased the performance of the query.