Concept: A Database Management System (DBMS) is the tool that centrally controls data, thereby solving redundancy, inconsistency, dependence, and unauthorized access problems.
Explanation:Data redundancy means the same information is stored in more than one location.
A DBMS reduces this by storing data once and making it available to authorized users.
Data inconsistency occurs when separate copies of a record contain conflicting values.
By centralizing updates, a DBMS ensures that every user views the current and accurate data.
Data dependence means application programs are affected when the physical storage of data changes.
A DBMS removes this dependence by separating the logical data structure from the physical storage details.
Unauthorized access is controlled through DBMS security features such as passwords, user accounts, and access privileges.
Tables and database structures alone do not provide all of these controls.
Production passwords protect access only and do not handle redundancy or inconsistency.
The DBMS is the total solution because it manages data storage, integrity, and security together.
Answer: B. DBMS