Question

    Which of the following techniques is used to ensure that a database design eliminates redundant data?

    A Data Warehousing Correct Answer Incorrect Answer
    B Data Mining Correct Answer Incorrect Answer
    C Normalization Correct Answer Incorrect Answer
    D Indexing Correct Answer Incorrect Answer
    E Partitioning Correct Answer Incorrect Answer

    Solution

    Normalization is the process of organizing a database to reduce redundancy and improve data integrity. It involves dividing large tables into smaller, related tables and defining relationships between them. This reduces data duplication and ensures that data is stored efficiently, making updates and deletions easier and more reliable. a) Data Warehousing involves collecting and managing large amounts of data but does not specifically target redundancy. b) Data Mining involves analyzing large datasets to discover patterns and trends, not reducing redundancy. d) Indexing improves the speed of data retrieval but does not address redundancy. e) Partitioning involves dividing a database into smaller segments for easier management but does not eliminate redundancy.

    Practice Next