Which of the following is a valid consideration when implementing physical database design?
A)normalization diminishes database integrity
B)normalized views of the data improve query performance
C)all relationships should be explicitly defined in the database
D)it's best to use data types that require conversion

Question

Quizplus · Accepted Answer

Normalization aims to reduce redundancy and improve data integrity, not diminish it. Normalized views can sometimes slow down query performance due to the need for joining tables. Explicitly defining all relationships in the database helps maintain data integrity and supports efficient data retrieval. Using data types that require conversion can lead to performance issues and complexity; it's generally best to use appropriate data types that match the data being stored.

Which of the Following Is a Valid Consideration When Implementing