week 3 - byteworthysol

week 3 - byteworthysol - table Department Dept Dept-name...

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

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.

Ask a homework question - tutors are online