week 3 - byteworthysol

week 3 - byteworthysol - table: Department ( Dept# ,...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
1 Byteworthy Manufacturing: Solution Department (Dept# , Dept-name, Reports-to) Emp (ID# , Emp-name, Sex, Class, Dept#) Job-class (Class , Rate) Dependent (ID# , Dep-Name , Dep-age, Relation) Work-order (Dept# , Job# , Job-Desc, Start-date, Costs) Assignment (Job# , ID# ) One-to-Many (1:N) Relationship ± Each department may have many employees. ± Each employee is assigned to only one department. ± The key of the “one” table is added to the “many”
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

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

Ask a homework question - tutors are online