SOLVED: A table contains repeating groups of data. What should be done to normalize this ...

A table contains repeating groups of data. What should be done to normalize this table to 1NF?

Remove multivalued attributes into separate tables

Eliminate partial dependencies by creating separate tables for each functional dependency

Remove transitive dependencies by ensuring non-key attributes depend directly on the primary key

Split the table to ensure no overlapping candidate keys

Verified Answer

Correct Option - b

To get all Infosys Certified Oracle Database Administrator - Beginner Exam questions Join Telegram Group https://grateful.prepflix.in/infy-lex-pdfs