University of Jordan Case Tool (Uj-Case- Tool) for Database Reverse Engineering

The database reverse engineering problems and solving processes are getting mature, even though, the academic community is facing the complex problem of knowledge transfer, both in university and industrial contexts. This paper presents a new CASE tool developed at the University of Jordan which addresses an efficient support of this transfer, namely UJ-CASE-TOOL. It is a small and self-contained application exhibiting representative problems and appropriate solutions that can be understood in a limited time. It presents an algorithm that describes the developed academic CASE tool which has been used for several years both as an illustration of the principles of database reverse engineering and as an exercise aimed at academic and industrial students.

Authors:

• Fawaz A. Masoud
• Heba_tallah Khattab
• Mahmoud Al-Karazoon

Keywords:

• Reverse engineering
• ERD
• DBRE
• case tools.

References:

[1] Abraham Silberschatz, Henry F. Korth and S. Sudarshan, "Database
System Concepts", McGraw-Hill, 5th edition, 2006.
[2] Ian Somerville," Software Engineering", 7th edition, Addison Wesley,
2004.
[3] Case Studio, http://www.casestudio.com.
[4] Jean-Luc Hainaut, "Database Reverse Engineering, University of
Namur-Institute d'Informatique", Belgium, 1998.
[5] Power Designer http://is.twi.tudelft.nl.