https://community.developer.cybersource.com/t5/Integration-and-Testing/Normalisation-of-dataset-with-two-primary-keys/m-p/73933#M45865 <P class="_1qeIAgB0cPwnLhDF9XSiJM">I have an assignment where I have to normalise a dataset and design a schema in MySQL. Two of the 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 which just contains these two attributes, and to use only one of them as a foreign key for joins to all other tables.</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">There is a similar issue with some other attributes, specifically that there are attributes representing location as latitude and longitude as well as attributes that define the same location but with a different numbering system (it's a district-based co-ordinate system). Same question as above - how do I satisfy lossless decomposition for these attributes?</P> Tue, 10 Nov 2020 08:56:17 GMT Berlin77 2020-11-10T08:56:17Z https://community.developer.cybersource.com/t5/Integration-and-Testing/Normalisation-of-dataset-with-two-primary-keys/m-p/73933#M45865 <P class="_1qeIAgB0cPwnLhDF9XSiJM">I have an assignment where I have to normalise a dataset and design a schema in MySQL. Two of the 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 which just contains these two attributes, and to use only one of them as a foreign key for joins to all other tables.</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">There is a similar issue with some other attributes, specifically that there are attributes representing location as latitude and longitude as well as attributes that define the same location but with a different numbering system (it's a district-based co-ordinate system). Same question as above - how do I satisfy lossless decomposition for these attributes?</P> Tue, 10 Nov 2020 08:56:17 GMT https://community.developer.cybersource.com/t5/Integration-and-Testing/Normalisation-of-dataset-with-two-primary-keys/m-p/73933#M45865 Berlin77 2020-11-10T08:56:17Z