Guide S47 -- Process Modelling Guide

Navigation:

S47 Table of Contents

Appendix B -- Example of Logical Data Model

• Entity Definition

Appendix B -- Example of Logical Data Model

A logical data model of the "sports" area has been included in this document as a reminder that process models and data models are co-dependent. Utilizing both models in business design analysis will provide a higher degree of data integrity and ensure that business informational needs are identified.

Entity Relationship Diagram

Entity Definition

Model : DEMO SPORTS MODEL
Subset: (complete model)
Entity: GAME
Description: Scheduled list of games played or to be played for the current baseball season.
Subject area: DEMO_SPORTS_MODEL
Properties: Min Occ: 0 Avg Occ: 0
Max Occ: 0 Growth Rate: 0% per year
Attributes: DATE, TIME, FIELD, SCORE
Relationships: Sometimes (0%) HAS_VISITING one TEAM, cannot transfer.
Sometimes (0%) HAS_HOME one TEAM, cannot transfer.
Identifiers: DATE, TIME, FIELD

Entity: PLAYER
Description: An individual registered with the organization to play baseball.
Subject area: DEMO_SPORTS_MODEL
Properties: Min Occ: 0 Avg Occ: 0
Max Occ: 0 Growth Rate: 0% per year
Attributes: NAME, POSITION, PHONE_NUMBER, JERSEY_NUMBER
Relationships: Sometimes (0%) IS_DRAFTED_BY one TEAM,cannot transfer.
Identifiers: NAME

Entity: TEAM
Description: Name of a registered team sponsored with the organization to play baseball.
Subject area: DEMO_SPORTS_MODEL
Properties: Min Occ: 0 Avg Occ: 0
Max Occ: 0 Growth Rate: 0% per year
Attributes: NAME, COACH, COACH_PHONE
Relationships: Sometimes (0%) IS_VISITOR_FOR many GAME; Cardinality Min: 1 (est) Max: 1 (est) Avg: 1, cannot transfer.
Sometimes (0%) IS_HOME_FOR many GAME; Cardinality Min: 1 (est) Max: 1 (est) Avg: 1, cannot transfer.
Sometimes (0%) DRAFTS many PLAYER
Cardinality Min: 1 (est) Max: 1 (est) Avg: 1, cannot transfer.
Identifiers: NAME

-- End of Report --

Back to the top | S47 Table of Contents | Data Admin Home Page
Content last modified July, 1996