Re: help with normalization
From: Tonkuma <tonkuma_at_jp.ibm.com>
Date: 2 Sep 2005 06:30:02 -0700
Message-ID: <1125667802.811424.40080_at_f14g2000cwb.googlegroups.com>
Date: 2 Sep 2005 06:30:02 -0700
Message-ID: <1125667802.811424.40080_at_f14g2000cwb.googlegroups.com>
I think that you shoud consider to add forein keys and constraints,
before consider normalization.
For Example:
> - a teacher can teach several courses
Add reference to StaffNo(Primary key of Teacher table) to Cource table.
> Course(CourseNo, description, TeacherNo) (TeacherNo reference StaffNo of Teacher table)
Received on Fri Sep 02 2005 - 15:30:02 CEST