week 8 - acc130_Ch15_REA-DataModels

week 8 - acc130_Ch15_REA-DataModels - -2-Data ModelingData...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: -2-Data ModelingData ModelingIn a era of software "packages"In a era of software "packages"nIncreasingly, firms use software packages.2Long-term trend in response to issues with customsoftware2Initial cost2Reliability and control2Maintenance2Often, the code is not customized.-4-Data ModelingData ModelingIn an era of software "packages"In an era of software "packages"nWhy study data modeling and database design?2There still are some custom applications.2Selecting software that meets the organization's needs2Need to choose among many setup options2Evaluating applications and controls2Finding and correcting problems in the existing datamodelUnderstanding and documenting businessprocesses-4-Data ModelingData Modeling2If done properly, a semantic data model shouldresult in a fully normalized database structure.2Normalization: How can you do it if you don'tunderstand the semantics (meaning of the data)?2The two approaches are good checks on each other.2Next week: Moving from a semantic data modelto normalized relational databaseFigure 15.1: Data modeling in the database design processNote similarity to SDLC-6-Entity-Relationship DiagramEntity-Relationship DiagramEmployeeWorks...
View Full 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 / 19

week 8 - acc130_Ch15_REA-DataModels - -2-Data ModelingData...

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