Multiple choice technology databases

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 accepted as the practical target for database normalization in production systems. 3NF eliminates most redundancy and update anomalies while maintaining reasonable performance. First and second normal forms are intermediate steps, and flat files lack normalization entirely. Going beyond 3NF to BCNF or 4NF is rarely necessary for most business applications.

Keep practicing — related questions