normalization

Question

Is there any reason to design a database schema that is in 2NF,but is in no higher-order normal form?

Comments

actually i can't understand properly still , it depends on you . till which level u want the database to get optimized, if u have 2nf and think u don't care about transitive dependency it fine. but u really want to reduce that duplicay then u have to go to 3nf.

Answer 1

see it depends what is ur priority and size of database

Higher Normalization reduces data redundancy but  at the same time the access speed is reduced as no of tables are increased

and so sometimes denormalization is also needed to reduce the complexity in database

in real life scenario mormalization upto 3rd NF is adequate . but people work in 1nf, 2nf also