Question

Which of these properties reduces the duplication of data when we use RDBMS?

Efficiency
Redundancy
Speed
Search Flexibility​

Answer 1

Answer:

Entity integrity confirms that the rows are not duplicated in the table. Domain integrity makes sure that data is entered into the table based on specific conditions, such as file format or range of values. Referential integrity ensures that any row that is re-linked to a different table cannot be deleted.

Answer 2

Answer:

A DBMS can reduce data redundancy and inconsistency by minimizing isolated files in which the same data are repeated. ... Access and availability of information can be increased and program development and maintenance costs can be reduced because users and programmers can perform ad hoc queries of data in the database.