Re: Data Redundancy

From: -CELKO- <jcelko212_at_earthlink.net>
Date: 15 Feb 2006 20:36:37 -0800
Message-ID: <1140064597.001752.311140_at_g43g2000cwa.googlegroups.com>


CREATE TABLE DeptAssignments
(emp_id CHAR(1) NOT NULL

    REFERENCES Personnel(emp_id)
 dept_nbr INTEGER NOT NULL

    REFERENCES Departmentsl(dept_nbr),
 PRMARY KEY (emp_id, dept_nbr)); Received on Thu Feb 16 2006 - 05:36:37 CET

Original text of this message