3 ms·

First, you got it backwards: denormalization joins relations, normalization splits them; Second, if they share the same key, then it's not normalization, as th

• rco8786 10y ago
  In most cases that ends up being true but that's not the definition of either of those terms. Normalization is the process of organizing the attributes and relations to, among other things, eliminate redundancy. 2 relations that store and share the same primary key is by definition redundant. Splitting relations for the sake of skinnier tables is creating redundancy(the primary key is stored twice) and insert/update anomalies and can be reasonably thought of as a denormalizing behavior.