What is reverse engineering and how well does it work?

What will be an ideal response?


Reverse engineering (RE) is the process of reading the database schema of an existing database and using it to reconstruct a data model of the database. It works fairly well, but does have significant limitations. First, RE produces conceptual schema errors because it creates an entity for every table in the database including intersection tables in N:M relationships which would not be an entity in the original data model. Second, it does not generate internal schema information such as referential integrity constraints. Therefore, the result, which the authors call the RE data model, is a good starting point for analyzing an existing database but is not a complete solution.

Business

You might also like to view...

A retailer that sells designer clothes and accessories has a pop-up ad on Facebook that features their new collection. Which method for satisfying customers' hedonic needs has been used?

A. Consideration set B. Status and power C. Stimulation D. Conversion rate E. Adventure

Business

A ______ philosophy is a set of principles used to decide what is right or wrong.

A. ethics B. selective C. cognitive D. moral

Business

Organizational commitment should decrease the likelihood that an individual will respond to a negative work event with

A. exit or loyalty. B. exit or voice. C. neglect or voice. D. loyalty or neglect. E. exit or neglect.

Business

Which of the following is not an element of the fraud triangle?

A. Reliance B. Rationalization C. Pressure D. Opportunity

Business