https://community.developer.cybersource.com/t5/Integration-and-Testing/Normalization-of-the-dataset-with-two-primary-keys/m-p/86655#M54532 <P>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.</P><P>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?</P> Wed, 31 May 2023 08:56:43 GMT perton 2023-05-31T08:56:43Z https://community.developer.cybersource.com/t5/Integration-and-Testing/Normalization-of-the-dataset-with-two-primary-keys/m-p/86655#M54532 <P>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.</P><P>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?</P> Wed, 31 May 2023 08:56:43 GMT https://community.developer.cybersource.com/t5/Integration-and-Testing/Normalization-of-the-dataset-with-two-primary-keys/m-p/86655#M54532 perton 2023-05-31T08:56:43Z