{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

week 8 - acc130_Ch15_REA-DataModels

week 8 - acc130_Ch15_REA-DataModels - Data Modeling In a...

Info icon This preview shows pages 1–8. Sign up to view the full content.

View Full Document Right Arrow Icon
Image of page 1

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

View Full Document Right Arrow Icon
-2- Data Modeling Data Modeling In a era of software "packages" In a era of software "packages" n Increasingly, firms use software packages. 2 Long-term trend in response to issues with custom software 2 Initial cost 2 Reliability and control 2 Maintenance 2 Often, the code is not customized.
Image of page 2
-4- Data Modeling Data Modeling In an era of software "packages" In an era of software "packages" n Why study data modeling and database design? 2 There still are some custom applications. 2 Selecting software that meets the organization's needs 2 Need to choose among many setup options 2 Evaluating applications and controls 2 Finding and correcting problems in the existing data model Understanding and documenting business processes
Image of page 3

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

View Full Document Right Arrow Icon
-4- Data Modeling Data Modeling 2 If done properly, a semantic data model should result in a fully normalized database structure. 2 Normalization: How can you do it if you don't understand the semantics (meaning of the data)? 2 The two approaches are good checks on each other. 2 Next week: Moving from a semantic data model to normalized relational database
Image of page 4
-5- Figure 15.1: Data modeling in the database design process Note similarity to SDLC
Image of page 5

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

View Full Document Right Arrow Icon
-6- Entity-Relationship Diagram Entity-Relationship Diagram E m p l o y e e W o r k s o n P r o j e c t m Entity: Something about which we store data 2 Don't expect one documentation method to model everything.
Image of page 6
-7- Entity-Relationship Diagram Entity-Relationship Diagram E m p l o y e e P r o j e c t W o r k s o n m Author's notation: Don't show the diamond.
Image of page 7

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

View Full Document Right Arrow Icon
Image of page 8
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}