Re: Higher-order relatioships

From: --CELKO-- <joe.celko_at_trilogy.com>
Date: 29 Jul 2001 10:23:30 -0700
Message-ID: <7e67a7b3.0107290923.37168c35@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 - 12:23:30 CDT