Putting a Database in Third Normal Form (3NF)

The purpose of 3NF is to improve database processing while also minimizing storage costs.

Well, could LastName depend on FirstName?

No, because nothing inherent in LastName would suggest the value of FirstName.

Could FirstName depend on LastName?

Therefore, this table is 3NF compliant.

This table design is non-3NF compliant, and could, therefore, result in data anomalies.

For example, you might update the manufacturer without updating the model, introducing inaccuracies.

This would result in two tables, which we’ll call Vehicles and Models.

You must remove Total from the table to comply with the third normal form.