Our goal is to create a database that is minimally in third normal form (3 NF).
A database is in third normal form if it is in second normal form and contains no transitive dependencies - i.e., no relationships in which data field A determines data field B.