Re: Data Redundancy
From: paul c <toledobythesea_at_oohay.ac>
Date: Thu, 16 Feb 2006 04:44:53 GMT
Message-ID: <9rTIf.15696$B94.10846_at_pd7tw3no>
Date: Thu, 16 Feb 2006 04:44:53 GMT
Message-ID: <9rTIf.15696$B94.10846_at_pd7tw3no>
-CELKO- wrote:
> 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));
>
shorter reply than usual even if it doesn't rhyme with redundancy.
well done, i guess.
pc Received on Thu Feb 16 2006 - 05:44:53 CET