Normalization of the dataset with two primary keys
I have an assignment to normalize a dataset and design a schema in MySQL. Two attributes are unique identifiers for each tuple (that is, they are each primary keys in their own right). How do I satisfy lossless decomposition? I'm thinking of making a table containing these two attributes and using only one of them as a foreign key to join all other tables.
There is a similar issue with some other attributes, specifically that there are attributes representing location as latitude and longitude and features that define the same place but with a different numbering system (it's a district-based coordinate system). Same question as above - how do I satisfy lossless decomposition for these attributes?