Received: from unixserv.rz.fh-hannover.de (root@rzgw.rz.fh-hannover.de [141.71.1.10]) by hub.org (8.9.3/8.9.3) with SMTP id CAA46453 for ; Mon, 31 May 1999 02:46:10 -0400 (EDT) (envelope-from wilms@stud.fh-hannover.de) Received: from schering.si2.uni-hannover.de by unixserv.rz.fh-hannover.de (AIX 3.2/UCB 5.64/4.03) id AA25214; Mon, 31 May 1999 08:52:32 +0200 Sender: wilms@unixserv.rz.fh-hannover.de Message-Id: <37522E99.4187A2E@stud.fh-hannover.de> Date: Mon, 31 May 1999 08:39:22 +0200 From: Heiko Wilms Organization: Schering-Institut X-Mailer: Mozilla 4.5 [en] (X11; I; Linux 2.0.35 i586) X-Accept-Language: en Mime-Version: 1.0 To: "pgsql-sql@postgreSQL.org" Subject: Database Design question Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi, trying to redisign a database with the ER-model, I now have some N:N relations. I solved this by using arrays in some cases but querying gets very complex then. What is a "common" way to treat N:N relations? Thanks in advance. Heiko -- H. Wilms Homepage schering.si2.uni-hannover.de/hugo email wilms@stud.fh-hannover.de