Databases and Data Modeling

Databases and Data Modeling - ACCT 404 Accounting...

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

View Full Document Right Arrow Icon
Janice H. Fergusson, CPA Lecturer ACCT 404 Accounting Information Systems ACCT 404 Accounting Information Systems
Background image of page 1

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

View Full DocumentRight Arrow Icon
Databases and Data Modeling
Background image of page 2
A Brief History The land when applications ruled the world An accounting program stores accounting data A marketing program stores marketing data An operations program stores marketing data Databases were part of the application program that nobody ever noticed (or changed)
Background image of page 3

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

View Full DocumentRight Arrow Icon
History, continued If a customer changes an address, it has to be updated in each program Accounting Marketing Operations
Background image of page 4
Problems with the Applications Approach Data Storage Redundancy and duplicate data Data Updating Changes or additions must be performed multiple times Currency of Information Potential problem of failing to update all affected files Task-Data Dependency Files structured, formatted and arranged to suit a specific need. Each user maintains a separate file for their own use Individual data files are not related to other files thus integration is difficult User’s inability to obtain additional information as needs change Difficult to share data Users own rather than share data
Background image of page 5

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

View Full DocumentRight Arrow Icon
The Database Grows Up Moore’s law says: Every 2 years one of two things will happen You’ll get 2x the computer storage memory for the same price The price of your current memory will be cut in half With more disk storage, companies were able to save more data All of this data put the focus on the database Databases were developed as standalone systems Databases became the engine behind application programs Why not make one database for the application programs to feed off of?
Background image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 29

Databases and Data Modeling - ACCT 404 Accounting...

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

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