week 4 - acc5130_CH10_Fal10_Post

week 4 - acc5130_CH10_Fal10_Post - AccountingSystems:...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
Accounting Systems:  Design and Control Chapter 10 – Revenue Cycle Ms. Pam J. Schmidt PhD Candidate Dept. of Accounting School of Business Administration
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
MiniQuiz Solution:  Byteworthy Manufacturing Co. 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# )
Background image of page 2
Normalizing: 1 to Many (1:N) Relationships 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” table:   Department ( Dept# , Dept-name, Reports-to)   Emp (ID# , Emp-name, Sex, Class,  Dept# ) Dept# in the Emp table is called a  foreign key.
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Each employee may be assigned to many work  orders. Each work order may have many employees 
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the 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.

Page1 / 26

week 4 - acc5130_CH10_Fal10_Post - AccountingSystems:...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online