all non-primary key columns must be directly dependent on the entire primary key and must be independent of each other. Think about the Country column for a moment. Given the Latitude and Longitude, you can easily derive the Country column. Even though the country where a superpower was sighted is dependent on the Name-Power composite primary key, it is only indirectly dependent on them. So, let's separate the location details into a separate countries table as follows:
