Normalize the table (1st normalform, 2nd normal form, 3rd normal form) create as many tables as necessary such that all new tables are in third normal form. All transitive and derived dependecies must be removed.

Suppose that our database has the following table. Person ID Name Pop Size code Name Rgn Size Pop Code Name Size SSN Name|Age DofB Add Field Explanation: Con: Stands for Country Pop: Stands for population Rgn: Stands for region (like west, east, central, etc.) Cty: Stands for City Per: Stands for Person DofB: Stands for date of birth Add: Stands for Address It is assumed that Every country in the world has a different country ID Every city in the world has a different city code Every state in the world has a different state code, and Every person in the world has a different SSN Every person in the world has only one citizenship and has only one address - - - Other Assumptions: There is no village, county, area, etc. A country consists of several states and each state has several cities