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@earthlinknet>

Suppose I want to create a schema for

	S = student,
	J = subject,
	T = teacher,

that enforces

1. For each subject, each student taking that subject is taught by exactly one teacher. But a student can take multiple subjects.
2. 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 - 05:24:06 CST