Received: from esper.modulus.org (als.adsl.AlwaysONLINE.net.au [202.181.20.2]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fBBKAQm51272 for ; Tue, 11 Dec 2001 15:10:27 -0500 (EST) (envelope-from andrew@modulus.org) Received: from avon (esper.modulus.org [202.181.1.249]) by esper.modulus.org (Postfix) with ESMTP id 0ECBE3F78; Wed, 12 Dec 2001 07:10:22 +1100 (EST) From: "Andrew Snow" To: "'John Hughes'" Cc: Subject: Re: How would i do this? Date: Wed, 12 Dec 2001 07:09:09 +1100 Message-ID: <001b01c1827f$c03ac8e0$0b00000a@avon> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2616 In-Reply-To: <9v5m86$26uo$1@news.tht.net> Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 X-Archive-Number: 200112/411 X-Sequence-Number: 18512 You'll probably end up forgetting what you know about arrays: I recommend a read through this to get a quick understanding of how things are done in the RDBMS world: http://www.google.com/search?q=cache:-Y8EjJKZgKk:w3.one.net/~jhoffman/sq ltut.html&hl=en#Joins (original site seems to have vanished) Once you have a handle on that, read the PostgreSQL docs for primary/foreign keys and referential integrity. Hope that helps - Andrew > -----Original Message----- > From: pgsql-general-owner@postgresql.org > [mailto:pgsql-general-owner@postgresql.org] On Behalf Of John Hughes > Sent: Wednesday, 12 December 2001 6:22 AM > To: pgsql-general@postgresql.org.pgsql-sql@postgresql.org > Subject: [GENERAL] How would i do this? > > > I am new to DB programming, so im not too sure about how to > implement my DB. > > Coming from a programming background, I could do this in c++ > very easily. I > actually started inmplementing it in a similar fasion: each > student class > teacher ect would have a uniqe id in the database, and, for > example, a > class would include an array of integer student id's.