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

Поиск
Список
Период
Сортировка
От Janning Vygen
Тема image db with keywords? n:n or 1:n relation
Дата
Msg-id 01111609462004.29964@janning
обсуждение исходный текст
Список 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


В списке pgsql-sql по дате отправления:

Предыдущее
От: frbn@efbs-seafrigo.fr
Дата:
Сообщение: SELECT * FROM t where p or q;
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Foreign Key Constraint Deletion Order