Re: Higher-order relatioships
From: --CELKO-- <joe.celko_at_trilogy.com>
Date: 29 Jul 2001 10:23:30 -0700
Message-ID: <7e67a7b3.0107290923.37168c35_at_posting.google.com>
Date: 29 Jul 2001 10:23:30 -0700
Message-ID: <7e67a7b3.0107290923.37168c35_at_posting.google.com>
>> How I correctly decompose the following relatioship to binary
relatioships?
Professors teach courses i sections to students. <<
Without any other information and making some assumptions about secitons, will this do it?
- EACH professor TEACHES ONE OR MORE courses
- EACH student IS REGISTERED IN ONE OR MORE section
- EACH section IS TAUGHT ONE AND ONLY ONE course
This means that you find (professor, student) pairs by going to the professor, to the course he teaches, to the sections in that course, to the students in the section. Received on Sun Jul 29 2001 - 19:23:30 CEST