Tables design question

[JORGE MALDONADO]

I have the following tables:
* courses
* prerequisites
* corequisites

The table "courses" has general data about school courses.
The table "prerequisites" has data about courses that must already have
been taken for a certain course.
The table "corequisites" has data about courses that must be taken at the
same time that another course.

This means that a course might have zero or more "prerequisites" and zero
or more "corequisites" and both point to "courses".

The image below show what I think should be done.
I will very much appreciate any feedback about my approach.




Best regards,
Jorge Maldonado

[David G. Johnston]

Post by JORGE MALDONADO
The table "corequisites" has data about courses that must be taken at the
same time that another course.

I would consider setting up corequisites as (id serial,
course_group_members integer[]) with an exclusion constraint that no
course_id can appear in more than one array.

David J.