Lecture 7 Cardinalities Student

Lecture 7 Cardinalities Student - REA Modeling...

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

View Full Document Right Arrow Icon
REA Modeling Entity-Relationship Notation
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 :  REA Modeling Add attributes and participation  cardinalities to the model Practice determining cardinalities  Identify types of relationships based on  cardinalities
Background image of page 2
Basic REA Template Resource (decreased) Resource (increased) Event (decrement) Event (increment) Internal Agent External Agent Internal Agent External Agent duality Stock-flow Stock-flow participation participation participation participation
Background image of page 3

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

View Full DocumentRight Arrow Icon
REA Template-4 Events Proposition Rel. Fullfillment Rel. Reservation Rel. Fullfillment Rel. Stockflow Rel Duality Rel. Stockflow Rel Inventory (Mutual) Commitment Event Internal Agent 2 External Agent Non-cash Economic Event Cash Internal Agent 3 Cash Economic Event Internal Agent 4 Instigation Event Internal Agent 1
Background image of page 4
    Constructs of Entity-Relationship Notation •Entities • An “instance” of an entity is one member of  the set. • Describe one “instance” of customer. • Describe one “instance” of sale. Customer Sale .
Background image of page 5

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

View Full DocumentRight Arrow Icon
•Relationships •Associations between two or more entities •Represented by diamond shape symbol    Constructs of Entity-Relationship Notation Customer Sale is made to
Background image of page 6
Constructs of Entity-Relationship Notation •Attributes •Characteristics of an entity or relationship •Represented by small circle symbol •Primary key attribute circle is darkened Customer ID # Name Phone
Background image of page 7

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

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

This note was uploaded on 01/31/2012 for the course ACC 361 taught by Professor Eighme during the Fall '10 term at Miami University.

Page1 / 25

Lecture 7 Cardinalities Student - REA Modeling...

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

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