Help needed on Boyce-Codd Normal Form.
From: Kira Yamato <kirakun_at_earthlink.net>
Date: Fri, 14 Dec 2007 06:24:06 -0500
Message-ID: <2007121406240616807-kirakun_at_earthlinknet>
Suppose I want to create a schema for
that enforces
Date: Fri, 14 Dec 2007 06:24:06 -0500
Message-ID: <2007121406240616807-kirakun_at_earthlinknet>
Suppose I want to create a schema for
S = student, J = subject, T = teacher,
that enforces
- For each subject, each student taking that subject is taught by exactly one teacher. But a student can take multiple subjects.
- Each teacher teaches exactly one subject. But a subject can be taught by multiple teachers.
How do you create a schema that is at least BCNF and enforces 1) and 2)?
Thank you.
--
-kira
Received on Fri Dec 14 2007 - 12:24:06 CET