Re: Clarity needed

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



2009/2/4 tedd <tedd@xxxxxxxxxxxx>

> Hi gang:
>
> I need some fog removed.
>
> I have a problem where I have an unlimited number of tutors teaching an
> unlimited number of courses. When I call upon a tutor, I want to see all the
> courses they teach.
>
> In my old days, I would just set up a linked list of courses and attach it
> to the tutor (another linked list). As a tutor adds courses, I would just
> add the course to the end of the linked list. If the tutor deletes a course,
> then I would remove it from the list by changing a single pointer. If I
> needed a list of all the courses the tutor taught, I would just run down the
> linked list pulling them out as needed.
>
> But now I have to think in terms of records in a database. I'll eventually
> figure it out, but what are your suggestions/solutions?
>
> I understand that I can have one record set up for each tutor, and another
> record set up for each course, and then tie the two together by another
> record like an assignment. That way I can have as many assignments as I want
> tying courses to tutors.
>
> It that the way you guys would do it?
>
> Thanks,
>
> tedd


Hey,

as you said I would suggest 3 tables, one for the tutors, one for the
courses and the third, relational table for connecting tutors and courses.
I think this is the most flexible way you can do this.

-eddy

[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux