Multiple choice technology architecture

Most RDB designers will accept that in order to deal with the complexities of "real life" transactions, a design needs to reach

  1. third normal form

  2. the standard of a flat file

  3. second normal form

  4. first normal form
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Third normal form (3NF) is widely regarded as the practical standard for production database design. It removes transitive dependencies where non-key attributes depend on other non-key attributes, which eliminates most update anomalies while avoiding the performance complexity of higher normal forms.

Keep practicing — related questions