1 / 9

ECD Construction Example

ECD Construction Example. From Weaver. Start off with…. The ERD (or extract of) the system. Delivery. Delivery Slot. Delivery Line. Purchase Order Line. Step one.

zada
Download Presentation

ECD Construction Example

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. ECD Construction Example From Weaver

  2. Start off with… • The ERD (or extract of) the system Delivery Delivery Slot Delivery Line Purchase Order Line

  3. Step one • Identify all data entities which are effected by the event (in this case “Arrange Delivery”) – use the effects from the ELH and/or EEM. Also define the entry point (“Delivery”) Delivery Delivery Slot Delivery Line Purchase Order Line

  4. Step two • Identify simultaneous effects for the event in question – i.e. effecting more than one occurrence of data entity in different ways . This would give rise to a separate box for each entity role. Stock [merged] Please note: This is a disjoint example taken from another LDM Stock [resulting]

  5. Step three • Identify where an event affects a data entity in one or more mutually exclusive ways – add these effects as options under the data entity. These can be discerned from ELH roles listed in round brackets. Delivery o o Existing New

  6. Step four • Identify data entities affected iteratively (i.e. repeatedly) by the event. Set of Delivery lines Set of Delivery slots Delivery * * o o Existing New Delivery line Delivery slot Purchase Order line

  7. Step five • Identify one-to-one effects and connect with double-sided arrow lines. The question to ask for each entity is… For each affected occurrence of this entity, is there a directly related occurrence, or set of occurrences) in any of the other entities that is also affected by the event in question? Set of Delivery lines Delivery * o o Set of Delivery slots Delivery line Existing New * Delivery slot Purchase Order line

  8. Step six • Add non-updated data entities (none in this example, but…) Set of Delivery lines Delivery * o o Set of Delivery slots Delivery line Existing New * Delivery slot Purchase Order line Product Imagine if we required product details One every delivery line (hypothetical)

  9. Step seven (last step) • List the event data at the ECD entry point. Include entity key and any data fields required for update. Delivery ID Slot ID P.O. No. P.O. Line No. Quantity : : Delivery : : : :

More Related