Database Normalization continued

[artisticre]

I am really trying to understand database normalization. I would appreciate someone looking at this and 1. Telling me if it is ok or not and 2. Showing me the correct way to normalize it. I learn better from examples. Thanks for any help in advance

Producer
ProducerID
producer
description
label
picture

VarietalType
VarietalTypeID
ProducerID
varietal
type
vintage

Available
AvailableID
ProducerID
available
region
country

Rating
RatingID
ProducerID
rating
portfolio
volume
caseprice
bottleprice

[bad76]

Hi,
It's not bad.

Another way may be this:

Producer
ProducerID
producer
description
label
picture
VarietalTypeID
AvailableID
RatingID

VarietalType
VarietalTypeID
varietal
type
vintage

Available
AvailableID
available
region
country

Rating
RatingID
rating
portfolio
volume
caseprice
bottleprice

And any other with both, main id in sub tables and sub id in main tables.

The choice of this way depend on QUERY you must call.
One way it's better for some query, two way for other query. Both for all query, but there is more work for copy ID in all tables.

Just an hint: calling the table with plural may be helpfull (Producers instead Producer (that is equals to field name...))

see you