How to normalize a table that contains a CK not included in the PK?
Model name does not need to be part of the PK.  The problem with this table is brand. "Scott" is repeated. Model relies on Brand, but brand does not rely on model. 

Create a brand table. Turn the Model.brand to Brand_FK.