80 likes | 1.64k Views
Entity Life History Simple Life. Bank Account. Account Opened. Account Life. Account Closure. Account Deletion. Sequence. *. Transaction. Iteration. o. o. o. Pay Deposit. Direct Deposit. Cheque Cashed. Selection. Time. Entity Life History - Parallel Lives.
E N D
Entity Life HistorySimple Life Bank Account Account Opened Account Life Account Closure Account Deletion Sequence * Transaction Iteration o o o Pay Deposit Direct Deposit Cheque Cashed Selection Time
Entity Life History - Parallel Lives Consider the following EVENTS which affect an entity PART: 1. Someone makes a decision to stock a PART 2. A supplier delivers stock against an order for the PART 3. A customer places an order to buy the PART 4. Someone decides that the PART should be superseded 5. Someone decides to stop stocking the PART
Entity Life History for PART Part R1 Discontin-uance Shelf-life Stocking Delivery Sale Super- session o o Q1 Safety Normal
Entity Event Matrix Entity Appli. History Employee Car Claim Journey Grade Event Register authorised user C C Register change of job M C Register change of car C C/M C Register claim Check journey details C/D NOTE: If an entity is never created then something has been missed e.g. Grade in this example.
Complete ELH Car Allowance System Employee Pay-no Name Address Job-title Job-location Salary-grade Current-allowance-grade Date-authorised-driver Driver-test-results Employee Initial authorisation Mid-life Leave company 2 5 1 4 3 9 1,2,4,5/6 -/1 * Authorisation cycle Operations list 1. Store keys 2. Store remaining attributes 3. Gain car entity 4. Tie to grade entity 5. Store grade using grade calculation 6. Replace grade using grade calc. 7. Replace job detail attributes 8. Replace employee details 9. Cut from grade entity o o o Change employee details Change car Change job 7 6 6 8 1,2,4,5/3 1,2,4,5/2 3/4 1,2,4,5/5