A Rare Example of Pitfall in Corporate Data Modeling Practices for information systems
Although Entity Relationship Model have turned out to be de facto corporate data modeling vehicle, current exercise for its application to real-world business processes is disclosed to surprisingly face a pressing peril of an alarming level in terms of data consistency and the degree of unnecessary data redundancy. In this paper, the matter-of-fact legacy practice, once thought to be a confidential or secret, obtained from some major broadcasting company is articulately reported and its demerits as well as its antagonistic side effect due to abnormality are discussed in depth. We were able to remold such an ill-manifested case to a legitimate ER model vindicated through an endeavor of a couple of months long. The two cases then are compared both qualitatively and quantitatively. The result of analysis has shown that illformed data models contain more than a ratio of 40 percent of unnecessary data redundancy, which leads us to have an implication that it is heavily contingent to seek a corrective measure for cutting down the ratio.
