Normalization questions...
From: pavel <pavel_at_vancouver.yi.org>
Date: Sun, 21 Jan 2001 04:45:44 GMT
Message-ID: <YPta6.44343$ED.1817141_at_news1.rdc1.bc.home.com>
Date: Sun, 21 Jan 2001 04:45:44 GMT
Message-ID: <YPta6.44343$ED.1817141_at_news1.rdc1.bc.home.com>
Ok from start, I have users table, which has uid as primary key for the record, then there is other table, groups with gid as a key in it. In between there is table that has two fields gid and uid, that basically ties two tables, those fields are indexed. However the third table does not have key field. To locate records within database editor I use keys, to locate a specific record. As far as I understand RDBMS theory you should not "UPDATE" items in KEY fields. If I edit the linking record however, there are no unique keys, so it should not be too much of a problem. But it does collide with what I know about databases.
Pavel
-- "They that give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety" -B.FranklinReceived on Sun Jan 21 2001 - 05:45:44 CET