This preview shows page 1. Sign up to view the full content.
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
- Fall '10