04_Data_Modeling

04_Data_Modeling - Econ 185 Lecture 04 Econ 185 Glenn Owen...

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

View Full Document Right Arrow Icon
Econ 185 Lecture 04 1 Econ 185 Glenn Owen UC Santa Barbara 1. 1 ` Databases ` REA Models ` Resources ` Events ` Agents ` RE Diagram – Sales ` RE Diagram - Purchasing 2 ` Collections of related data ` Fields ` Records ` Tables ` Database 3
Background image of page 1

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

View Full Document Right Arrow Icon
Econ 185 Lecture 04 2 ` Identify business and economic events ` Identify entities – agents & resources ` Identify relationships among entities ` Create ER diagrams ` Identify attributes of data entities ` Create database tables and records 4 ` Economic – impact financial statements Sale on account Purchase of inventory on account ` Business – impact an organization in a value- Business impact an organization in a value added way Sales order Purchase order 5 ` Events use or generate resources ` Object of value associated with an event ` Object of interest to collect information ` Examples: Examples: Inventory Cash ` Not examples: Accounts receivable 6
Background image of page 2
Econ 185 Lecture 04 3 ` Agents are the “who” associated with events 7 8 9
Background image of page 3

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

View Full Document Right Arrow Icon
Econ 185 Lecture 04 4 10 Describe the meaning of each of
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 6

04_Data_Modeling - Econ 185 Lecture 04 Econ 185 Glenn Owen...

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

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