Which factor can mitigate the problems of increased complexity that come with using a DBMS?
A) writing complex access rules
B) using large file sizes
C) sound database design
D) using no integrity constraints

Question

Quizplus · Accepted Answer

Sound database design can help in mitigating the problems of increased complexity that come with using a DBMS. Proper design includes normalization, indexing, and establishing relationships between tables. This helps in ensuring data consistency, reducing redundancy, and improving data accuracy. Therefore, it is important to focus on database design to avoid complexity issues.

Option A (writing complex access rules) is not a good choice as this can increase complexity further by making it difficult for users to access the data they need.

Option B (using large file sizes) is also not a good choice as it can make it more difficult to manage and store data efficiently.

Option D (using no integrity constraints) is not a good choice as it can lead to inconsistencies and errors in the data, making it difficult to maintain and work with the database.

Which Factor Can Mitigate the Problems of Increased Complexity That