Unformatted text preview: table: Department ( Dept# , Dept-name, Reports-to) Emp (ID# , Emp-name, Sex, Class, Dept# ) ± Dept# in the Emp table is called a foreign key. Many-to-Many (N:N) relationship ± Each employee may be assigned to many work orders. ± Each work order may have many employees assigned to it. ± A separate table is needed: Assignment (Job# , ID# )...
View Full Document
This note was uploaded on 01/28/2011 for the course ACC 5130 taught by Professor Schmidt during the Fall '10 term at Wayne State University.
- Fall '10