From: Janning Vygen <vygen@planwerk6.de>
To: pgsql-sql@postgresql.org
Subject: image db with keywords? n:n or 1:n relation
Date: Fri, 16 Nov 2001 09:46:20 +0100
Message-ID: <01111609462004.29964@janning> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: vygen@planwerk6.de
Subject: Re: image db with keywords? n:n or 1:n relation
In-Reply-To: <01111609462004.29964@janning>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox