week 4 - acc5130_CH10_Fal10_3slides

week 4 - acc5130_CH10_Fal10_3slides - 9/20/2010 Accounting...

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

View Full Document Right Arrow Icon
9/20/2010 1 Accounting Systems: Design and Control Chapter 10 – Revenue Cycle Ms. Pam J. Schmidt PhD Candidate Dept. of Accounting School of Business Administration MiniQuiz Solution: Byteworthy Manufacturing Co. Department (Dept# , Dept-name, Reports-to) Emp (ID# , Emp-name, Sex, Class, Dept#) Job-class Clas Rate Job class (Class , Rate) Dependent (ID# , Dep-Name , Dep-age, Relation) Work-order (Dept# , Job# , Job-Desc, Start-date, Costs) Assignment (Job# , ID# ) 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 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 1

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

View Full DocumentRight Arrow Icon
9/20/2010 2 Many to Many (N:N) Relationships Each employee may be assigned to many work orders. Each work order may have many employees
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 9

week 4 - acc5130_CH10_Fal10_3slides - 9/20/2010 Accounting...

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

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