Second Normal Form versus Third Normal Form

Solution Preview

Create a table that is 2NF, but is not 3NF. Explain what is wrong with the table, and what needs to be done to correct the situation.
Normalization in database design is a process that helps in checking the quality of relations between or amongst entities in the database. In this process relations with problems are converted to relations with lesser problems or anomalies. This thought leads to the number of normal forms that a database can be designed in. A database generally begins with the First Normal Form as coined by database guru E.F. ...