Question

In: Computer Science

Redesigning a database involves the process of reverse engineering a legacy database to create a data...

Redesigning a database involves the process of reverse engineering a legacy database to create a data model. There are a host of software tools available to assist with this process. Identify 2 separate tools that will reverse engineer an existing database. What database management systems (Microsoft SQL, Oracle, MySQL, DB2…) will this system work with (list all that apply)? Briefly describe how the tools work for reverse engineering an existing database and the output that the tool provides.

Solutions

Expert Solution

ANSWER Reverse Engineering of Database-

Reverse database engineering is the process by which the logical and conceptual schemas of an old database or set of files are reconstructed from various sources of information, such as DDL code, data dictionary content, database content, or the source code of the application programs that use the database.

· Separate tools that will reverse engineer an existing database are given below –

1. DATAEDO

2. dbFORGE

· Dataedo works for the following Database Management Systems-

SQL, Oracle, Azure Database, Amazon Redshift

· dbFORGE works for following Database Management Systems-

SQL server, Oracle

Other reverse engineering tools are SchemaSpy, Adminer, Navicat Data Modeler. But dataedo and dbforge are most popular tools.

Dataedo working-

1)To reverse engineer database, go to the Database menu and choose the Reverse Engineer option ...

2) Provide the database connection details and click Next. Wait for the connection and click Next again.

3) When you have successfully logged in, the wizard will show you the list of schemes available on the server. Select the ones you want to reverse.

4) Wait for the diagrams to be read and continue with Next. On the next screen, you have an option to select object types and filter specific objects. Ignore it and import all the objects. Click Execute>.

5) Wait for the reverse technique to occur when you're done with Next. The final screen shows you a summary of the import. Close with Finish.

dbForge working- It uses drag and drop for the reverse engineering process.

Drag and drop is done with the help of visual database representation.

All existing objects and connections will be perfectly reflected in the MySQL database diagram to simplify further analysis.

please give a thumbs up if you are satisfied with my answer. Thank you.


Related Solutions

Database design is the process of producing a detailed data model of database. This data model...
Database design is the process of producing a detailed data model of database. This data model contains all the needed logical and physical design choices and physical storage parameters needed to generate a design in a data definition language, which can then be used to create a database. (Wikipedia). Using a diagram/chart software, elaborate a database design Requirements: Define your database objective Explain your database's type of table relationship Explain and design your database elements and datatypes (tables, fields, etc,)....
What is the relationship between law, ethics, and reverse engineering? Why is reverse engineering a subject...
What is the relationship between law, ethics, and reverse engineering? Why is reverse engineering a subject for regulation or ethical questions?
What type of database software would be ideal for a clinical data warehouse that involves several...
What type of database software would be ideal for a clinical data warehouse that involves several organizations?
Create the Database: The data is the same as was described in the ER Design Project...
Create the Database: The data is the same as was described in the ER Design Project assignment. In that assignment you were asked to map the ER diagram to relations in the database. Here is a formal description of the relations that you will use in this assignment: streamTV Database Relations shows(showID, title, premiere_year, network, creator, category) episode(showID, episodeID, airdate, title) showID is a foreign key to shows actor(actID, fname, lname) main_cast(showID, actorID, role) showID is a foreign key to...
Evaluation of an engineering project involves the following constraints ?
Evaluation of an engineering project involves the following constraints ?A) financial, environmental, social and political constraints.B) technical and financial constraints.C) technological and social constraints.D) time and money constraints. E) budget and time constraints.
Engineering/ programming in MATLAB and it also involves a physics
Engineering/ programming in MATLAB and it also involves a physics
PartA: Create the database. Name the database doctorWho. Then create a page that allows Doctor Who’s...
PartA: Create the database. Name the database doctorWho. Then create a page that allows Doctor Who’s assistant to add a new patient record. You will need to give the assistant rights to this database. The assistant’s username is 'helper' and the password is 'feelBetter'. For this to work, you will need to create several pages so be sure to include all of them when submitting your work. Name the main page addPatient.php. PartB: Add at least five records to the...
Database exercise: inpatient cases Create database using name RUMKIT Create tables below in that database patient(idPatient,...
Database exercise: inpatient cases Create database using name RUMKIT Create tables below in that database patient(idPatient, fullName, biologicalMother, birthdate, address) doctor(idDr, fullName, specialization, consulRates) inpatient(idPatient, entryTime, outTime, idDr, idRoom). Please make entryTime as column that is going to be filled automatically when care record is being add room(idRoom, roomName, cost) fill the data above to each table Create sql query and relational algebra expressions for the query Please give me detailed answer so I could learn from it. Thank you...
Data Modelling is the primary step in the process of database design. Compare and contrast Conceptual...
Data Modelling is the primary step in the process of database design. Compare and contrast Conceptual data model versus Physical data model. Illustrates with help of example to list down data (entities), relationship among data and constraints on data.
Data Modelling is the primary step in the process of database design. Compare and contrast Conceptual...
Data Modelling is the primary step in the process of database design. Compare and contrast Conceptual data model versus Physical data model. Illustrates with help of example to list down data (entities), relationship among data and constraints on data.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT