This table contains data regarding U.S. cities, and some of their demographic data; it employs a composite primary key composed of the combination of CITY andSTATE (since city names like "Portland" can apply to more than one city). Applysecond normal formto this table. You will need to ensure that all non-key columns are dependent on the whole key, not just part of it; any columns not meeting this requirement must be removed and placed into a separate table. Note that the primary key of this new table will be that portion(s) of the original primary key on which the removed columns are dependent; this will become a foreign key linked to the original table. Be sure to eliminate any duplicate data that might result from creation of your new table. Don't forget to label the primary key of any resulting new tables inRED and any FKs have (FK) after the names.
	CITY	STATE	POPULATION	CITYAREA	MAYOR	GOVERNOR
	Dallas	TX	1,341,075	340.9	Eric Johnson	Greg Abbott
	Austin	TX	950,715	312.7	Kirk Watson	Greg Abbott
	Portland	OR	647,805	133.5	Ted Wheeler	Tina Kotek
	Salem	OR	169,798	48.6	Chris Hoy	Tina Kotek
	Portland	ME	66,937	69.44	Mark Dion	Janet Mills