From: | Vince Vielhaber <vev(at)michvhf(dot)com> |
---|---|
To: | John Hughes <johughes(at)shaw(dot)ca> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: How would i do this? |
Date: | 2001-12-11 20:26:09 |
Message-ID: | Pine.BSF.4.40.0112111522440.96989-100000@paprika.michvhf.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-sql |
On Tue, 11 Dec 2001, John Hughes wrote:
> I am new to DB programming, so im not too sure about how to implement my DB.
>
> Here is what i need: a DB with tables of:
>
> 1. Students.
> 2. Classes
> 3. Teachers
> 4. Assignments
>
> Each teacher can be assigned a class, which is compromised of a list of
> students. Each class can be given assignments.
>
> 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.
>
> This seems really error prone, and not very efficient.
>
> what is a better implementation?
Don't think array. Look at it from the other direction.
Each class has a name (prog101) a room#, teacherid, etc. and a class id.
Each student has a name, etc. and the id of the class they're taking.
Then: select name from student where classid = 4;
Where 4 could be the id for prog101.
That's the REALLY simplified version, but you get the idea.
Vince.
--
==========================================================================
Vince Vielhaber -- KA8CSH email: vev(at)michvhf(dot)com http://www.pop4.net
56K Nationwide Dialup from $16.00/mo at Pop4 Networking
Online Campground Directory http://www.camping-usa.com
Online Giftshop Superstore http://www.cloudninegifts.com
==========================================================================
From | Date | Subject | |
---|---|---|---|
Next Message | wsheldah | 2001-12-11 20:52:48 | Re: How would i do this? |
Previous Message | David A Dickson | 2001-12-11 20:16:45 | Re: How would i do this? |
From | Date | Subject | |
---|---|---|---|
Next Message | Shaun Thomas | 2001-12-11 21:47:25 | Re: How would i do this? |
Previous Message | David A Dickson | 2001-12-11 20:16:45 | Re: How would i do this? |