265 - Chapter 3 Power Point - Part 1

265 - Chapter 3 Power Point - Part 1 - Chapter 3: Logical...

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

View Full Document Right Arrow Icon
Chapter 3: Logical Modeling
Background image of page 1

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

View Full DocumentRight Arrow Icon
Agenda Entity-Relationship Diagrams (ERD) REA Data Flow Diagrams Flowcharts
Background image of page 2
Data Modeling Data modeling is the process of defining a database so that it faithfully represents all aspects of the organization, including its interactions with the external environment. Data Modeling tools include DFDs, Flowcharts, Entity-Relationship Diagrams, the REA Diagram.
Background image of page 3

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

View Full DocumentRight Arrow Icon
Logical design Building a conceptual model of the system Business Process Model Business Process Model – (REA and ERD) Begin by understanding the business process and developing a model of it. From this, develop a model of the two components of a good database system Logical data model Logical data model – (ERD-table specifications) Describes the data that must be stored. Generally, data is needed to plan, execute and evaluate each event in the business process model. However, some items may not be tracked, given the cost/benefit tradeoff of doing so; these are called implementation compromises implementation compromises Logical information process model Logical information process model (DFD and Flowcharts) Describe how the data will be captured and how it will be output
Background image of page 4
Step by Step Process 1. 1. Develop Business Process Model (drawn using Entity Relationship Develop Business Process Model (drawn using Entity Relationship Diagrams, ERDs) Diagrams, ERDs) Focuses on what the business does – all economic and business events Economic events Economic events – Most basic events where we give or get resources (in introductory accounting these were called accounting events) Business events Business events – just support the process leading up to or following economic events 2. 2. Logical Data Model (drawn using ERD) Logical Data Model (drawn using ERD) Evaluate the Business Process model to determine the actual data that will be tracked Double check the completeness of the business process model consider implementation compromises 3. 3. Logical Information Process Model Components (Data Flow Diagrams) Logical Information Process Model Components (Data Flow Diagrams) How will the data in the logical data model be captured, maintained and made available for decision making? What do the programs to capture, maintain and distribute data have to do? Information events Information events – gather, maintain or report information about an economic event, or a resource or agent; not part of the business process or data model
Background image of page 5

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

View Full DocumentRight Arrow Icon
Agenda Entity-Relationship Diagrams (ERD)
Background image of page 6
ENTITY-RELATIONSHIP MODEL (proposed by CHEN, 1976) A detailed logical representation of data for an organization or business area Four Basic Constructs: -Entity -Relationship -Attribute -Cardinality (participation)
Background image of page 7

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

View Full DocumentRight Arrow Icon
ENTITY : Entities are named objects in the universe of discourse Types of entities Thing (truck, building) Person (customer, employee) Event
Background image of page 8
Image of page 9
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 08/12/2008 for the course ACCY 265 taught by Professor Liu during the Spring '08 term at CSU Sacramento.

Page1 / 64

265 - Chapter 3 Power Point - Part 1 - Chapter 3: Logical...

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

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