📢 Too many exams? Don’t know which one suits you best? Book Your Free Expert 👉 call Now!

  • google app store apple app store
  • ✖

      Question

      What is 'normalization' in database

      design?
      A Converting all data in a database to a single numeric format Correct Answer Incorrect Answer
      B Distributing a database across multiple physical servers Correct Answer Incorrect Answer
      C Encrypting all sensitive columns in a database table Correct Answer Incorrect Answer
      D Creating indexes on all columns to improve query performance Correct Answer Incorrect Answer
      E The process of organizing a database to reduce data redundancy Correct Answer Incorrect Answer

      Solution

      Normalization applies rules (normal forms: 1NF, 2NF, 3NF, BCNF, 4NF) to eliminate data redundancy, update anomalies (insertion, deletion, modification anomalies), and functional dependency issues. For example, storing a customer's branch name repeatedly in every transaction record is redundant — normalization separates this into a Branches table. Denormalization is sometimes done intentionally for read performance in data warehouses.

      Practice Next

      Relevant for Exams:

      ask-question