The OLTP system data for the Fitchwood Insurance Company is in a series of flat

Question

The OLTP system data for the Fitchwood Insurance Company is in a series of flat files. What process do you envision would be needed in order to extract the data and create the ERD shown in Figure 9-21? How often should the extraction process be performed? Should it be a static extract or an incremental extract?

Figure 9-21

POLICY PolicyNo CUSTOMER CustomerlD CustomerName (Address (Street, City, State, Zipcode)) AGENT Type FaceValue AgentiD AgentName DateofHire InForce Commission EffectiveDate Sells_In TERRITORY TerritorylD LastRedistrict Zipcode)

Explanation / Answer

Q1) What process do you envision would be needed in order to extract the data and create the ERD shown in Figure 9-21?

ANS - Data reverse engineering, is the process, which concentrates on data model recovery of legacy systems In many cases, the major goal of data reverse engineering e?orts is to reconstruct the conceptual data model of a database system in the form of an entity-relationship diagram (ERD). Therefore, they are alsocalled database reverse engineering (DBRE).

How often should the extraction process be performed? Should it be a static extract or an incremental extract?

Extraction process depends upon the Data volume being generated and the criticality of the project. Generally extraction process is done based on monthly or quaterly basis for MIS and Reports generation.

Data extraction should be incremental as compared to static because of the following advantages:-

Please let me know in case of any clarifications required. Thanks!

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.