mercredi 28 janvier 2015

How to normalize a table that contains a CK not included in the PK?


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?


table





Aucun commentaire:

Enregistrer un commentaire