week 3 - acc5130_CH4-Pt2_DB_Fal10_3slides+note

week 3 - acc5130_CH4-Pt2_DB_Fal10_3slides+note - 9/16/2010...

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

View Full Document Right Arrow Icon
9/16/2010 1 Accounting Systems: Design and Control Chapter 4 – Relational Databases (Part 2) Ms. Pam J. Schmidt PhD Candidate Dept. of Accounting School of Business Administration Data Independence Subschemas are used by programs Data Independence Data kept separate from application programs
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/16/2010 2 Controlled Redundancy of Data How Databases Promote Greater Productivity Reduces effort to maintain software applications Speeds up the software development process Easier prototyping Programs access data via standard database mechanisms Easier access to data Ad hoc queries Standard reports Spontaneous Query Capability
Background image of page 2
9/16/2010 3 Traversing a Relational Database Queries: Traversing a Relational Database Query Example: Select Emp-Name, Emp-Addr, SSN, Rate*Hours From Emp, Timecard Where SSN.Emp=SSN.Timecard and Pay-Date = “04152012” Relationships: Foreign keys (P. 116)
Background image of page 3

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

View Full DocumentRight Arrow Icon
9/16/2010 4 Access Database Query Examples (p. 117-125) Query 1: Simple Query
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.

Page1 / 9

week 3 - acc5130_CH4-Pt2_DB_Fal10_3slides+note - 9/16/2010...

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