from a structural point of view, 3nf is better than 2NF.A relational database design technique called third normal form (3NF) employs normalization principles to eliminate data duplication,
3nf avoid data anomalies, guarantee referential integrity, and streamline data administration. Edgar F. Codd, an English computer scientist who developed the relational paradigm for database administration, gave it a definition in 1971. If all of the characteristics (such as database columns) are functionally reliant on the primary key alone, a database relation (such as a database table) is considered to comply with third normal form criteria. This is a relation, according to Codd, in second normal form, where all non-prime characteristics rely solely on the candidate keys and do not have transitive dependencies on other keys.
learn more about database here:
https://brainly.com/question/29412324
#SPJ4
