MCQ IN COMPUTER SCIENCE & ENGINEERING

Detailed explanation-1: -In terms of relational database modeling, that consistency becomes a process of removing duplication in data. Removal of duplication tends to minimize redundancy and minimization of redundancy implies getting rid of unneeded data present in particular tables.

Detailed explanation-2: -Database management systems are also used in a variety of organizations. They receive direction from a database administrator (DBA) and allow the system to load, retrieve, or change existing data from the systems. Database management systems adhere to the rules of normalization, which reduces data redundancy.

Detailed explanation-3: -Leveraging master data ensures that an organization can update a single piece of information if it changes. This system ensures that redundant data remains up-to-date and offers the same information. Database normalization involves efficiently arranging data in a database to ensure redundancy elimination.

Detailed explanation-4: -Redundancy means having multiple copies of same data in the database. This problem arises when a database is not normalized.