SPECTRUM SUPPLIES

GROUP __

REA MODEL

Step 1: Identify the significant business events

Acquisitions

Inventory Management

Sales

Fixed assets

Human Resource Management

Services

Leasing

Cash


Step 2: Identify the related resources

Acquisitions

Inventory Management

Sales

Fixed assets

Human Resource Management

Services

Leasing

Cash


Step 3: Identify the related internal and external agents

Acquisitions

Inventory Management

Sales

Cash


Fixed assets

Human Resource Management

Services

Leasing

Step 4: Identify relationships between entities

Acquisitions


Inventory Management


Sales


Fixed Assets


Human Resource Management


Services


Leasing


Step 5: Specify the optionalities and cardinalities of the relationships

Acquisitions


Inventory Management


Sales


Fixed Assets


Human Resource Management


Services


Leasing


Step 6: Identify the attributes of the REA entities

Acquisitions


Inventory Management


Sales
Fixed Assets


Human Resource Management


Services


Leasing


Step 7: Design the data repository structure

Acquisitions


Inventory Management


Sales


Fixed Assets


Human Resource Management


Services


Leasing


Step 8: Specify the information processes

Acquisitions

Context Diagram


Level 0 DFDs – Recording


Level 0 DFDs – Maintaining


Level 0 DFDs – Reporting


Inventory Management

Context Diagram


Level 0 DFDs – Recording


Level 0 DFDs – Maintaining


Level 0 DFDs – Reporting


Sales

Context Diagram


Level 0 DFDs – Recording


Level 0 DFDs – Maintaining


Level 0 DFDs – Reporting


Fixed Assets

Context Diagram


Level 0 DFDs – Recording


Level 0 DFDs – Maintaining


Level 0 DFDs – Reporting


Human Resource Management

Context Diagram


Level 0 DFDs – Recording


Level 0 DFDs – Maintaining


Level 0 DFDs – Reporting


Services

Context Diagram


Level 0 DFDs – Recording


Level 0 DFDs – Maintaining


Level 0 DFDs – Reporting


Leasing

Context Diagram


Level 0 DFDs – Recording


Level 0 DFDs – Maintaining


Level 0 DFDs – Reporting


Step 9: Implement the design

Microsoft Access!

62