Computer Science · Database Management Systems

Which of the following statements are correct regarding the necessity of relational decomposition in a Database Management System? A. It removes data redundancy to ensure that the same fact is not stored multiple times. B. It involves splitting a relation into two or more smaller relations to eliminate update, insert, and delete anomalies. C. It systematically creates broader tables that store information about multiple entities simultaneously. D. It is systematically executed in order to achieve higher normal forms.