week 3 - acc5130_CH4-Pt2_DB_Fal10_post

Week 3- - AccountingSystems DesignandControl (Part2 Ms.PamJ.Schmidt PhDCandidate Dept.ofAccounting DataIndependence Subschemasare usedbyprograms

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

View Full Document Right Arrow Icon
Accounting Systems:  Design and Control Chapter 4 – Relational Databases (Part 2) 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
Data Independence Subschemas are used by programs
Background image of page 2
Data Independence Data kept separate from application programs
Background image of page 3

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

View Full DocumentRight Arrow Icon
Controlled Redundancy of Data
Background image of page 4
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
Background image of page 5

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

View Full DocumentRight Arrow Icon
Spontaneous Query Capability
Background image of page 6
Traversing a Relational Database
Background image of page 7

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

View Full DocumentRight Arrow Icon
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”
Background image of page 8
Relationships: Foreign keys (P. 116)
Background image of page 9

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

View Full DocumentRight Arrow Icon
Access Database Query Examples (p.  117-125) Query 1: Simple Query Query 2: Date Ranges Query 4: Expressions
Background image of page 10
Commercial Relational Database Oracle IBM DB2 Microsoft SQL Server Sybase MySQL
Background image of page 11

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

View Full DocumentRight Arrow Icon
Image of page 12
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 / 25

Week 3- - AccountingSystems DesignandControl (Part2 Ms.PamJ.Schmidt PhDCandidate Dept.ofAccounting DataIndependence Subschemasare usedbyprograms

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

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