Systems Analysis and Design Entity Life Histories SSADM

  • Slides: 12
Download presentation
Systems Analysis and Design Entity Life Histories

Systems Analysis and Design Entity Life Histories

(SSADM) Data Views System Data Function Structure LDS Sequence DFD ELH

(SSADM) Data Views System Data Function Structure LDS Sequence DFD ELH

Sequence Entity Name Event A Event B Event C

Sequence Entity Name Event A Event B Event C

Selection Employee New Staff Recruited Event D New Trainee Accepted Event E

Selection Employee New Staff Recruited Event D New Trainee Accepted Event E

Iteration Employee New Employee Life Salary Payment Event E

Iteration Employee New Employee Life Salary Payment Event E

Bank Account Entity Bank Account Opened Account Life Account Closure Transaction Pay Deposit Direct

Bank Account Entity Bank Account Opened Account Life Account Closure Transaction Pay Deposit Direct Deposit Cheque Cashed Account Deletion

Employee Entity Employee New Staff Recruited New Trainee Accepted Main Life Salary Payment Possible

Employee Entity Employee New Staff Recruited New Trainee Accepted Main Life Salary Payment Possible Ends Employee Resigns Employee Fired

State Indicators Entity Birth Event Account Life Account Closure -/1 1/2 2/3 State Indicator

State Indicators Entity Birth Event Account Life Account Closure -/1 1/2 2/3 State Indicator Format: valid previous values/value set by event Account Deletion 3/-

Bank Account Entity Bank Account Opened Account Life -/1 Account Closure 1, 2, 3,

Bank Account Entity Bank Account Opened Account Life -/1 Account Closure 1, 2, 3, 4/5 Transaction Pay Deposit Direct Deposit 1, 2, 3, 4/2 1, 2, 3, 4/3 Cheque Cashed 1, 2, 3, 4/4 Account Deletion 5/-

Bank Account Entity Bank Account Opened 1 Account Closure Account Life -/1 Account Deletion

Bank Account Entity Bank Account Opened 1 Account Closure Account Life -/1 Account Deletion 1, 2, 3, 4/5 5 5/6 Transaction Operations List Pay Deposit Direct Deposit 1, 2, 3, 4/2 2 Cheque Cashed 1, 2, 3, 4/3 3 1, 2, 3, 4/4 4 1. Create record with account details 2. Add transaction amount to current balance – code a 3. Add transaction amount to current balance – code b 4. Subtract transaction amount from current balance 5. Replace account status by ‘N’ 6. Delete account record

Following the opening of a bank account, a number of transactions may occur. These

Following the opening of a bank account, a number of transactions may occur. These can be a deposit over the counter, a transfer from another account or a cheque withdrawal. The account must be closed before it can be deleted. Draw an entity life history (ELH) diagram to reflect the above sequence of events. Include status indicators and an operations list.

ENTITY – EVENT MATRIX Order Received Order Payment Received Create Order > 12 months

ENTITY – EVENT MATRIX Order Received Order Payment Received Create Order > 12 months old Delete Goods Despatched Modify Customer Invoice Payment etc … Modify Create etc …