I have the following table. The PK is model_ID. Assuming that the modelName field is unique(that is, no two brands can have an identical modelName), there is a transitive dependency between modelName and brand.
What is the optimal solution for the table to comply with 3NF, without having the modelName field as part of the PK?
Aucun commentaire:
Enregistrer un commentaire