image db with keywords? n:n or 1:n relation

From: Janning Vygen <vygen(at)planwerk6(dot)de>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: image db with keywords? n:n or 1:n relation
Date: 2001-11-16 08:46:20
Message-ID: 01111609462004.29964@janning
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi folks,

a friend and me are discussing about the following problem:

if you have a small image database and you want to add descriptions
to every image like
"Car" "Smoking Man"

Do you reuse the Keyword Car for every image with a car?? (n:n
relation) or do you have two entries in the description table with
content "car"??

For me it looks like solution with n:n relation is much more
complicated, its not natural, but its normalized.

second solution might not be normalized, but its much easier to
understand and to handle, easier to change a keyword for a given
image.

thanks for any hints or opinions.
janning

Browse pgsql-sql by date

  From Date Subject
Next Message Andriy Pyrozhenko 2001-11-16 09:38:30 Question
Previous Message Otakar Kleps 2001-11-16 08:10:55 Re: Help with RULE