Explain the concept of database normalization and why it is important in transactional systems versus analytical systems.
